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

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshoot...

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

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

SQL Server Profiler is one of the most useful of SQL Server's 'built-in' tools, recording data ab...

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

It is a common requirement to make data that lives on one server available on another. You might ...

Few software developers would build an application without using source control, but its adoption...

In this book, Kalen Delaney explains how the new In-Memory OLTP engine works, how it stores and m...

Challenge you in a variety of ways about the different aspects of SQL Server. Some of the questio...

This compilation of 100 SQL Server 2005 and 2008 questions will help update the reader on the lat...

Relational databases place heavy demands on their underlying hardware and many of these databases...

Exchange Server 2010 Service Pack 1 is the latest incarnation of Microsoft's Messaging and Collab...

In the Complete Guide .NET Performance and Optimization, Paul Glavich and Chris Farrell offer a c...

Editorial Review As the backbone to so many commercial communications infrastructures, Microsoft'...

For as long as there has been something to communicate between two persons there has been data. T...

Over the past two years, Simple-Talk has published articles on a variety of SysAdmin topics, from...

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types...

What makes you passionate about working with SQL Server? What lessons have you learned, perhaps t...