Category: "SQL Server"

High Availability with SQL Server 2008 - by Paul S. Randal

Paul S. Randal describes the technologies available in SQL Server 2008 that can be used as part of a high-availability strategy to protect critical data. As well as describing the technologies in detail, the white paper also discusses the various causes… more »

SSMS Tools Pack 1.7 by Mladen

Do you know the SSMS Tools PACK Add-In, it is an very exciting Add-In (Add-On)for Microsoft SQL Server Management Studio and Microsoft SQL Server Management Studio Express. It contains many interesting features, and I mean many! So, take a look - and… more »

Cumulative update package 6 for SQL Server 2005 Service Pack 3

The cumulative update package 6 for SQL Server 2005 Service Pack 3 (Build 09.00.4266) is available:http://support.microsoft.com/kb/974648/. The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released:… more »

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

I'm sure, that's exactly what Albert Einstein meant in his quote:"Try not to become a man of success but rather to become a man of value", Ola Hallengren becomes a man of value - with his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity… more »

Cumulative update package 5 for SQL Server 2005 Service Pack 3

The cumulative update package 5 for SQL Server 2005 Service Pack 3 (Build 09.00.4230) is available: http://support.microsoft.com/kb/972511.The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released:… more »

Fast and Reliable Backup and Restore of a VLDB over the Network

Thomas H. Grohser discusses the challenges of designing a robust backup and restore solutions for very large databases (VLDBs) in this SQL Server Technical… more »

Technical Note - DBCC Checks and Terabyte-Scale Databases

Stuart Ozer has published a technical note at SQLCAT. http://sqlcat.com/technicalnotes/archive/2009/08/13/dbcc-checks-and-terabyte-scale-databases.aspx CU tosc more »

High Availability and Disaster Recovery at ServiceU: A SQL Server 2008 Technical Case Study

SQLCAT, has published a new whitepaper / technical case study High Availability and Disaster Recovery at ServiceU for SQL Server 2008. Follow up: SQLCAT:… more »

Plan Caching in SQL Server 2008

Greg Low, has published a whitepaper Plan Caching in SQL Server 2008, it's an update of the whitepaper "Batch compilation, Recompilation and Plan Caching Issues in SQL Server 2005" by Arun Marathe, targeted at SQL Server 2008. Summary: This paper… more »

Cumulative update package 3 for SQL Server 2008 Service Pack 1

The Cumulative update package 3 for SQL Server 2008 Service Pack 1 (Build 10.00.2723) is available: http://support.microsoft.com/kb/971491/en-usAnd here you can get the whole information of builds that were released after SQL Server 2008 Service Pack 1… more »