Learn SQL Server Chris Shaw in Learn SQL Server Building Your DBA Skillset As a DBA and hiring manager, Chris Shaw has been on those sides of the recruitement process. As an MVP... 06 July 2011 23 min read
Laerte Junior PowerShell Eventing and SQL Server Restores When you're managing a large number of servers, it makes no sense to run maintenance tasks one at a time,... 05 July 2011 13 min read
Joe Celko Arrays in SQL that Avoid Repeated Groups It is certainly possible to fake an Array in SQL, but there are only a few occasions when it would... 05 July 2011 11 min read
Phil Factor How to develop TSQL Code The basic texts for developing SQL code tend to leave unsaid the basic techniques for building routines such as stored... 24 June 2011 15 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
Bahadir Arslan Hosted Team Foundation Server 2010 Review Team Foundation Server (TFS) has expanded its remit to support the whole software development process, but is is not designed... 23 June 2011 22 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
Joe Celko A Tale of Identifiers Identifiers aren't locators, and they aren't pointers or links either. They are a logical concept in a relational database, and,... 09 June 2011 14 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
Grant Fritchey SQL Server Backup and Restore for the Accidental DBA Not everyone who is tasked with the job of ensuring that databases are backed up, and easily restorable, consider themselves... 24 May 2011 15 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
Joe Celko TIME Gentlemen please! The SQL Server temporal datatypes If you are still using the old Sybase DateTime datatype, it is a good idea to move your code to... 12 May 2011 12 min read
Phil Factor PATINDEX Workbench The PATINDEX function of SQL Server packs powerful magic, but it is easy to get it wrong. Phil Factor returns... 12 May 2011 14 min read
Bert Jan van der Steeg Database Management for SharePoint 2010 With each revision, SharePoint becomes more a SQL Server Database application, with everything that implies for planning and deployment. There... 10 May 2011 13 min read
David Berry Performance Implications of Parameterized Queries Why don't we emphasize the huge advantages of parameterized queries over ad-hoc queries in SQL Server? There is a severe... 28 April 2011 19 min read
Grant Fritchey It’s 3AM and I’m on call If you are part of a team that is required to ensure that an application stays running at all hours,... 27 April 2011 11 min read
Robert Sheldon SSIS Event Handlers Basics SSIS event handlers are the simplest means of turning an SSIS script into a reliable system that is auditable, reacts... 26 April 2011 11 min read
Fabiano Amorim ShowPlan Operator of the Week – Split, Sort, Collapse 'Split, Sort & Collapse' is, happily, not a description of the intrepid Fabiano after his epic series of articles about... 11 April 2011 19 min read
