Archive for the ‘Web Software’ Category


We will be posting many tips on managing your database as well as tips on managing your web hosting environment. This first tip is on MS SQL Server databases. Here you go —  free on us — compliments of http://www.sozohosting.com/ and also compliments of http://www.biznesstechnologies.com/ :

Web Hosting And Database Tip 1

It is your responsibility to control your MS SQL database log size. If it gets too big for the Size you have allotted then you will get an error in your application. You can fix this different ways. You could run this in a query window but this is a 1 time event:

BACKUP LOG YourDatabase WITH TRUNCATE_ONLY
DBCC SHRINKFILE(YourDatabase_log, 2)

Replace the text “YourDatabase” with your database name and replace the number 2 with the MB size you want to shrink your log file down to. Use 2 as your minimum as that will reduce your database log file to 2 MB. After replacing the text with your database name and setting the MB size of the log file, execute both SQL lines above together.

You could add this SQL call below to call if more often dynamically adding

BACKUP LOG YourDatabase WITH TRUNCATE_ONLY
DBCC SHRINKFILE(YourDatabase_log, 2)

in your application code, replacing the “YourDatabase” text with your database name and setting the size of the log file, and executing this SQL dynamically. Best case is to add these 2 lines of SQL script above to a stored procedure and schedule the stored procedure to run nightly. Of course you want to back your database up before your run this script if you want to maintain a copy of your full sized log file.

Or you could add a stored proc and call it on a regular basis after you run your database backups. Here is an example of a stored proc for MS SQL 2008 databases to shrink the log file to 1 MB:

