Robert Sheldon Some Books on Programming SQL Server 2012 It is a measure of the range of facilities that are available to the database developer nowadays that three different... 21 February 2013 12 min read
Nirmal Sharma Book Review: Windows Server 2012 Hyper-V Cookbook Windows Server 2012 Hyper-V Cookbook is a comprehensive resource for administrators and consultants looking for practical examples of Hyper-V technology.... 15 February 2013 8 min read
Robert Sheldon Book Review: Pro SQL Server 2012 Relational Database Design and Implementation A book on Relational Database Design and Implementation is always welcome, especially when written by one of Simple-Talk's most popular... 28 November 2012 9 min read
Book Discussion Brad McGehee in Book Discussion Book Review: Troubleshooting SQL Server: A Guide for the Accidental DBA by Jonathan Kehayias and Ted Kreuger Experienced DBAs have a wealth of experience to rely on when it's time to troubleshoot a problem, but it can... 22 October 2012 11 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
Robert Sheldon Book Review: Microsoft SQL Server 2012 Bible A broad topic requires a thick book. the Microsoft SQL Server 2012 Bible is the work of several authors and... 12 October 2012 9 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
Joe Celko Book Review: SQL and Relational Theory by C. J. Date SQL and Relational Theory, by Chris Date, isn't likely to be a book that SQL's greatest defender, Joe Celko, would... 26 September 2012 10 min read
Brad McGehee Book Review: SQL Server Hardware by Glenn Berry Brad finds Glenn Berry's 'SQL Server Hardware' book to be a valuable reference, not so much for the actual hardware... 25 September 2012 9 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
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
Louis Davidson Tim Ford 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... 14 June 2010 4 min read