SQL Server 2008 Failover Clustering

Posted on Jul 9, 2009 by in SQL Server
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

Posted on Jun 28, 2009 von in SQL Server
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

Posted on Jun 26, 2009 von in SQL Server
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

Posted on Jun 22, 2009 by in SQL Server
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

Posted on Jun 22, 2009 by in SQL Server
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!

Posted on Jun 15, 2009 by in SQL Server
What do you think?Quidquid agis, prudenter agas et respice finem! more »

Pro T-SQL 2008 Programmer's Guide

Posted on Jun 7, 2009 von in SQL Server
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

Posted on Mai 20, 2009 von in SQL Server
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 »
Tags: b_cher

Cumulative update package 2 for SQL Server 2008 Service Pack 1

Posted on May 20, 2009 by in SQL Server
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

Posted on May 15, 2009 by in SQL Server
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

Posted on May 13, 2009 by in SQL Server
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

Posted on Apr 21, 2009 by in SQL Server
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

Posted on Apr 20, 2009 by in SQL Server
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

Posted on Apr 16, 2009 by in 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 »

Cumulative update package 1 for SQL Server 2008 Service Pack 1

Posted on Apr 16, 2009 by in SQL Server
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 »

XML-Daten per FTP verschicken und Pakete konfigurieren

Posted on Apr 8, 2009 von in SQL Server
In diesem Artikel soll es zum einen darum gehen, SQL Server Daten als XML-Daten zur Verfügung zu stellen, und zum anderen wie die Paketkonfiguration erleichtert werden kann.Voraussetzungen Die Erstellung von Daten im XML-Format wird durch die FOR XML-… mehr »

Microsoft SQL Server 2008 Service Pack 1 now available!

Posted on Apr 8, 2009 by in SQL Server
It's out. The final release of SQL Server 2008 Service Pack 1 (Build 10.00.2531.00) is now available: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19Here the KB-Article of SP1: List of the… more »

SQL Server 2008 Service Pack 1

Posted on Apr 8, 2009 von in SQL Server
Microsoft hat Service Pack 1 für SQL Server 2008 veröffentlicht. Eine Liste der Bug-Fixes findet sich hier: http://support.microsoft.com/kb/968369 Die Release-Notes sind hier: http://go.microsoft.com/fwlink/?LinkId=147331 Hier ist die Download URL:… mehr »

Reporting Services 2005 on Windows Server 2008 (+ Vista) or Windows 2008 R2 (+ Windows 7) - IIS configuration

Posted on Apr 4, 2009 by in Reporting Services
Many still use SQL Server/Reporting Services 2005 although sometimes alread on Windows Server 2008 / Vista / Windows 7. I absolutely do recommend upgrading to SQL Server 2008. There are many advantages in the combination - be it security or performance… more »
Leave a comment »

SQL Server 2005/2008 Express free Profiler Tool

Posted on Apr 3, 2009 by in SQL Server
In one of my older post, I tell you about a realy good free profiler express edition tool for SQL Server 2005 ..A lot of features / tools are included with the SQL Sever 2005 Express Edition (GUI, Reporting Services etc.), but not all of them like the… more »
3 comments »

SSMS Tools Pack 1.5 by Mladen

Posted on Mar 30, 2009 by in SQL Server
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 »
7 comments »

Cumulative Update package 4 for SQL Server 2008

Posted on Mar 17, 2009 by in SQL Server
The Cumulative Update package 4 for SQL Server 2008 (Build 10.00.1798) is now available: http://support.microsoft.com/kb/963036/en-us And here you can get the whole information of builds that were released after SQL Server 2008 was… more »

Pro SQL Server 2008 Database Design and Optimization

Posted on Mär 9, 2009 von in SQL Server
Mit diesem Buch legen die Autoren die aktualisierte Auflage ihres Design- und Implementierungsbuches zu SQL Server vor. Der Inhalt wurde nur geringfügig überarbeitet und auf die Neuerungen von SQL Server 2008 angepasst; das Grundkonzept ist… mehr »

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

Posted on Mär 9, 2009 von in SQL Server
Ola Hallengren hat eine neue Version seines frei verfügbaren Skripts für Maintenance, Integritätschecks und Index Wartung online gebracht. Weitere Informationen und Download: http://ola.hallengren.com mehr »
1 Kommentar »

Europäische PASS Konferenz 2009 zu SQL Server vom 22.-24. April in Neuss

Posted on Mär 4, 2009 von in Conferences, Reporting Services
Über 20 Sprecher in 36 technischen Sessions in 2 Tagen (Hauptkonferenz) zu Business Intelligence, Datanbankentwicklung und -Administration mit Fokus auf SQL Server 2008. ich halte den Vortrag “Standardizing and Centralizing Report Design”. Agenda: ... mehr »