USE [YourDatabase]
GO
/****** Object: StoredProcedure [dbo].[SRINK_Log_File_To_1MB] Script Date: 12/15/2011 10:00:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SRINK_Log_File_To_1MB] AS
BEGIN

— Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE YourDatabase

SET RECOVERY SIMPLE

— Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (2, 1); — here 2 is the file ID for trasaction log file,you can also mention the log file name (dbname_log)

— Reset the database recovery model.
ALTER DATABASE YourDatabase

SET RECOVERY FULL

END



Here is a firm that is offering no set up fees for Microsoft Mail Exchange Hosting until the end of this 2011 year:

Exchange email is an enterprise email solution that offers a better way to share email, calendar and contact information so you can get more done. Sync your mobile devices, anti-spam and more.

For more information about this promotion, click on this link: Microsoft Mail Exchange Hosting


Dec 5

In order to set email alerts in Cacti you need to install the Cacti Plugin Architecture. This can be found at http://docs.cacti.net/manual:087:1_installation.9_pia#installing_plugins, this is a good document for instructions on how to install and add plugins. Once this is installed be sure to go under the Utilities section of Cacti and select User Management. Once in User Management you will need to select the users you would like to have the ability to set Thresholds. You would do this by selecting the user, go to the realm permissions tab, then put a check on the Thresholds you would like to allow the user to have access to. Next hit save and you are done.

Also I found a little gotcha on the installation that had me stuck for a few hours. When you are on the final stages of the installation of the plugin architecture make sure you have the settings plugin installed. This plugin should be set in the config.php as ($plugins[] = ’settings’; ) . Also you do not need to add other plugins to the config.php , just load them in the /cacti/plugins directory . Then once they are there go to the configuration section , plugin management and the plugin will appear.

Hope this helps!

 

 



It is your responsibility to control your MS SQL database log size. If it gets too big for the Size you have allotted then you will get an error in your application. You can fix this one of different ways. One way is Changing Your Database Data/Log Ratio in your hosting control panel section if you have that function from your hosting provider. The second is to execute the following SQL commands(after you back up your database) together from MS Query Analyzer or MS SQL 2005 Server Management Studio which is logged on to your database:

BACKUP LOG YourDatabase WITH TRUNCATE_ONLY
DBCC SHRINKFILE(YourDatabase_log, 2)

Replace the text “YourDatabase” with your database name and replace the number 2 with the MB size you want to shrink your log file down to. Use 2 as your minimum as that will reduce your database log file to 2 MB. After replacing the text with your database name and setting the MB size of the log file, execute both SQL lines above together.

The third way to solve this issue is to place this SQL :

BACKUP LOG YourDatabase WITH TRUNCATE_ONLY
DBCC SHRINKFILE(YourDatabase_log, 2)

in your application code, replacing the “YourDatabase” text with your database name and setting the size of the log file, and executing this SQL dynamically. Best case is to add these 2 lines of SQL script above to a stored procedure and schedule the stored procedure to run nightly. Of course you want to back your database up before your run this script if you want to maintain a copy of your full sized log file.

Things changed for SQL Server 2008. He is a way to handle it for SQL Server 2008 databases:

CREATE PROCEDURE [dbo].[SRINK_Log_File_To_1MB] AS
BEGIN

— Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE YourDatabase

SET RECOVERY SIMPLE

— Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (2, 1); — here 2 is the file ID for trasaction log file,you can also mention the log file name (dbname_log)

— Reset the database recovery model.
ALTER DATABASE YourDatabase

SET RECOVERY FULL

END

For more info visit this link: http://www.sozohosting.com/knowledge/DatabaseQuestions.cfm



Whatever Accounting Package you use (such as QuickBooks), set up different sales accounts by sector that you sell to. One sales account could be contract sales ( face to face sales), another sales account could be online e-commerce sales, another could be sales by territory (i.e. State or Country). Then set up Cost of Goods Sold Expenses accounts to match these new sales accounts in your Accounting package.    Enter Cost of Goods Sold expenses that relate to that Sales sector only.

Now you can get a gross profilt per sales sector picture using  Sales Sector less Cost of Goods Sold Expense Sector to see where you are making most of your profits. Keeping your accounting system up to date will help you make better future business decisions.

Remember Cost of Good Sold Expenses are expenses directly related to the sale of that sales sector.     (Of course you dont enter fixed expenses like utilities and rent in Cost of Goods Sold Expense accounts.)

For company start up information, click on this link as there are excellent cost saving ideas here as well as thinking about integrating your systems with accounting packages such as QuickBooks: http://www.biznessstartup.com/



Everyone is excited about public WIFI areas to hook up to the internet whether they be at airports, libraries or even shops.  If you get on the web in unsecured WIFI areas then just browse  sites that do not need you to log in with a password.  Criminals can trap the signals coming from unsecured WIFI areas and capture all the information you send so be aware of this.

On the home networking side, many people do not have a secure wireless network router.  It is very easy to install  a password on your home wireless network router.  Just read the manual that came with the router you bought.  If you dont set up a secured password to encrypt your home router, then neighbors that are close to you (say 1 or 2 houses away) or entire floors in apartment buildings or condos, can come in and use your wireless internet connection since it shows up on their computer as one of the wireless networks that is in range.

Be more alert of where you store you passwords and never make your passwords the same as your username as hackers try that first.  Make your passwords unique and secret and long enough with numbers and letters.

Last week we gave you 2 posts on SSL certificates and understanding the difference between http://… and https://… in your web browser when you view web sites.  Remember, if you are entering passwords or credit card information , ONLY do that on a trusted SSL site meaning the URL address you are visiting (web site you enter at the top of your web browser) starts off with https://… and you should see a lock icon on your browser.  Sites that start off with http://,,, do not encyption your password nor your credit card information which should be a security alert to you.

Here is a tip on internet advertising”

Are you happy with your web advertising?  Here are 2 links to help you out as one link is Free and one is for full page ads on 20 + busienss directories with links on 10+ blogs sites for a flat rate with no pay per click charges.

For help on web full page ad advertising, click on this link: http://www.sozohosting.com/contact/Full-page-ads.cfm

For help on free web white page advertising, click on this link: http://www.sozohosting.com/contact/Free-White-Pages.cfm

 



Do you have paper billing? Its is time to collect payments on the web and eliminate your NSF checks and postage costs.   Here is an excellent solution below:

Bizness Inc.’s BizRAS Web Invoicing not only collects one-time payments but also recurring billing payments automatically. This means you can collect money on your customers credit card or PayPal account each period whether your billing cycles are: weekly, bi-weekly, monthly, quarterly, semi-annually or annually!

Think of the cost savings you can gain through a Web Billing and Recurring Payments system that collects from your clients Credit Card or PayPal account automatically each period!  For more info click on this Web Billing link!