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 Using the FOR XML Clause to Return Query Results as XML The FOR XML clause in SQL Server causes a lot of difficulty, mainly because it is rather poorly explained in... 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
Joe Webb Using Covering Indexes to Improve Query Performance Designers of database systems will often assume that the use of a clustered index is always the best approach. However... 29 September 2008 12 min read
Phil Factor Robyn Page Database Design Workbench – Keys Robyn Page and Phil Factor explore the innocent subject of Keys for their latest workbench. Everybody knows about keys. Oh... 19 September 2008 18 min read
Hugh Bin-Haad The Concept of Cardinal Reciprocity- A Primer Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a... 01 April 2008 12 min read
Adam Machanic Service Broker Advanced Basics Workbench SQL Service Broker, an asynchronous queuing and messaging system for SQL Server 2005, is set to change the way we... 15 October 2007 34 min read
Adam Machanic Service Broker Foundations Workbench SQL Service Broker, an asynchronous queuing and messaging system for SQL Server 2005, is set to change the way we... 14 August 2007 18 min read
Greg Larsen Choosing between CLR and T-SQL stored procedures: a simple benchmark In this short article, Greg Larsen performance benchmarks alternative CLR-based and T-SQL stored procedure solutions for retrieving operating system file... 24 April 2007 6 min read
Robyn Page SQL Server XML Cribsheet If you're like me and find XML a bit of an acronym minefield, Robyn Page's Cribsheet will help sort out... 29 March 2007 17 min read
Robyn Page Robyn Page’s SQL Server Cursor Workbench The topic of cursors is the ultimate "hot potato" in the world of SQL Server. Everyone has a view on... 24 January 2007 16 min read
