Fabiano Amorim Operator of the Week – Spools, Eager Spool For the fifth part of Fabiano's mission to describe the major Showplan Operators used by SQL Server's Query Optimiser, he... 20 May 2010 12 min read
Fabiano Amorim Showplan Operator of the Week – BookMark/Key Lookup Fabiano continues in his mission to describe the major Showplan Operators used by SQL Server's Query Optimiser. This week he... 07 May 2010 7 min read
Jonathan Lewis Oracle to SQL Server: Crossing the Great Divide, Part 1 When a SQL expert moves from Oracle to SQL Server, he can spot obvious strengths and weaknesses in the product... 28 April 2010 23 min read
Fabiano Amorim Showplan Operator of the Week – Compute Scalar The third part of Fabiano's mission to describe the major Showplan Operators used by SQL Server's Query Optimiser continues with... 28 April 2010 6 min read
Fabiano Amorim Showplan Operator of the Week – Concatenation Fabiano continues in his mission to describe, one week at a time, all the major Showplan Operators used by SQL... 22 April 2010 3 min read
Fabiano Amorim Showplan Operator of the week – Assert As part of his mission to explain the Query Optimiser in practical terms, Fabiano attempts the feat of describing, one... 14 April 2010 7 min read
Robert Sheldon Managing Transaction Logs in SQL Server The Transaction Log provides the means by which either the complete set of tasks of a database transaction are performed... 12 November 2009 17 min read
Pinal Dave Introduction to Change Data Capture (CDC) in SQL Server 2008 Change Data Capture records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables, and makes a record available of what... 03 August 2009 17 min read
Jacob Sebastian An Introduction to SQL Server FileStream Filestream allows us to store and manage unstructured datain SQL Server more easily. Initially, the accounts of FILESTREAM assumed prodigious... 03 August 2009 19 min read
Robert Sheldon FOR XML in SQL Server: RAW, AUTO, EXPLICIT & PATH Modes Complete guide to the FOR XML clause in SQL Server. Learn all four modes - RAW, AUTO, EXPLICIT, and PATH... 27 May 2009 36 min read
Jacob Sebastian Introduction to XML Schema What is an XML Schema, and why is it important? How did XSD develop from its precursors, DTD and XDR?... 07 May 2009 14 min read
Joe Celko SQL and the Snare of Three-Valued Logic The whole subject of the Three-Valued (also known as ternary, trivalent or 3VL) Logic of SQL tends to trip people... 07 May 2009 13 min read
Anith Sen Facts and Fallacies about First Normal Form When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith... 07 May 2009 15 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,... 24 April 2009 1 min read
Robert Sheldon Full-Text Indexing Workbench Robert Sheldon continues his guide to Full-Text Indexing, by putting down his pen and reaching for SSMS for a practical... 02 February 2009 11 min read
Robert Sheldon Understanding Full-Text Indexing in SQL Server Microsoft has quietly been improving full-text indexing in SQL Server. It is time to take a good look at what... 29 December 2008 19 min read
Brad McGehee SQL Server 2008: Performance Data Collector With Performance Data Collector in SQL Server 2008, you can now store performance data from a number of SQL Servers... 29 December 2008 12 min read
Robert Sheldon SQL Server Index Basics Given the fundamental importance of indexes in databases, it always comes as a surprise how often the proper design of... 25 November 2008 10 min read
Robert Sheldon SQL Server Data Warehouse Cribsheet It is time to shed light on Data Warehousing and to explain how SSAS, SSRS and Business Intelligence fit into... 03 November 2008 21 min read
Brad McGehee SQL Server 2008: The New Data Types Brad continues his helicopter-level view of the most interesting new features of SQL Server 2008 with a look at the... 11 October 2008 15 min read
