SQL Snippets

  • Article

Administering and Managing SQL 2005

Here's some more inside look at SQL 2005 as we ramp up to Launch! I hope to see you in NYC November 22nd!

Demo 1-1 Creating a New Database https://www.microsoft.com/winme/0509/25037/SQL-02_Demo1-1.asx
Demo 1-2 Creating a Login https://www.microsoft.com/winme/0509/25037/SQL-02_Demo1-2.asx

Demo 2-1 Creating a Backup Device https://www.microsoft.com/winme/0509/25037/SQL-02_Demo2-1.asx
Demo 2-2 Backing up a Database https://www.microsoft.com/winme/0509/25037/SQL-02_Demo2-2.asx
Demo 2-3 Backing up a Transaction Log https://www.microsoft.com/winme/0509/25037/SQL-02_Demo2-3.asx
Demo 2-4 Restoring a Database https://www.microsoft.com/winme/0509/25037/SQL-02_Demo2-4.asx

Demo 3-1 Using SQL Server Configuration Manager https://www.microsoft.com/winme/0509/25037/SQL-02_Demo3.asx

Demo 4-1 Using SQLCMD https://www.microsoft.com/winme/0509/25037/SQL-02_Demo4-1.asx
Demo 4-2 Using SQLCMD in non-interactive mode. https://www.microsoft.com/winme/0509/25037/SQL-02_Demo4-2.asx
Demo 4-3 Using SQL Server Management Studio in SQLCMD mode. https://www.microsoft.com/winme/0509/25037/SQL-02_Demo4-3.asx

Demo 5-1 Analyzing Workload with DTA https://www.microsoft.com/winme/0509/25037/SQL-02_Demo5.asx

Demo 6-1 Using the Maintenance Plan Wizard https://www.microsoft.com/winme/0509/25037/SQL-02_Demo6-1.asx
Demo 6-2 Using the Maintenance Plan Designer https://www.microsoft.com/winme/0509/25037/SQL-02_Demo6-2.asx

Demo 7-1 Using Replication Monitor https://www.microsoft.com/winme/0509/25037/SQL-02_Demo7-1.asx
Demo 7-2 Using Job Activity Monitor https://www.microsoft.com/winme/0509/25037/SQL-02_Demo7-2.asx
Demo 7-3 Monitoring with SQL 2005 MOM Pack https://www.microsoft.com/winme/0509/25037/SQL-02_Demo7-3.asx