Monthly Archives: March 2009

Parallelism bugs in SQL 2008

I believe parallelism was introduced in SQL Server 7.0 but since then we encountered many issues with it. Still there are bugs/issues with parallalism, please check the post by Aaron Bertrand…   Six reasons you should be nervous about parallelism … Continue reading

Posted in SQL Server 2008 | 42 Comments

SQL Server 2005 SP3 through Microsoft Update now supports clustering

SQL Server 2005 SP3 through Microsoft Update now supports clustering On March 24th, we revised the SQL Server 2005 Service Pack 3 Microsoft Update logic to offer when a clustered instance is detected. When the logic was originally released, the … Continue reading

Posted in SQL Server 2005 | 64 Comments

Auditing in SQL Server 2008

Very good article about auditing in SQL 2008 written by Microsoft folks… Auditing in SQL Server 2008 SQL Server 2008 Enterprise enhances the auditing capabilities of the server by introducing native auditing functionality into the database engine. The new SQL … Continue reading

Posted in SQL Server 2008 | 98 Comments

Did you know who is in the highest position in the World?

I got the following interesting mail from one my friend, here it is… Did you know who is in the highest position in the World? President Barack Obama? NO! UN Secretary General? NO! Wonder No Longer… scroll downnnnnnnnnnnnnnnn Babu Sassi, a … Continue reading

Posted in News and politics | 70 Comments

Backup, Integrity Check and Index Optimization for SQL Server 2005 and 2008

Ola Hallengren, has a great scripts that helps to automate consistency checks, backups, and index maintenance. Those who don’t want to write and to use free code then this the right script. Check out the latest version at  SQL Server … Continue reading

Posted in SQL Server 2008 | 56 Comments

SQL Server Migration Assistant (SSMA) for 2008 and 2005

Microsoft released SQL Server Migration Assistant to help clients get from Oracle, Sybase, Access, and PowerBuilder to SQL Server 2005 or 2008.  It is the best thing to migrate from all other database platforms…   ·         SSMA 2005 for Oracle … Continue reading

Posted in SQL Server 2008 | 100 Comments