Title	When Watched
Connecting to a SQL Server Database with SMO	9/26/2011
Finding Failed SQL Server Jobs with SMO	9/26/2011
Using FOR XML with SQL Server	8/25/2011
Getting Good Performance using SOUNDEX	12/24/2010
SET vs SELECT For Assigning Values to Variables	10/17/2010
String Handling Functions - Part 3	10/17/2010
String Handling Functions - Part 2	10/17/2010
String Handling Functions - Part 1	10/17/2010
Generating a Graphical Query Plan	9/13/2009
How to Use the SQL Server 2008 Audit Object	8/29/2009
Multi Statement Query Plans	8/5/2009
Configuring Network Settings for SQL Server	7/3/2009
What is the Spool Operator?	6/6/2009
Insert Statement Operators	6/6/2009
Multistatement UDF's in SQL Server	5/23/2009
Granting Permissions against a Database Object	5/23/2009
Adding a Windows Based Login to SQL Server	5/23/2009
Execution Plan Operator Properties	4/24/2009
Solve Parameter Sniffing By Using OPTIMIZE FOR	4/24/2009
Unpivot Data with a Cross Join in SQL Server	4/15/2009
Speak Like a SSIS Developer	4/11/2009
Executing SSIS Package in SSMS	4/11/2009
Basic MERGE statements in SQL Server 2008	4/11/2009
Solve Parameter Sniffing by Using A Plan Guide	4/11/2009
Enabling C2 Auditing in SQL Server	3/25/2009
Using a UDF in a Computed Columns	3/24/2009
Using the DTA to Assist in Performance Tuning	3/21/2009
Create an Asymmetric Key in SQL Server 2005 / 2008	3/21/2009
Converting a Text Data Type to an XML Data Type	3/13/2009
Compound Assignments in SQL Server 2008	3/5/2009