Paul White Understanding and Using Parallelism in SQL Server SQL Server is able to make implicit use of parallelism to speed SQL queries. Quite how it does it, and... 03 March 2011 22 min read
Troy Hunt Continuous Integration for SQL Server Databases When it comes to the subject of putting databases into source control, Troy Hunt is no shrinking violet. "Database source... 01 March 2011 28 min read
Robert Sheldon The EXCEPT and INTERSECT Operators in SQL Server The UNION, EXCEPT and INTERSECT operators of SQL enable you to combine more than one SELECT statement to form a... 28 February 2011 14 min read
Brad McGehee Correlating SQL Server Profiler with Performance Monitor Both Performance Monitor and SQL Server Profiler provide valuable information about your server. However, if you combine the data from... 16 February 2011 24 min read
Bob Cramblitt Red Gate’s new Scary DBA: Coming to a town near you Grant Fritchey, The Scary DBA, has now taken the leap from being a Simple-Talk author and FoRG(Friend of Red Gate)... 16 February 2011 5 min read
Robert Sheldon Bulk Inserts via TSQL in SQL Server The trouble with using BCP for reading data into SQL Server is that BCP is a command-line program. Fortunately, the... 31 January 2011 20 min read
Feodor Georgiev Collecting Performance Data into a SQL Server Table Occasionally, when tracking down a performance problem, you have to have information over time on the values of particular sets... 20 January 2011 12 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
Robert Sheldon Data Conversion in SQL Server Most of the time, you do not have to worry about implicit conversion in SQL expressions, or when assigning a... 06 January 2011 17 min read
Dennis Lloyd Sebastian Meine SQL Server Unit Testing with tSQLt When one considers the amount of time and effort that Unit Testing consumes for the Database Developer, is surprising how... 06 January 2011 11 min read
Phil Factor The Parodist: A SQL Server Application Every year, we ask Phil Factor to celebrate the holiday season with an article on SQL Server Programming that is... 20 December 2010 18 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... 08 December 2010 3 min read
Richard Morris Jorge Segarra: DBA of the Day Jorge Segarra, also known on Twitter as 'SQLChicken', was one of the finalists of the Exceptional DBA award this year.... 26 November 2010 13 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... 25 November 2010 23 min read
Robert Sheldon The DELETE statement in SQL Server Of the big four DML statements in SQL Server, the DELETE is the one least written about. This is odd... 25 November 2010 11 min read
Laerte Junior Fun with SQL Server Profiler trace files and PowerShell Running Profiler traces against multiple servers becomes a painful process when it's time to collate and filter all that data.... 25 November 2010 13 min read
Alex Kuznetsov Modifying Contiguous Time Periods in a History Table Alex Kuznetsov is credited with a clever technique for creating a history table for SQL that is designed to store... 25 November 2010 7 min read
Holger Schmeling SQL Server Statistics A Distribution Statistics object is a sampled map of the distribution of data in a table. Such statistics help the... 23 November 2010 3 min read
Phil Factor Consuming JSON Strings in SQL Server It has always seemed strange to Phil that SQL Server has such complete support for XML, yet is completely devoid... 15 November 2010 26 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... 08 November 2010 2 min read
