Click here to monitor SSC
SQL Server Performance Tuning Using Wait Statistics: A Beginner's Guide

SQL Server Performance Tuning Using Wait Statistics: A Beginner's Guide

This beginner's guide by Jonathan Kehayias and Erin Stellato covers the basics of using wait statistics; topics include the SQLOS scheduler, performance tuning, baselines, and more. Read more...

Tribal SQL

Tribal SQL

Tribal SQL, is a reflection of how a DBA's core and long-standing responsibilities sit alongside new thinking and fresh ideas about where the DBA role is going, and what it means to be a DBA in today's businesses. Read more...

Fundamentals of SQL Server 2012 Replication by Sebastian Meine

Fundamentals of SQL Server 2012 Replication by Sebastian Meine

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book begins with a short overview that introduces you to the technologies that make up replication. In the following chapters, the book will walk you through setting up different replication scenarios. Read more...

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

When things go wrong, a DBA's reputation depends on an understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity. This book shows you how to control your transaction log, so that it doesn't control you. Read more...

The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman

The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman

FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in a special folder on the NTFS file system, while bringing that data under the transactional control of SQL Server. This book describes both the way it works and the implementation, adminstration and troubleshooting of it. Read more...

SQL Server Execution Plans, Second Edition, by Grant Fritchey

SQL Server Execution Plans, Second Edition, by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy. Read more...

SQL Server Concurrency: Locking, Blocking and Row Versioning

SQL Server Concurrency: Locking, Blocking and Row Versioning

Your application can have impeachable indexes and queries, but they won't help you if you can't get to your data because another application has it locked. That's why every DBA and developer must understand SQL Server concurrency and how to troubleshoot excessive blocking or deadlocking. Kalen Delaney's book is your guide. Read more...

Peter Larsson

The Road to Professional Database Development

"In this Comunity Book project, I will describe everything that I believe a developer, versed in the art of procedural programming, needs to understand in order to write fast, efficient SQL Code. Your feedback will help shape the book, and determine exactly what is covered, and in what depth!" – Peter Larsson. Read more...

SQL Backup and Restore

SQL Backup and Restore

A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool. Read more...

Red Gate Books

EPUB versions of the books

The EPUB versions of our books are available to download for members of the site. Read more...

Fabiano Amorim

Complete Showplan Operators

Fabiano Amorim has taken the time to reallv drill into the behavior of a small set of execution plan operators in an effort to explain the optimizer's behavior. He's explored why things happen, how you can change them, positively or negatively, and he's done it all in an approachable style. Read more...

Jonathan Kehayias

Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, 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". Read more...

SQL Server Hardware

SQL Server Hardware

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. Read more...

SQL Server Statistics

SQL Server Statistics

A Distribution Statistics object is a sampled map of the distribution of data in a table. Such statistics help the Query Optimizer of SQL Server's Database Engine to translate the 'logical' SQL Query into the best strategy for doing all the physical operations of joining, sorting, and selecting the data. Most of the time, this work happens effectively, but occasionally, if the statistics no longer reflect what is actually in the table, then queries can suddenly run grindingly slow. At this point, the DBA must intervene to correct the problem. Read more...

Inside the SQL Server Query Optimizer

Inside the SQL Server Query Optimizer

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. Read more...

The Red Gate Guide to SQL Server Team-based Development

The Red Gate Guide to SQL Server Team-based Development

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. Read more...

Performance Tuning with SQL Server Dynamic Management Views

Performance Tuning with SQL Server Dynamic Management Views

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. Read more...

Tony Davis

Performance Tuning with SQL Server Dynamic Management views - eBook Download

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. Read more...

Defensive Database Programming

Defensive Database Programming

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. Read more...

Neil Davidson

Don't Just Roll the Dice - eBook Download

Neil Davidson has created a short handbook with the theory, practical advice and case studies, to enable you to successfully price your software. Read more...

Neil Davidson

Don't Just Roll The Dice

Neil Davidson has created a short handbook with the theory, practical advice and case studies, to enable you to successfully price your software. Read more...

Brad's Sure Guide to SQL Server Maintenance Plans

Brad's Sure Guide to SQL Server Maintenance Plans

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. Read more...

Protecting SQL Server Data

Protecting SQL Server Data

John Magnabosco's excllent new book, "Protecting SQL Server Data", 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. Read more...

Brad McGehee

How to Become an Exceptional DBA, 2nd Edition

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... Read more...

Rodney Landrum

SQL Server Tacklebox

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 Read more...

Phil Factor

Confessions of an IT Manager, 2nd Edition

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. Read more...

Jacob Sebastian

The Art of XSD

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... Read more...

Brad McGehee

Mastering SQL Server Profiler

Brad McGehee's "from the ground up" guide to SQL Server's most powerful performance diagnostic tool... Read more...

The Art of SQL Server Filestream - eBook Download

The Art of SQL Server Filestream - eBook Download

Read more...

Grant Fritchey

SQL Server Execution Plans

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... Read more...

Recommended site

PInvoke.net is a user-driven wiki which provides .NET developers with native method signatures, so they don't have to spend time writing them from scratch.

Check out PInvoke.net!

Most Viewed

Troubleshooting SQL Server: A Guide for the Accidental DBA
 Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, provide... Read more...

Exchange 2010 - A Practical Approach
 Jaap's Practical Guide to Exchange Server 2010 draws upon all that experience to deliver an easy-to-use... Read more...

Brad's Sure Guide to SQL Server Maintenance Plans
 Brad's Sure Guide to Maintenance Plans shows you how to use the Maintenance Plan Wizard and Designer to... Read more...

Inside the SQL Server Query Optimizer
 This book will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the... Read more...

SQL Server Hardware
 SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent... Read more...