MySQL Server is one of the most popular relationship database management system (RDBMS) that runs as a server providing multi-user access to databases. MySQL executes INSERT and UPDATE SQL (table write) statements with higher priority when comparing with SELECT (table read) SQL commands. The behavior may cause bottleneck or deadlock on some type of databases, such as MyISAM engine databases, which requires table lock.

Continue reading Optimize and Increase MySQL Responsiveness and Performance with max_write_lock_count » » »

Users are mostly aware that important data without proper backup in the computer could spell disaster in the event the computer stops working or call it quits. Be prepared for the inevitable tragedy if you don’t want to fall into a situation whereby a multitude of data and files suddenly go missing. If you find backup software applications generally difficult to use or too complicated to configure, probably it is worthwhile to try this simple, fully automatic and powerful backup program, Ocster Backup Free.

Continue reading Ocster Backup Free for Security of Documents » » »

SQL Server 2005 Express edition is a free, lightweight and embeddable version of SQL Server 2005 which includes SQL Server Management Studio Express for users to easily manage that databases. Although SQL Server 2005 Express edition supports backup and restore database but it does not supports scheduling backups.

Continue reading How To Perform Scheduled Backups For SQL Server 2005 Express » » »

When selecting data or performing query on Microosft SQL Server 2008 or SQL Server 2005 database, the following error message or failure may be returned:

[Microsoft][ODBC SQL Server Driver][SQL Server][Msg 4147, Level 15, State 1, Line 4] The query uses non-ANSI outer join operators (“*=” or “=*”). To run this query without modification, please set the compatibility level for current database to 80, using the SET COMPATIBILITY_LEVEL option of ALTER DATABASE. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions
of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes.

Continue reading How to Set Compatibility Level for SQL Server 2008 or 2005 Database » » »

Microsoft has released the CTP version of SQL Server 2008 Service Pack (SP1). Users can use these packages to upgrade any SQL Server 2008 edition. This release has basically fixed the issues reported through the SQL Server community. Microsoft has highlighted that this CTP version is basically made available for general testing purposes only. It is not advisable to deploy the CTP version in the production environment.

Continue reading CTP Version of SQL Server 2008 Service Pack 1 (SP1) Available For Download » » »

Most of your business contacts are probably stored in your company’s computer using Microsoft Outlook. You might want to copy or move these valuable contacts to your Gmail account so that you can access them when you are away from the office or if you are planning to leave the company. To move your Microsoft Outlook contact list to Gmail or vice versa is not that complicated. A few steps away and you can get the work done:

Continue reading How to Merge Outlook and Gmail Contact » » »

MySQL is one of the most popular database management system that powers the most dynamically served website, including sites with millions traffic and visitors everyday. Many web pages and web applications or services rely on MySQL to store contents data which will be retrieved and read by web servers to dynamically built the web pages that visitors will read.

Continue reading MySQL Database Performance Tuning Best Practices Video Tutorial » » »

Microsoft SQL Server is a data-intensive and disk I/O (read and write) intensive database management systems. For SQL Server which is running on a system with large amount or big size of physical RAM memory, such as system with 4GB, 8GB or even more gigabytes of physical memory, it can be configured to use the Address Windowing Extensions (AWE) API to provide access to physical memory in excess of the limits set on configured virtual memory, and force all paging to take place in memory for faster access.

Continue reading Optimize SQL Server 2000, 2005 or 2008 in Large RAM System by Locking Pages in Memory and AWE » » »