SQL Books Greg Larsen in SQL Books Transact-SQL: The Building Blocks to SQL Server Programming by Gregory A. Larsen Transact SQL (TSQL) is the languaged used to query and update data stored in a SQL Server. This book, written... 20 July 2020 2 min read
SQL Books Kalen Delaney in 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... 07 December 2017 2 min read
SQL Books Robert Sheldon in SQL Books Stairway to SQL Server XML XML has been part of the SQL Standard since 2003, and is essential for any DBA because so many of... 03 April 2017 1 min read
Phil Factor 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... 15 September 2014 3 min read
Robert Sheldon 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... 01 May 2014 3 min read
Simple Talk Editorial Team 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... 01 April 2014 2 min read
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... 26 July 2013 2 min read
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... 16 October 2012 2 min read
Tony Davis 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... 16 October 2012 2 min read
Sven Aelterman Jacob Sebastian 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... 16 October 2012 2 min read
Kalen Delaney 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... 02 October 2012 2 min read
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... 06 June 2012 1 min read
Shawn McGehee 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... 26 March 2012 3 min read
Red Gate Books EPUB versions of the books The EPUB versions of our books are available to download for members of the site.… 21 December 2011 1 min read
Fabiano Amorim Complete Showplan Operators Fabiano Amorim has taken the time to really drill into the behavior of a small set of execution plan operators... 10 October 2011 2 min read
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... 29 September 2011 2 min read
Glenn Berry SQL Server Hardware SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal... 08 December 2010 3 min read
Holger Schmeling SQL Server Statistics A Distribution Statistics object is a sampled map of the distribution of data in a table. Such statistics help the... 23 November 2010 3 min read
Benjamin Nevarez 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... 08 November 2010 2 min read
Red Gate Books 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... 02 November 2010 5 min read
