Title	Published Date
Troubleshooting Failed Reporting Services Subscriptions	3/4/2011
Using ClearTrace to Analyze Profiler Results	3/2/2011
Adding a Custom Subject Line to a Data Driven Subscription	3/1/2011
Adding Users and Setting Permissions in Reporting Services	2/27/2011
Moving DSN's	2/24/2011
Perfmon Tips - Loading a Log File, Saving an Image, and Zooming	2/17/2011
Renaming a View - Part 1	2/13/2011
Renaming Views - Part 2	2/13/2011
How to Create an ODBC DSN	2/8/2011
Restoring a Compressed Backup	2/6/2011
Using Backup Compression in SQL Server	2/2/2011
How to Do a Split Backup in SQL Server	1/31/2011
Setting A Database to Read Only	1/24/2011
Using the KILL Statement	1/23/2011
Adding SQL Agent Operators Using TSQL	1/18/2011
Bypassing Blocking using NOLOCK	1/18/2011
Blocking, SP_Who, and SysProcesses	1/9/2011
SP_Who & SP_Who2	1/6/2011
Using the Sysprocesses View	1/4/2011
DBCC InputBuffer - Seeing the Last Executed Command	12/29/2010
Covering a Query That Includes an XML Column	12/26/2010
Using the TSQL Convert Function	12/26/2010
Views, Indexed Views, and NOEXPAND	12/19/2010
Using CONVERT - String Literals to Date Data Types	12/12/2010
Understanding the Two Digit Year Cutoff in SQL Server	12/12/2010
CONVERT - Changing a Date to a String	12/12/2010
Using SET LANGUAGE	12/12/2010
Using CAST to Change Data Types	12/6/2010
Creating a Computed Column as a DATE Data Type	12/5/2010
Indexed Views and the NOEXPAND Hint	12/5/2010
Using sp_HelpText To View Object Defintions	12/5/2010
A Quick Look at View Expansion	11/28/2010
Using the POWER Function	11/28/2010
Get The Definition of a SQL Object Using Object_Definition	11/28/2010
UNION and UNION ALL	11/28/2010
Get the Name - Using the OBJECT_NAME Function	11/28/2010
Using the TSQL Math Operators	11/20/2010
Using the RAND Function	11/20/2010
Exploring CEILING, FLOOR, and ROUND	11/20/2010
Options for Displaying Query Results in SSMS	11/18/2010
Installing the Adventureworks 2008R2 Sample Databases	11/15/2010
Using the USE Statement	11/15/2010
Getting Good Performance using SOUNDEX	11/4/2010
Using the STUFF Function	11/4/2010
Using SOUNDEX and DIFFERENCE	11/3/2010
Using the STR Function	11/2/2010
Using the QUOTENAME Function	10/31/2010
Using the SPACE and REPLICATE String Functions	10/28/2010
Using ASCII, CHAR, UNICODE, and NCHAR	10/27/2010
String Handling Functions Part 6	10/23/2010
String Handling Functions Part 7	10/23/2010
Using SELECT to Generate SQL Commands	10/19/2010
Configuring Word Wrap and Virtual Space in SQL Server Management Studio	10/19/2010
Changing Colors and Fonts in SQL Server Management Studio	10/19/2010
Using SELECT to Concatenate Strings Across Rows	10/19/2010
Using Registered Servers in Managment Studio	10/18/2010
String Handling Functions - Part 1	10/11/2010
String Handling Functions - Part 2	10/11/2010
String Handling Functions - Part 3	10/11/2010
String Handling Functions - Part 4	10/11/2010
String Handling Functions - Part 5	10/11/2010
Using the @@ProcID Function	10/8/2010
Using the FORCESEEK Query Hint	10/7/2010
Capturing Row Counts using Profiler	10/5/2010
SET vs SELECT For Assigning Values to Variables	10/4/2010
Introduction to the CASE Expression	9/30/2010
Using IF and ELSE in TSQL - The Basics of Conditional Logic	9/29/2010
Working With Nulls in SQL Server	9/27/2010
Using the FORCE ORDER Query Hint	9/21/2010
Forcing Query Plans to use LOOP, MERGE, and HASH Joins	9/21/2010
Using LOOP, MERGE, and HASH Join Hints	9/21/2010
Using the OPTION FAST Query Hint	9/12/2010
Using the OPTION HASH GROUP and OPTION ORDER GROUP Query Hints	9/12/2010
Query Hints for Unions - CONCAT UNION, HASH UNION, and MERGE UNION	9/12/2010
Manually Creating and Dropping Statistics	9/9/2010
Exploring the Sys.Stats and Sys.StatColumns Tables	9/7/2010
Which Indexes Are Used By My Query?	9/3/2010
Using Index Hints in a Query	9/2/2010
Controlling Plan Guides	8/31/2010
Creating a Plan Guide for a Parameterized Statement	8/31/2010
Using WITH RECOMPILE With a Stored Procedure - Part 1	8/17/2010
Using WITH RECOMPILE With a Stored Procedure - Part 2	8/17/2010
Introduction to Plan Caching and SysCacheObjects	8/8/2010
Introduction to Plan Guides	7/27/2010
Forced Parameterization for Queries in a Database	7/27/2010
Clearing the Procedure Cache	7/27/2010
Using OPTION RECOMPILE for Statement Level Recompilation	7/27/2010
How To Restore Using a Differential Backup & TSQL	7/18/2010
Practice Your Restore Skills	7/18/2010
Understanding Recovery Models	7/6/2010
Listing Files in a Backup File/Device	7/6/2010
How to Backup a SQL Server Database	7/6/2010
How to Restore a SQL Server Database	7/6/2010
How to Backup the Transaction Log of a SQL Server Database	7/6/2010
Restoring a SQL Server Database Using Transaction Log Backups	7/6/2010
How to do a Copy Only Backup of a SQL Server Database	7/6/2010
Doing a Differential Backup of a SQL Server Database (Simple Recovery)	7/6/2010
Differential Backup and Restore of a SQL Server Database (Full Recovery)	7/6/2010
Splitting Delimited Strings	6/2/2010
Performance Tuning Quiz #3 - Part 2	6/1/2010
Performance Tuning Quiz #3 - Part 2	6/1/2010
Reporting Service Subscriptions & The DBA	5/24/2010
Performance Tuning Quiz #3 - Part 1	5/24/2010
Performance Tuning Quiz #2 - Part 1	5/17/2010
Performance Tuning Quiz #2 - Part 2	5/17/2010
Building a Report Viewer Application - Part 1	5/13/2010
Building a Report Viewer Application - Part 2	5/13/2010
Retrieving a List of Reports from Reporting Services	5/3/2010
Performance Tuning Quiz - Part 3	5/3/2010
Performance Tuning Puzzle - Part 2	4/30/2010
Performance Tuning Puzzle - Part 1	4/28/2010
An Introduction to Check Constraints	4/26/2010
Adding a Dropdown Parameter List to a Report	4/15/2010
Setting up a Multi Valued Parameter List in Reporting Services	4/15/2010
GUID or INT for Primary Key - A Mostly Unbiased Discussion	4/12/2010
Working with Defaults and Constraints	4/7/2010
NewID vs NewSequentialID - Understanding Your UniqueIdentifier Options	4/7/2010
Capturing the Output of a Job Step	3/26/2010
SQL Server Data File Extensions	3/21/2010
Using SPIDS	3/21/2010
Using XP_Instance_RegRead To Get Default Database Path	3/14/2010
Writing to the Registry from TSQL Using XP_Instance_RegWrite	3/14/2010
How to Change the Default Path for New Databases	3/11/2010
Using DatePart and DateName	3/10/2010
Renaming a Database	3/9/2010
Using DB_ID and DB_Name Functions	3/3/2010
Using @@Total_Read and @@Total_Write	3/3/2010
Using @@ServerName and ServerProperty	2/18/2010
Using the ServerProperty Function	2/18/2010
Using the DatabasePropertyEx Function	2/18/2010
Using the Object_ID Function	2/18/2010
Using the IndexProperty Function	2/18/2010
Using Scope_Identity()	2/11/2010
Using Truncate Table	2/11/2010
Using @@Identity	2/8/2010
Setting the Identity Property of a Column	2/5/2010
Using the Identity Function	2/4/2010
Using Identity Insert to Insert Rows	2/2/2010
Using @@Version and xp_MSVer to Get Your SQL Version	2/1/2010
Using the @@Rowcount Function	1/26/2010
Using a UDL File for Database Connectivity Testing	1/25/2010
Error Handling in Transactions using SET XACT_ABORT	1/18/2010
Error Handling in Transactions with Begin Try	1/18/2010
Using @@Trancount in Transactions	1/17/2010
Error Handling in Transactions Using @@Error	1/11/2010
Using Top N with Percentages	1/7/2010
Using the StatsDate Function	1/7/2010
Using TOP in Queries	1/6/2010
Using Set Rowcount	1/5/2010
Using sp_autostats	1/4/2010
Working With Default Filegroups	12/7/2009
Removing a File From a Filegroup	12/7/2009
Understanding DBCC Show_Statistics	12/4/2009
Statistics & Using DBCC Show_Statistics	12/4/2009
Statistics & Query Optimization	12/4/2009
How to Change Database Statistics Settings	12/4/2009
Updating Statistics - Part 1	12/4/2009
Updating Statistics - Part 2	12/4/2009
Updating Statistics - Part 3	12/4/2009
The Impact of Stale Statistics	12/3/2009
Introduction to Statistics	12/3/2009
Statistics Based on Indexes	12/3/2009
Assigning a Clustered Index to a Filegroup	12/2/2009
Marking a Filegroup Read Only	12/2/2009
Filegroups and Adding a New Filegroup	12/1/2009
Introduction to Filegroups And Adding A File to a FileGroup	11/30/2009
Running Jobs Based on Alerts	11/13/2009
Building and Using a One Time Job	11/13/2009
Working with SQL Agent Job Categories	11/13/2009
Sharing Job Schedules	11/13/2009
Shared Job Schedules	11/13/2009
Copy Database Wizard - Using SMO	11/13/2009
Copy Database Wizard - Detach & Copy	11/13/2009
Building SQL Job Schedules	11/2/2009
Use sp_MSForEachDB Instead of Your Own Loop	10/2/2009
Using OpenDataSource to Access Remote Data	10/2/2009
Configuring Agent Operators	10/2/2009
Creating a Replication Subscription	10/2/2009
Creating a Replication Publication	10/2/2009
Creating Stored Procedures	10/2/2009
Using the Dedicated Admin Connection	10/2/2009
Working with Foreign Keys	10/2/2009
Advanced Foreign Key Configuration	10/2/2009
Creating Indexed Views	10/2/2009
Introduction to Instead of Triggers	10/2/2009
More on Instead of Triggers	10/2/2009
Introduction to User Defined Types	10/2/2009
The Basics of Windows Services	10/2/2009
SQL Server Error Logs	10/2/2009
Using SP_Configure	10/2/2009
Putting Databases Into Single User Mode	10/2/2009
How to Script SQL Objects	10/2/2009
Configuring a Post Snapshot Script	10/2/2009
Introduction to SQL Jobs	10/2/2009
Computed Columns - Part 1	10/1/2009
Computed Columns - Part 2	10/1/2009
Using OpenRowset	10/1/2009
Creating and Using Linked Servers	9/26/2009

Full Text Search

SMO Videos

List #2

Cluster

Videos About SMO (SQL Management Objects) Videos About SMO (SQL Management Objects)

Videos about SQL Server Reporting Services (SSRS/R Videos about SQL Server Reporting Services (SSRS/RS)

Videos About Clusters/Clustering (Windows and SQL) Videos About Clusters/Clustering (Windows and SQL)

Videos About XML Videos About XML

Videos About Dot Net Nuke (DNN/DotNetNuke) Videos About Dot Net Nuke (DNN/DotNetNuke)