Saskia Parks in Learning Resources Future-Proofing Test Data Management: Solutions for DBAs and Developers A PASS session intro with Hamish Watson and Saskia Parks PASS Data Community Summit is coming around quickly, and I... 01 October 2024 5 min read
Lucy Boyes in Learning Resources Managing sensory overload while attending a conference Attending a conference can be a great move for your career, with all the opportunities for learning and networking that... 26 September 2024 7 min read
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
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... 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... 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
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... 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... 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... 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