Book store
In collaboration with Simple-Talk.com, SQLServerCentral.com and BusinessOfSoftware.com


Troubleshooting SQL Server

Troubleshooting SQL Server: A Guide for the Accidental DBA by Jonathan Kehayias and Ted Krueger
(1st Edition, November 2011)

Three SQL Server MVPs provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks". View full description

Buy from Amazon.com: $29.99
Free eBook download

Ecrire du code .NET performant

Ecrire du code .NET performant by Jean Philippe Gouigoux

Published by Editions ENI (currently only available in French)

In this book, Jean Philippe Gouigoux, an experienced software architect, and Microsoft MVP, explains the principles behind code profiling and highlights simple profiling methods that can help locate 20% of the problems that lead to 80% of the speed reduction. He then demonstrates how to zero in on bottlenecks using a real–life demo application. View full description

Free access to 20% of the book in a digital format.

SQL Server Hardware

SQL Server Hardware by Glenn Berry
(1st Edition, July 2011)

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS. view full description

Buy from Amazon.com: $29.99
Buy from Amazon.co.uk: £19.99

Inside the SQL Server Query Optimizer

Inside the SQL Server Query Optimizer by Benjamin Nevarez
(1st Edition, November 2010)

This book will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way. view full description

Buy from Amazon.com: $29.99
Buy from Amazon.co.uk: £19.99
Free eBook download

SQL Server Statistics

SQL Server Statistics by Holger Schmeling
(1st Edition, November 2010)

Holger Schmeling's work in SQL Server Distribution Statistics was first published as a pair of long articles for Simple-Talk. The booklet takes a practical, and well-informed approach to a subject that is not always easy to explain or understand... view full description

Free eBook download

The Red Gate Guide to SQL Server Team-based Development

The Red Gate Guide to SQL Server Team-based Development by Phil Factor, Grant Fritchey, Alex Kuznetsov, and Mladen Prajdić
(1st Edition, November 2010)

This book shows how to use a mixture of home-grown scripts, native SQL Server tools, and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment, and make database development as similar as possible to "normal" development... view full description

Buy from Amazon.com: $29.99
Buy from Amazon.co.uk: £19.99
Free eBook download

Dynamic Management Views
Performance Tuning with SQL Server Dynamic Management Views by Tim Ford and Louis Davidson

This is the book that will de-mystify the process of using Dynamic Management Views to collect the information you need to troubleshoot SQL Server problems. It will highlight the core techniques and "patterns" that you need to master, and will provide a core set of scripts that you can use and adapt for your own requirements. View full description...

Buy from Amazon.com: $29.99
Buy from Amazon.co.uk: £19.99

Defensive Database Programming
Defensive Database Programming by Alex Kuznetsov

The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected. To the SQL Server programmer, this means T-SQL code that behaves consistently and predictably in cases of unexpected usage, doesn't break under concurrent loads, and survives predictable changes to database schemas and settings. Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience and robustness. View full description...

Buy from Amazon.com: $29.99
Buy from Amazon.co.uk: £19.99
Free eBook download

The SysAdmin Handbook
The SysAdmin Handbook - The Best of Simple Talk by Various authors

Of almost a hundred Simple-Talk articles on topics of interest to System Adminstrators, we've chosen the best and most popular ones for an essential collection that packs a great deal of information about common tasks for the working System Adminstrator.. View full description...

Buy from Amazon.com: $29.99
Buy from Amazon.co.uk: £19.99
Free eBook download

.NET Performance Testing and Optimization
.NET Performance Testing and Optimization by Paul Glavich and Chris Farrell
The Complete Guide

In the Complete Guide .NET Performance and Optimization, Paul Glavich and Chris Farrell offer a comprehensive and essential handbook to anybody looking to set up a .NET testing environment and get the best results out of it, or just learn effective techniques for testing and optimizing their .NET applications. View full description...

Buy from Amazon.com: $22.79
Buy from Amazon.co.uk: £16.99

Brad's Sure Guide to SQL Server Maintenance Plans
Brad's Sure Guide to SQL Server Maintenance Plans by Brad McGehee

Brad's Sure Guide to Maintenance Plans shows you how to use the Maintenance Plan Wizard and Designer to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds. View full description...

Buy from Amazon.com: $29.99
Buy from Amazon.co.uk
: £19.99
Free eBook download

Exchange 2010 - A Practical Approach
Exchange 2010 - A Practical Approach by Jaap Wesselius

Having worked with Exchange Server for the last 14 years, Jaap's Practical Guide to Exchange Server 2010 draws upon all that experience to deliver an easy-to-use guide to this latest platform, full of useful examples and top tips for SysAdmins, both new and experienced. View full description...

