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 »

SQL Server 2008 Failover Clustering

SQLCAT, has published a whitepaper SQL Server 2008 Failover Clustering for SQL Server 2008 failover clustering. Summary: This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008… more »

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

Ola Hallengren, with his wonderful SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - made some updates to his maintenance scripts: Support for printing of commands without executing them. Set the new parameter… more »

Cumulative update package 4 for SQL Server 2005 Service Pack 3

The cumulative update package 4 for SQL Server 2005 Service Pack 3 (Build 9.00.4226) is available:http://support.microsoft.com/kb/970279/And here you can get the whole information of builds that were released after SQL Server 2005 Service Pack… more »

The Exceptional DBA Awards are back in 2009!

What do you think?Quidquid agis, prudenter agas et respice finem! more »

Cumulative update package 2 for SQL Server 2008 Service Pack 1

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