Category Archives: SQL Server 2008

Microsoft SQL Server 2008 Service Pack 2

Microsoft finally release Microsoft SQL Server 2008 Service Pack 2 after long CTP testing…   Key improvements in Microsoft SQL Server 2008 Service Pack 2 are:   Reporting Services in SharePoint Integrated Mode. SQL Server 2008 SP2 provides updates for … Continue reading

Posted in SQL Server 2008 | Leave a comment

SQL Server 2008 R2 RTM

SQL Server 2008 R2 is available today (May 3rd 2010) to TechNet and MSDN subscribers…. and available for download worldwide on May 13 as per the following blog… http://msdnrss.thecoderblogs.com/2010/04/25/sql-server-2008-r2-rtm/  http://blogs.technet.com/microsoft_blog/archive/2010/04/21/SQL-Server-2008-R2-Helping-Customers-Get-More-Value-Out-of-Their-Data.aspx    

Posted in SQL Server 2008 | 11 Comments

Best Practices Analyzer (BPA)

As per the CSS blog entry SQL Server 2008 R2 BPA is based on the new Microsoft Baseline Configuration Analyzer (MBCA) v2.0 is coming soon…   http://blogs.msdn.com/psssql/archive/2010/04/22/europe-pass-a-volcano-live-meeting-and-sql-2008-r2-bpa.aspx      

Posted in SQL Server 2008 | Leave a comment

SQL Server 2008 R2 Update for Developers Training Kit

SQL Server 2008 R2 Update for Developers Training Kit is available as a free download from the Microsoft Download center… http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d Overview SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced … Continue reading

Posted in SQL Server 2008 | 46 Comments

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

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

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