Robert Sheldon Simple Talk Storage 101 by Robert Sheldon The only way to derive meaning from the massive amounts of data collected today is to develop innovative high-performing, high-capacity... 10 May 2021 2 min read
Greg Larsen 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
Books Grant Fritchey in Books SQL Server Execution Plans, Third 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... 04 October 2018 2 min read
Kalen Delaney 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
Robert Sheldon 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
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
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
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
Chris Farrell Under the Hood of .NET Memory Management As well-engineered as the .NET framework is, it's not perfect, and it doesn't always get memory management right. To write... 19 June 2012 1 min read
Jaap Wesselius Exchange 2010 SP1 – A Practical Approach This update of Jaap Wessellius' popular guide to Exchange 2010 covers everything you need to know to install, run and... 17 January 2012 2 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
