PDF | English | 6.3MB(zip)

Author: Brad McGehee

In his new book, Brad's Sure Guide to SQL Server Maintenance Plans, Brad McGehee takes you on a comprehensive tour of two SQL Server tools designed to help DBAs ensure that a "required minimum" level of maintenance takes place on their SQL Server instances: the Maintenance Plan Wizard and the Maintenance Plan Designer.

PDF | English | 6.7MB(zip)

Author: Rodney Landrum

For the day-to-day DBA, there are dangers around every corner; monsters waiting to strike down the unsuspecting database with a resource-hungry query, an inefficient data load, or even outright data corruption. When the worst happens, and SQL Server is down, or performance is suffering, customers are quick to complain.. During such difficult periods, you, the DBA, are the centre of attention. Suddenly, three or four people crowd your desk, laser beam focused on your every action, fully expecting you to solve the problem quickly.

PDF | English | 11.1MB(zip)

Author: Grant Fritchey

Execution plans show you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: • Which indexes are being used, and where no indexes are being used at all. • How the data is being retrieved, and joined, from the tables defi ned in your query. • How aggregations in GROUP BY queries are put together. • The anticipated load and the estimated cost that all these operations place upon the system. Grant Fritchey's book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans. Sample chapters of the ebook have garnered stunning reviews, such as: "All I can say is WOW. This has to be the best reference I have ever seen on Execution Plans in SQL Server. My hats off to Grant Fritchey" Jonathan Kehayias.

PDF | English | 10.8MB(zip)

Author: Jaap Wesselius

As the backbone to so many commercial communications infrastructures, Microsoft's Exchange Server technology has become a critical component in many an IT department. With the latest incarnation of Exchange Server on the horizon, and indeed almost upon us, it is becoming increasingly urgent that SysAdmins get to grips with this latest-and-greatest technology. What's new? What's gone? What's easier or harder? Jaap touches upon all these essentials. As a practical field-guide to Exchange Server 2010, this book will tell you exactly what you need to know to get started with upgrading, installing, configuring and managing your new Exchange Server. If you need to get to grips with Exchange Server 2010 fast, or want a short, to-the-point, practical guide to Microsoft's latest offering, then you should read this book.

PDF | English | 2.7MB(zip)

Author: Brad McGehee

A 2nd edition of Brad McGehee's popular "career guide" for DBAs, designed to help new and prospective DBAs find their feet in the profession, and to advise those more-experienced on how they can excel at their jobs, and so become Exceptional DBAs.