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 in this book will help... 07 December 2017 2 min read
Claire Brooking Book Review: The Phoenix Project After hearing from Grant Fritchey that "Anyone who wants to know what DevOps really means should read this" Claire Brooking picked up a copy of... 15 October 2014 11 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 might not be well. These... 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 the right combination of theory... 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 scheduler, performance tuning, baselines, and... 01 April 2014 2 min read
Nirmal Sharma Book Review: Optimizing And Troubleshooting Hyper V Networking 2013 If you want to learn how to optimize and troubleshoot Hyper-V, then this book, written by Microsoft people whose day job is to assist customers... 11 February 2014 10 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 overview that introduces you to... 26 July 2013 2 min read
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 books on the same general... 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. Beginners unfamiliar with Hyper-V and... 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 authors, Louis Davidson. Bob Sheldon... 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 be harder if you're just... 22 October 2012 11 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 a special folder on the... 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 to read and interpret execution... 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 how it works. An effective... 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 comes to 59 chapters, yet... 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 because another application has it... 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 agree with. However, following the... 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 recommendations which will always go... 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 truly fantastic software, you need... 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 maintain Exchange 2010 SP1.… 17 January 2012 2 min read