Professional SQL Server 2005 Performance Tuning
"This book approaches Performance tuning from a new perspective. It shows readers how to find performance problems, rather than assuming they already know what the problem is. As such there is more emphasis on diagnostics than in any competitive books. This book also takes a new approach in that we will discuss the limitations imposed on performance tuning by the different stages of a projects life cycle, and help the reader understand how this alters the performance tuning process. We begin by covering aspects of general end-to-end application tuning (not specific to SQL Server), but then very quickly move to SQL Server specifics, starting with the high level stuff like the basic server resource counters for CPU, memory, and IO, then trying to find the slow queries by looking at SQL Wait types, and using Profiler to find long running, or blocked, or otherwise poorly performing queries. We then move on to demonstrate how to "fix" the performance of those poorly performing queries. We also cover the different approaches the DBA might take depending on where the target system is in its lifecycle. This includes the things you can do with an application at the early stages of design (e. g. , change pretty much anything from the schema on up, including specifying different hardware). We then cover the very different approach when working with a system running in production (mostly index tuning, some server config, limited T-SQL tuning, no schema changes). "

Seminar

MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442)
An Exam Guide and a Desktop Reference--All in One!This comprehensive guide offers complete coverage of the material on all three of the new Microsoft Certified IT Professional exams for SQL Server 2005, which test the ability of certification candidates to design a secure, stable, enterprise SQL Server database solution. Filled with case studies, checklists, technical sidebars, and real-world examples, this book serves as both an exam preparation tool as well as an essential on-the-job reference. The CD-ROM includes practice exam software featuring hundreds of questions, and an electronic book.

Seminar

A Developer´s Guide to SQL Server 2005
"Bob and Dan´s book goes beyond enumerating the new SQL Server 2005 features, and will provide you with lots of good examples. They did a good job striking a balance between overview and substance. "--Michiel WoriesSenior Program Manager, SQL ServerMicrosoft Corporation Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005. Now"

Seminar

Entwickeln und Optimieren von Datenbankverwaltungslösungen für SQL Server 2005
##############

Seminar

Microsoft SQL Server 2005 Analysis Services
Microsoft is a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries and is used under license from Microsoft.

Seminar