Simple-Talk
“The MERGE Statement in SQL Server 2008” August 27, 2010.
“Implementing the OUTPUT Clause in SQL Server 2008” July 22, 2010.
“UPDATE Basics in SQL Server” June 21, 2010.
“SQL Server APPLY Basics” May 24, 2010.
“SQL Server CTE Basics” April 29, 2010.
“Adding Actions to a Cube in SQL Server Analysis Services 2008” March 29, 2010.
“Adding a KPI to an SQL Server Analysis Services Cube” March 2, 2010.
“Implementing User-Defined Hierarchies in SQL Server Analysis Services” February 2, 2010.
“Five Basic Steps for Implementing an Analysis Services Database” January 5, 2010.
“Working with the bcp Command-line Utility” December 10, 2009.
“Managing Transaction Logs in SQL Server” November 12, 2009.
“Using Information Schema Views” October 1, 2009.
“Transact-SQL Formatting Standards (Code Styles)” August 25, 2009.
“Defragmenting Indexes in SQL Server 2005 and 2008” July 31, 2009.
“Working with Precedence Constraints in SQL Server Integration Services” July 7, 2009.
“Using the FOR XML Clause to Return Query Results as XML” May 27, 2009.
“XML Data Modification Workbench” April 28, 2009.
“Working with Property Expressions in SQL Server Integration Services” March 16, 2009.
“Full-Text Indexing Workbench” February 2, 2009.
“Understanding Full-Text Indexing in SQL Server” December 29, 2008.
“SQL Server Index Basics” November 25, 2008.
“SQL Server Data Warehouse Cribsheet” November 3, 2008.
“Using PowerShell to Generate Table-Creation Scripts” October 4, 2008.
“SQL Server 2008 – SSIS Data Profiling task” September 10, 2008.
“SQL Server 2008 SSIS Cribsheet” August 5, 2008.