Title	When Watched
Using Hashbytes in SQL Server 2005 / 2008	1/9/2012
SSIS Lookup Transform Basics	12/21/2011
Filtering XML Elements using the Exist Method	12/13/2011
Solve Parameter Sniffing By Using Local Variables	12/13/2011
Useful Sql Server Full Text Search System Views	12/9/2011
User Defined Functions Metadata	12/9/2011
Using Client Statistics	12/5/2011
Filtered Indexes in SQL Server 2008	11/10/2011
Update SQL Permissions using SMO	11/10/2011
Multistatement UDF's in SQL Server	10/31/2011
SQL Server System Functions	10/28/2011
Solve Parameter Sniffing by Using A Plan Guide	9/6/2011
PIVOT using the PIVOT statement	8/12/2011
User Defined Function Tips	8/2/2011
Using the TIMESTAMP data type in SQL Server	8/1/2011
Finding Failed SQL Server Jobs with SMO	7/29/2011
Backing Up Your Database With SMO	7/29/2011
SET vs SELECT For Assigning Values to Variables	7/29/2011
Options for Displaying Query Results in SSMS	7/29/2011
Basic MERGE statements in SQL Server 2008	7/29/2011
Compound Assignments in SQL Server 2008	7/29/2011
Conditional SQL Server Backups with SMO	7/28/2011
Modifying SQL Server Settings with SMO	7/28/2011
The difference between GRANT, DENY and REVOKE in SQL Server	7/22/2011
The Guest User in SQL Server	6/8/2011
Table Valued Parameters in SQL Server 2008	6/2/2011
Quickly Creating XML Schemas in SQL Server 2005 / 2008	5/18/2011
Introduction to SQL Server XML Schemas, Part 2	5/18/2011
Using FOR XML with SQL Server	5/18/2011
Introduction to SQL Server XML Schemas, Part 1	5/18/2011