This book starts with an introduction to the core concepts of .NET memory management and garbage ...

If you've designed your SQL code intelligently, and implemented a sensible indexing strategy, the...

This book will teach you everything you need to read the execution plan, for any query of your ow...

When a SQL Server database is operating smoothly and performing well, there is no need to be part...

Inside the SQL Server Tacklebox you'll find day-to-day tools, scripts and techniques to automate ...

This book will help you learn and use XML Schema collections in SQL Server. Prior knowledge of XS...

The SQL Server 2014 In-Memory OLTP engine (a.k.a. Hekaton) is designed from the ground up to expl...

A 2nd edition of Brad McGehee's popular 'career guide' for DBAs, designed to help new and prospec...

Execution plans show you what's going on behind the scenes in SQL Server. They can provide you wi...

SQLServerCentral.com brings you a variety of articles on all aspects of SQL Server from administr...

The goal of Defensive Programming is to produce resilient code that responds gracefully to the un...

The SQL Server Query Optimizer is perceived by many to be a magic black box, transforming SQL que...