Buy from Amazon.com: $29.99
Buy from Amazon.co.uk
: £19.99
Free eBook download

Don't Just Roll the Dice
Don't Just Roll the Dice by Neil Davidson

How do you price your software? Is it art, science or magic?
How much attention should you pay to your competitors?
This short handbook will provide you with the theory, practical advice and case studies you need to stop yourself from reaching for the dice. View full description...

Buy from Amazon.com: $12.99
Buy from Amazon.co.uk: £8.99
Free eBook download

Best of SQLServerCentral.com Vol 7 book
Best of SQLServerCentral.com Vol 7 by SQLServerCentral.com Authors

The seventh volume in this collection brings you a compilation of the best articles we've seen over the past year, from over 50 authors. View full description...

Buy from Amazon.com : $29.99
Buy from Amazon.co.uk: £19.99

Protecting SQL Server data book

Protecting SQL Server Data by John Magnabosco

This book holds the key to "encryption without fear". In it, John Magnabosco sweeps away some of the misconceptions surrounding SQL Server's encryption technologies, and demonstrates that, when properly planned and implemented, they are an essential tool in the DBA's fight to safeguard sensitive data. View full description...

Buy from Amazon.com: $29.99
Buy from Amazon.co.uk: £19.99
Free eBook download

SQL Server Tacklebox book

SQL Server Tacklebox by Rodney Landrum

Inside the SQL Server Tacklebox you'll find day-to-day tools, scripts and techniques to automate and standardize SQL Server installation, document and report on your servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending issues, secure access to your servers and fight off the data corruption monster... view full description

Buy from Amazon.com: $29.99
Buy from Amazon.co.uk: £19.99
Free eBook download

How to become an Exceptional DBA book

How to Become an Exceptional DBA by Brad McGehee
(2nd Edition, July 2009)

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... view full description

Buy from Amazon.com: $29.99
Buy from Amazon.co.uk: £19.99
Free eBook download

Two minute SQL Server stumper

SQL Server Stumpers Vol.5 by SQLServerCentral.com Authors
(1st Edition, June 2009)

Whether you're practicing for an exam or interview, or just wanting to see who's got the biggest SQL Server brain in your office, this book is perfect. Containing 100 SQL Server Central Questions of the Day, this book is a great way to test yourself or increase your knowledge. View full description...

Buy from Amazon.com: $12.99
Buy from Amazon.co.uk: £8.99
Free eBook download

Confessions of an IT Manager

Confessions of an IT Manager by Phil Factor
(2nd Edition, May 2009)

The software industry is, just occasionally, more absurd than one would dare to imagine. Having spent most of his working life in its clutches, Phil Factor has pretty much "seen it all" and what's more he's prepared to tell what he knows. The second edition of Phil's "Confessions of an IT Manager" contains Phil's full repertoire of tales of institutional mayhem and software projects gone awry. View full description...

Buy from Amazon.com: $12.99
Buy from Amazon.co.uk: £8.99
Free eBook download

The Art of XSD book

The Art of XSD by Jacob Sebastian
(1st Edition, April 2009)

When information is exchanged in XML format, you need an agreement between the sender and receiver about the structure and content of the XML document. This "agreement" takes the form of an XSD (XML Schema Definition Language) Schema. Jacob Sebastian's book explains all... view full description

Buy from Amazon.com: $29.99
Buy from Amazon.co.uk: £19.99
Free eBook download

Mastering SQL Server Profiler book

Mastering SQL Server Profiler by Brad McGehee
(1st Edition, January 2009)

Brad McGehee's "from the ground up" guide to SQL Server's most powerful performance diagnostic tool... view full description

Buy from Amazon.com: $29.99
Buy from Amazon.co.uk: £19.99
Free eBook download

SQL Server execution plans book

SQL Server Execution Plans by Grant Fritchey
(1st Edition, June 2008)

Why is my query running slow? Why isn't my index getting used? In order to answer these questions, you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed guide to this essential topic... view full description

Buy from Amazon: $29.99
Free eBook download (PDF)

SQLServerCentral.com
Visit the #1 education and community site for the SQL Server Community, for articles, resources, forums, sample scripts and book reviews.

SQLServerCentral.com
Ask.SqlServerCentral.com
Visit our rapid fire stackoverflow-style Q&A site for all things SQL Server. Ask questions, answer them, vote good answers up and bad ones down, build your reputation in badges.

ask.SqlServerCentral.com
Simple-Talk.com
Visit our online technical journal and community hub for SQL Server, .NET and Exchange professionals.

Simple-Talk.com