SQL Snippets

OK, sorry I haven't posted more of these in the last week, so I'll make up for it now! Here's the whole SQL session picking up from the last posting on the SAC.

Demo 4-1 Understanding User-Schema Separation         https://www.microsoft.com/winme/0509/25037/SQL-01_Demo4.asx 
 
Demo 5-1 Using SQL Agent Proxies                             https://www.microsoft.com/winme/0509/25037/SQL-01_Demo5.asx 
 
Demo 6-1 Configuring Database Mail                            https://www.microsoft.com/winme/0509/25037/SQL-01_Demo6-1.asx 
Demo 6-2 Sending and Checking E-mail                        https://www.microsoft.com/winme/0509/25037/SQL-01_Demo6-2.asx 
 
Demo 7-1 Using Mirrored Backups                               https://www.microsoft.com/winme/0509/25037/SQL-01_Demo7.asx 
 
Demo 8-1 Using SQL Profiler                                       https://www.microsoft.com/winme/0509/25037/SQL-01_Demo8-1.asx 
Demo 8-2 Generating a deadlock                                 https://www.microsoft.com/winme/0509/25037/SQL-01_Demo8-2.asx 
Demo 8-3 Analyzing deadlock using SQL Profiler           https://www.microsoft.com/winme/0509/25037/SQL-01_Demo8-3.asx