Released – Cumulative Update Package 1 for SQL Server 2005 Service Pack 3

Microsoft has just shipped the first Cumulative Update for SQL Server 2005 SP3.   This CU contains only hotfixes that were released in Cumulative Update 10 for SQL Server 2005 Service Pack 2 and Cumulative Update 11 for SQL Server 2005 Service Pack 2. These hotfixes are not included in SQL Server 2005 Service Pack…

1

SQL Server 2005 SP3 is out!

Service Pack 3 for Microsoft SQL Server 2005 (build number 9.00.4035) is now available and ready to download at http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en.   A complete List of the bugs that are fixed in SQL Server 2005 Service Pack 3 can be found at http://support.microsoft.com/?kbid=955706   Note: Service Pack 3 includes SP2 CU 1 to 9,  therefore If…

0

Resource Governor Demos

If you are looking for some demos to play and learn about Resource Governor, you should have a look to the SQL Server SQLOS team blog, which has posted a couple of interesting ones.   1) Anatomy of SQL Server 2008 Resource Governor CPU Demo http://blogs.technet.com/sqlos/archive/2007/12/14/part-1-anatomy-of-sql-server-2008-resource-governor-cpu-demo.aspx   This demo will use a single CPU to…

1

Data & Backup Compression (Part 3) – Tests, Numbers and Tuning Tips

One of the most common question I’ve received regarding data and backup compression in SQL Server 2008 is related to achievable results in terms of performance and compressio-ratio on very large databases.   I’ve just found some interesting data published by Unisys which you can review at: Microsoft SQL Server 2008 Data and Backup Compression…

0

How to: Troubleshoot SQL Server 2008 Features

This is a nice section in 2008 Books On Line which I just found and wanted to blog about – mainly for my reference so that I can quickly find it when needed 😉   I’ve found it whilst looking for recommendations to troubleshoot Resource Governor,  but there are actually many other troubleshooting how-to’s which I…

0