Register Log in

SQL Books

Articles tagged SQL Books

SQL Server Internals: In-Memory OLTP

In this book Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help...

2 min read

119 SQL Code Smells

Once you've done a number of SQL code-reviews, you'll be able to identify signs in the code that indicate all might not be well. These...

3 min read

SQL Server Source Control Basics

For efficient team-based database development, and reliable and repeatable database deployments, source control is not optional. This book provides just the right combination of theory...

3 min read

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

2 min read

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

2 min read

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

2 min read

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

2 min read

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

2 min read

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

2 min read

Complete Showplan Operators

Fabiano Amorim has taken the time to really drill into the behavior of a small set of execution plan operators in an effort to explain...

2 min read

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

2 min read

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

3 min read

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

3 min read

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

2 min read

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

5 min read

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

4 min read

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

4 min read

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

3 min read

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

2 min read

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

3 min read