Archive for the 'Databases' Category

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

Oracle PL/SQL ORA-00947 Not Enough Values Error

Tuesday, October 23rd, 2007

In Oracle database, the following error message may appear when an incorrect SQL statement is used, in SQL Plus or in anywhere that send SQL queries to the databases such as stored procedure or external programs.

PL/SQL: SQL Statement ignored
PL/SQL: ORA-00947: not enough values

Continue reading Oracle PL/SQL ORA-00947 Not Enough Values Error » » »