Free eBook “SQL Server Execution Plans” by 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. Grant Fritchey’s book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans. …
Mastering SQL Server 2005 Profiler
Free eBook “Mastering SQL Server 2005 Profiler” by Brad McGehee, DBA expert with over 12 years’ experience. SQL Server Profiler is one of the most useful of SQL Server’s “built-in” tools, recording data about various SQL Server events. …
How to Become an Exceptional DBA Second Edition
Download free ebook “How to Become an Exceptional DBA Second Edition” by Brad McGehee. 173 pages of advice on how to stand apart from the average DBA. Fully revised content. New chapters: “The Exceptional DBA’s Code of Conduct” & “Get an Exceptional DBA Job”. Be an exceptional DBA and benefit from 12 years of professional experience distilled. …
SQL Server Tacklebox: Essential Tools and Scripts for the day-to-day DBA
Free 240 page eBook “SQL Server Tacklebox: Essential Tools and Scripts for the day-to-day DBA” by Rodney Landrum. Scripts, tools and techniques to tackle SQL Server issues. Troubleshoot performance issues. Receive notifications of impending issues. Fight off data corruption. Document and report on your servers. Automate and standardize SQL Server installation. Migrate data and manage data growth. Secure access to your servers. …
SQL Server Crib-Sheet Compendium
This free ebook contains a collection of Simple-Talk Crib Sheets published between 2006 and 2008. It focuses on SQL Server topics, but also covers two .NET issues that are relevant to all SQL Server developers and DBAs …
Brad’s Sure Guide to SQL Server 2008
Free eBook “Brad’s Sure Guide to SQL Server 2008: The Top Ten New Features for DBAs” by Brad McGehee. SQL Server 2008 has hundreds of new features and improvements for Production DBAs, Developer DBAs, and Business Intelligence specialists. Some of the changes are significant, while others are minor, but still important. …
Dissecting SQL Server Execution Plans
Free eBook “Dissecting SQL Server Execution Plans: Writing High Performance SQL Code” by Grant Fritchey. Grant Fritchey’s book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans. …
Introducing Microsoft SQL Server 2008 R2(pdf)
Download free eBook “Introducing Microsoft SQL Server 2008 R2” from Microsoft in pdf and xps formats. This book is for anyone who has an interest in SQL Server 2008 R2 and wants to understand its capabilities. …
Best of SQL Server Central Vol 6
Best of SQLServerCentral v6 pulls together some of the best, most popular, and the most read articles of 2008, in dead tree format, covering database administration, BI, design, security, T-SQL, and most things in between. …
Best of SQL Server Central Vol 5
Best of SQL Server Central Vol 5 pulls together some of the best, most popular, and the most read article of 2007, in dead tree format, covering database administration, BI, ETL, design, security, T-SQL, XML and more besides. …