Cumulative update package 5 for SQL Server 2005 Service Pack 3
Aug 20th
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
Aug 19th
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
Aug 19th
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 »
Log Shipping ohne Vertrauensstellung
Aug 14th
Nicht immer ist es einfach möglich ein Log Shipping zwischen zwei Servern aufzusetzen. Hier wird kurz erläutert, wie dies auch ohne Vertrauensstellung möglich ist.
Es gibt zwar einen Artikel (KB31247) in der Knowledge-Base, der verschiedene Szenarien… mehr »
Periodengerechte Abgrenzung durch GROUP BY
Aug 12th
Angenommen, wir haben die Aufgabe eine Urlaubsliste zu generieren, die zur Urlaubsplanung verwendet werden soll. Die Basistabelle ist recht einfach aufgebaut: mehr »
Was tun wenn Systemadministratoren auf einen SQL 2008 gesperrt oder gelöscht sind ?
Aug 12th
Für diesen Fall findet man hier eine detailierte Anleitung zum Troubleshooting. mehr »
SQL Server 2008 R2 August CTP Available Today
Aug 11th
MSDN und TechNet Abonnenten können ab sofort die erste öffentliche CTP von SQL Server 2008 R2 herunterladen. mehr »
High Availability and Disaster Recovery at ServiceU: A SQL Server 2008 Technical Case Study
Aug 6th
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
Aug 4th
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
Jul 22nd
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
Jul 9th
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 2008 Query Performance Tuning Distilled
Jun 28th
Auf ein Update dieses Buches musste man lange warten. Seit der Version zu SQL Server 2000 herrschte Stille. SQL Server 2005 wurde komplett ausgelassen und erst mit SQL Server 2008 kommt die längst überfällige Aktualisierung auf den Markt. mehr »
Beginning SQL Server 2008 for Developers
Jun 26th
Wie sollte ein Buch sein, welches man einem Anfänger und/oder gelegentlichen SQL Server Entwickler ans Herz legen könnte? mehr »
SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization
Jun 22nd
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
Jun 22nd
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!
Jun 15th
What do you think?Quidquid agis, prudenter agas et respice finem! more »
Pro T-SQL 2008 Programmer's Guide
Jun 7th
Michael Coles legt mit dem vorliegenden Buch die auf SQL Server 2008 aktualisierte Version seines "T-SQL Programmers Guide" vor. mehr »
Implementieren und Warten von SQL Server 2008
Mai 20th
Das vorliegende Buch beschäftigt sich schwerpunktmäßig mit diesen Themen:
• Installieren und Konfigurieren von SQL Server 2008 • Anlegen und Implementieren von Datenbankobjekten • Implementieren von Hochverfügbarkeit und Notfallwiederherstellung… mehr »
Cumulative update package 2 for SQL Server 2008 Service Pack 1
May 20th
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
May 15th
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
May 13th
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
Apr 21st
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
Apr 20th
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
Apr 16th
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 »
Cumulative update package 1 for SQL Server 2008 Service Pack 1
Apr 16th
Is it true? YES, it is!Don't worry - be happy; Aaron Bertrand explains it in his post: http://sqlblog.com/blogs/aaron_bertrand/archive/2009/04/15/sql-server-2008-sp1-cumulative-update-1-is-available.aspx The Cumulative update package 1 for SQL Server… more »
