Phil Factor Schema-Based Access Control for SQL Server Databases Access-control within the database is important for the security of data, but it should be simple to implement. It is... 09 April 2015 25 min read
Joe Celko The SQL of The Game of Life Joe finds a reference to Conway's Game of Life whilst clearing out his desk, and is suddenly gripped with nostalgia.... 05 June 2014 7 min read
Robert Sheldon TSQL User-Defined Functions: Ten Questions You Were Too Shy To Ask SQL Server User-Defined Functions are good to use in most circumstances, but there just a few questions that rarely get... 19 May 2014 31 min read
Joe Celko Nesting Levels in SQL The 'Structured' part of SQL denotes the fact that queries can be nested inside each other in such a way... 27 January 2014 13 min read
Brad McGehee How to Document and Configure SQL Server Instance Settings Occasionally, when you install identical databases on two different SQL Server instances, they will behave in surprisingly different ways. Why?... 30 January 2012 74 min read
Benjamin Nevarez The SQL Server Query Optimizer To understand how to write SQL code for SQL Server that performs well, it is important to appreciate how the... 03 August 2011 35 min read
Fabiano Amorim Questions about SQL Server Distribution Statistics Fabiano was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current... 23 June 2011 20 min read
Robert Sheldon Table Value Constructors in SQL Server 2008 Table Value Constructors (TVCs) are a useful feature of 2008, allowing you to specify tables of values and expressions. This... 22 June 2011 11 min read
Alex Kuznetsov Yet Another SQL Strategy for Versioned Data There is a popular design for a database that requires a built-in audit-trail of amendments and additions, where data is... 22 June 2011 11 min read
Andrew Clarke SSMS: The Query Window Keyboard Shortcuts Simple-Talk's free wallchart of the most important SSMS keyboard shortcuts aims to help find all those curiously forgettable key combinations... 10 June 2011 5 min read
Robert Sheldon Subqueries in SQL Server Subqueries and derived tables can add great versatility to SQL statements, cut down complexity, but can occasionally be a curse... 26 May 2011 16 min read
Database DevOps Troy Hunt in Database DevOps The 10 Commandments of Good Source Control Management Simple-Talk generally doesn't re-publish anything from another site, but Troy's popular blog post on the Ten Commandments of Source Control... 23 May 2011 19 min read
Tools Phil Factor in Tools RegEx-Based Finding and Replacing of Text in SSMS So often, one sees developers doing repetitive coding in SQL Server Management Studio or Visual Studio that would be much... 14 January 2011 19 min read
