Archive for the 'Databases' Category

How To Perform Scheduled Backups For SQL Server 2005 Express

Wednesday, August 26th, 2009

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.

SQLServer

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


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

Sunday, May 17th, 2009

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 » » »

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

Tuesday, February 24th, 2009

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 » » »

How to Merge Outlook and Gmail Contact

Monday, December 22nd, 2008

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 Database Performance Tuning Best Practices Video Tutorial

Tuesday, July 29th, 2008

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 » » »

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

Saturday, June 7th, 2008

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 » » »

Free Microsoft Office Alternatives or Replacements

Sunday, November 25th, 2007

Microsoft Office suites and products are one of the most popular Office productivity application suite in many companies and corporations. However, Microsoft Office is expensive, overly priced at best. Microsoft Office comes with many advanced features that one may never use or need, and with user friendly interface. If you willing to sacrifice some bloated features, there are plenty of complete replacement alternative for Microsoft Office, which has slowly gaining market share. Best of all, the alternative Office suites are free, and possess all features you ever need to use, including compatibility and support for Microsoft Office file formats.

Continue reading Free Microsoft Office Alternatives or Replacements » » »

Error Has Occurred While Establishing A Connection To SQL Server 2005 Which Does Not Allow Local and Remote Connections

Wednesday, October 31st, 2007

When connecting to an instance of Microsoft SQL Server 2005 database, including SQL Server 2005 Express, Developer and Enterprise editions, for authentication or accessing and retrieving and updating the data, the the following error message may appear. The problem happens no matter the connection is originated from remote computer or on SQL Server local computer itself, and can be caused by any program, such as SQLCMD utility, used to connect to SQL Server.

Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

Continue reading Error Has Occurred While Establishing A Connection To SQL Server 2005 Which Does Not Allow Local and Remote Connections » » »