Recently Microsoft has release the much awaited SP2 for SQL Server 2005. Guys go and grab it – it has bug fixes and most importantly lot of performance gains in addition to support for Vardecimal

Refer to: http://www.microsoft.com/downloads/details.aspx?familyid=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en

Read the “What's New in SQL Server 2005 SP2” and please don’t forget to test the SP2 on test / staging environment before applying it to production.

Read the “Readme for Microsoft SQL Server 2005 Service Pack 2

Warning - Once SQL Server 2005 SP2 has been applied, it cannot be removed without uninstalling the entire product.

 

Do refer to http://blogs.msdn.com/sqlrem/archive/2007/02/24/Maintenance-Plan-Changes-in-SQL-Server-2005-SP2.aspx for some of the stuff related to SQL Server 2005 maintenance plans and SP2.

 

Some of the other goodies:

·         SQL Server 2005 Best Practices Analyzer (February 2007 CTP) –

Also recently Microsoft released first cut of another goody - SQL Server 2005 Best Practices Analyzer.

http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en

Refer to http://blogs.msdn.com/sqlrem/archive/2007/01/12/SP2-and-BPA-FAQ.aspx for BPA FAQ and more information on http://blogs.msdn.com/sqlrem/archive/2006/09/07/743792.aspx

·         Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2

http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

Microsoft SQL Server 2005 Express Edition Toolkit Service Pack 2

http://www.microsoft.com/downloads/details.aspx?familyid=E8AD606A-0960-4EFD-8BD7-B21370C7BE2B&displaylang=en

Microsoft SQL Server Management Studio Express Service Pack 2

http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en

·         Feature Pack for Microsoft SQL Server 2005 - February 2007

http://www.microsoft.com/downloads/details.aspx?familyid=50B97994-8453-4998-8226-FA42EC403D17&displaylang=en

·         SQL Server 2005 Books Online (February 2007)

http://www.microsoft.com/downloads/details.aspx?familyid=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

·         SQL Server 2005 Samples and Sample Databases (February 2007)

http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

·         Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

It allows you to take advantage of SQL Server 2005 Service Pack 2 (SP2) report processing and management capabilities within Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.

http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en

·         Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007

It allows you take advantage of SQL Server 2005 predictive analytics in Office Excel 2007 and Office Visio 2007

http://www.microsoft.com/downloads/details.aspx?familyid=7C76E8DF-8674-4C3B-A99B-55B17F3C4C51&displaylang=en

 

 Also check some old stuff –which sometime I get asked for:

·         SQL Server 2005 System Views Map

http://www.microsoft.com/downloads/details.aspx?familyid=2EC9E842-40BE-4321-9B56-92FD3860FB32&displaylang=en

 

·         Microsoft SQL Server 2005 Upgrade Advisor

http://www.microsoft.com/downloads/details.aspx?familyid=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang=en

 

·         SQL Server 2005 Upgrade Technical Reference Guide

http://www.microsoft.com/downloads/details.aspx?familyid=3D5E96D9-0074-46C4-BD4F-C3EB2ABF4B66&displaylang=en

 

·         AdventureWorks OLTP Database Diagram

http://www.microsoft.com/downloads/details.aspx?familyid=0F6E0BCF-A1B5-4760-8D79-67970F93D5FF&displaylang=en