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
Grant Fritchey Change Management and Source Control So, given the many good reasons for using Version Control systems for managing the changes in database applications, how does one go about the rather... 03 March 2011 47 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 installation and configuration, of SQL... 08 December 2010 3 min read
Benjamin Nevarez Index Selection and the Query Optimizer While we all know that the Query Optimizer uses Indexes to produce better execution plans, we don't all know exactly which indexes will give the... 25 November 2010 23 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 you through the inner workings... 08 November 2010 2 min read
Alex Kuznetsov Defensive Error Handling TRY...CATCH error handling in SQL Server has certain limitations and inconsistencies that will trap the unwary developer, used to the more feature-rich error handling of... 28 October 2010 35 min read
Timothy Ford Investigating Transactions Using Dynamic Management Objects There can be a great difference in the performance of a particular routine in a test database, and in a fully loaded production system. When... 30 September 2010 39 min read
Alex Kuznetsov Developing Modifications that Survive Concurrency You can create a database under the assumption that SQL looks after all the problems of concurrency. It will probably work fine under test conditions:... 22 June 2010 40 min read
Alex Kuznetsov Defensive Database Programming Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience... 22 February 2010 3 min read
Jacob Sebastian The Art of XSD – eBook Download When information is exchanged in XML format, you need an agreement between the sender and receiver about the structure and content of the XML document.... 07 October 2009 1 min read
Chris Massey Free eBook: SQL Server Crib-Sheet Compendium For everything you need to know, rather than want to know, about SQL Server Reporting Services, replication, backup, XML, performance, data warehousing and more..… 24 April 2009 1 min read
Brad McGehee Mastering SQL Server Profiler Brad McGehee's "from the ground up" guide to SQL Server's most powerful performance diagnostic tool...… 30 January 2009 2 min read
Simple Talk Published Books Grant Fritchey in Simple Talk Published Books SQL Server Execution Plans Why is my query running slow? Why isn't my index getting used? In order to answer these questions, you have to ask the same return... 30 June 2008 4 min read
