Title	When Watched
Collections Explained	1/26/2012
Shredding XML Elements with the Xquery Value Function	1/12/2012
Solve Parameter Sniffing by Using OPTION RECOMPILE	12/9/2011
Using the Database Object in SMO	11/28/2011
Connecting to a SQL Server Database with SMO	11/28/2011
Creating SQL Server Jobs with SMO	11/28/2011
What is the Distinct Operator?	11/22/2011
What is the Spool Operator?	11/2/2011
SQL Injection Explained	10/3/2011
Converting a Text Data Type to an XML Data Type	8/9/2011
Sparse Columns in SQL Server 2008	6/21/2011
CONVERT - Changing a Date to a String	12/14/2010
Using CONVERT - String Literals to Date Data Types	12/13/2010
Using TOP in Queries	12/13/2010
Using CAST to Change Data Types	12/13/2010
Indexed Views and the NOEXPAND Hint	12/13/2010
Using sp_HelpText To View Object Defintions	12/13/2010
Creating a Computed Column as a DATE Data Type	12/13/2010
Get the Name - Using the OBJECT_NAME Function	12/3/2010
UNION and UNION ALL	12/3/2010
Get The Definition of a SQL Object Using Object_Definition	12/1/2010
A Quick Look at View Expansion	12/1/2010
Using the POWER Function	11/29/2010
Creating a Performance Counter Log	11/29/2010
Exploring CEILING, FLOOR, and ROUND	11/24/2010
Using the RAND Function	11/23/2010
Using the TSQL Math Operators	11/22/2010
Joining Tables Part 1	11/22/2010
Options for Displaying Query Results in SSMS	11/22/2010
Expression Language Basics	11/18/2010