Category: "SQL Server"

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 »

Cumulative update package 3 for SQL Server 2005 Service Pack 3

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

Disk Alignment Best Practices for SQL Server 2008

SQLCAT, has published a whitepaper Disk Partition Alignment Best Practices for SQL Server for configuring optimal disk performance. Follow up: SQLCAT: http://sqlcat.com/whitepapers/archive/2009/05/11/disk-partition-alignment-best-practices-for-sql-… more »

Troubleshooting Performance Problems in SQL Server 2008

There is a new withe paper on SQL Server 2008 performance troubleshooting and covers the following in depth: CPU Bottlenecks Memory Bottlenecks I/O BottlenecksSlow-Running Queries Extended EventsData Collector and the MDWDownload from the Microsoft… more »

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

Ola Hallengren Ola, with his wonderful SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - made some updates to his maintenance scripts: Support for Xml indexes Support for Spatial indexes Support for indexed views… more »

Whitepaper-Links collection page for SQL Server

Paul S. Randal and his wife Kimberly L. Tripp of SQLskills.com linked to whitepapers written/published by reputable sources, consolidated in a Whitepaper-Link Collection.Here it is: http://www.sqlskills.com/whitepapers.asp CU tosc more »