Login

These videos come from our "SQL Server 2005 Database Administration" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

SQL Server 2005 Database Administration

• Skill level: 200-500
• Run Time: 30+ hours (158 videos)
• CourseId: 152

You may download the videos directly from this page or click the video/chapter title for more details (such as what is included in the videos). You will need the TSCC codec installed to view these videos.

Jump to a specific chapter:
-- All Chapters -- 1 - An Introduction to SQL Server 2 - Installing, Deploying, and Upgrading SQL Server 3 - Getting Started with SQL Server 2005 Express Editions 4 - Configuration: Services, Instances, Network Libraries, and More 5 - Tools, Utilities and Common Tasks for Managing SQL Server 6 - Database Creation, Management and Best Practices 7 - Architecture: System Databases, System Tables, and SQL Server Internals 8 - Security for SQL Server: Logins, Users, Roles and More 9 - Disaster Recovery: Backup, Recovery, Clustering, Mirroring, Log Shipping 10 - Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling 11 - Monitoring and Performance Tuning SQL Server 12 - Replication in SQL Server 13 - Miscellaneous - Topics That Do Not Fit Anywhere Else!

• Search for videos within this course

  Search this course:

  Enter your search term below:

Chapter 1: An Introduction to SQL Server 1.1 Part 1 - A Technical Overview of SQL Server: What Is SQL Server? Download 1.2 Part 2 - What Can I Do With SQL Server, Analysis Services, Reporting Services, and Integration Services? Download 1.3 Part 3 - Who Uses SQL Server, Analysis Services, Reporting Services and Integration Services? Download 1.4 Part 4 - Versions, Editions, Licensing, and Pricing Download 1.5 Part 5 - A Look at the Hardware Requirements: CPU, Memory and Hard Drives Download 1.6 Part 6 - Operating Systems and Other Software Requirements Download

Chapter 2: Installing, Deploying, and Upgrading SQL Server 2.1 Part 1 - An Overview of the Setup Process Including Installing the Pre-Requisites Download 2.2 Part 2 - Choosing the Right Installation For Your Organization Download 2.3 Part 3 - Choosing Your Service Accounts and a Tour of SQL Server 2005's Services Download 2.4 Part 4 - Choosing the Right SQL Server Authentication Mode Download 2.5 Part 5 - Collations and How to Choose the Most Compatible Collation Download 2.6 Part 6 - Verifying Our Installation and Reviewing The Install Logs Download 2.7 Part 7 - A Look at the Installed Folders Download 2.8 Part 1 - An Overview of the Default SQL Server Installation Download 2.9 Part 2 - My How Things Have Changed - A Video Walk-Through of Some of the New Tools with SQL Server 2005 Download 2.10 Part 1 - An Overview of the Options Available for Upgrading and Migrating Download 2.11 Part 2 - Installing the SQL Server Upgrade Advisor from the CD and Upgrading From the Web Download 2.12 Part 3 - Running the January 2006 Microsoft SQL Server Upgrade Advisor Against a SQL Server 7.0 Instance Download 2.13 Part 4 - Running the January 2006 Microsoft SQL Server Upgrade Advisor Against a SQL Server 2000 Instance Download 2.14 Pt. 1 - An Overview of Installing SQL Server 2005 Service Pack 2 (SP2) Download 2.15 Pt. 2 - Applying Service Pack 2 to a Default Instance Download 2.16 Pt. 3 - Discussion on Post-Sp2 Hotfix Options and New Features Download 2.17 Pt. 4 - How to Write Custom Reports for SQL Server 2005 SP2 Download 2.18 Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports Download

Chapter 3: Getting Started with SQL Server 2005 Express Editions 3.1 What Are the Express Editions? Download 3.2 Migrating From Express Edition to SQL Server Enterprise/Standard/et al Download 3.3 Pt. 1 - Installing SQL Server 2005 Express Edition on Windows Vista Download 3.4 Pt. 2 - Installing SQL Server 2005 Express Edition on Windows Vista Download 3.5 Pt. 3 - Working with the Documentation and Books Online Download 3.6 Pt. 4 - Working With SQL Server 2005 Management Studio Express Edition Download 3.7 Installing Visual Studio and SQL Server Express Edition - Part 1 Download 3.8 Pt. 2 - Installing SQL Server 2005 Express Editions Download 3.9 Pt. 3 - Post-Install: Examining an Installation of SQL Server 2005 Express Edition Download 3.10 Pt. 4 - Using the SQL Server Configuration Manager Download 3.11 Pt. 5 - Using SQL Server Management Studio (SSMS) Express Download

Chapter 4: Configuration: Services, Instances, Network Libraries, and More 4.1 Multiple Instances - Lecture on When They're Appropriate and Special Considerations Download 4.2 SQL Server 2005 Services and Service Accounts - What They Do and What's New Download 4.3 Part 1 - How to Configure SQL Server 2005 for Remote Connections Using TCP IP and Named Pipes Download 4.4 Part 2 - SQL Server Network Library Discussion - TCP IP Connections and TCP IP Ports Download 4.5 Part 3 - Understanding the SQL Server Configuration Manager's Display of TCP IP Properties Download 4.6 Part 4 - How to Change the SQL Server 2005 TCP Port Using SQL Server Configuration Manager Download 4.7 Part 5 - How to Configure SQL Server 2005 to Listen on Multiple TCP IP Ports Download 4.8 Part 6 - Using Aliases with TCP IP Connections Download

Chapter 5: Tools, Utilities and Common Tasks for Managing SQL Server 5.1 Creating Database Diagrams in SQL Server Management Studio Download 5.2 How to Upgrade The Documentation of SQL Server 2005 (Books Online) Download 5.3 ODBC, OLE-DB, UDLs and the SQL Native Client - Connecting to SQL Server and Making Reusable Connections Download 5.4 Templates in SQL Server Management Studio - What They Are and How to Use Them Download 5.5 My Favorite SSMS Tweak (by Scott Whigham) Download 5.6 Building a Custom MMC for Use with SQL Download

Chapter 6: Database Creation, Management and Best Practices 6.1 An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF) Download 6.2 An Overview of the AdventureWorksDW Database Download 6.3 An Overview of the Northwind Database Download 6.4 Database Compatibility Levels and sp_dbcmptlevel Download 6.5 Part 1 - An Overview of the AdventureWorks Database Download 6.6 Part 2 - An Overview of the AdventureWorks Database - Database Diagrams and DDL Triggers Download 6.7 How to Copy a Database to a Web Host Using the SQL Server Database Publishing Wizard Download 6.8 How to Move a Database Using Backup and Restore Download 6.9 How to Move a Database Using Detach and Attach Download 6.10 How to Move a Database Using The Transfer Database Task in SSIS Download 6.11 Options Available for Moving Databases From One Instance/Server to Another Download 6.12 Pt. 1 - How to Synchronize Logins Between Two Servers Download 6.13 Pt. 2 - Understanding How Logins in SQL Server Work (SQL Logins, Windows Logins) Download 6.14 Pt. 3 - A Field Guide to Synchronizing Logins Between SQL Servers Download 6.15 Pt. 4 - Issues With SIDs, Server Logins, Principals and Users Download 6.16 Pt. 5 - Understanding the Different Ways to Synchronize Logins Between Servers Download

Chapter 7: Architecture: System Databases, System Tables, and SQL Server Internals 7.1 How SQL Server 2005 Uses the Registry and Changes to the Registry Download 7.2 How SQL Server Logs Errors - The SQL Server Error Log and Configuration Download 7.3 Model Database - An Overview of How to Use It and When to Use It (SQL Server 2005) Download 7.4 TempDb Database - An Overview of How it Works and When to Use It Download 7.5 How to Change the Master Database's File Locations Download 7.6 Pt. 1 - Understanding SQL Server Page Structures and Clustered Index Structure Download 7.7 Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc) Download 7.8 Pt. 3 - Understanding What Really Happens (Internally) When a Page Split Occurs Download 7.9 Pt. 4 - How to View (and Understand) the Contents of the SQL Server Transaction Log Download 7.10 Pt. 5 - What Are 'Ghost Records'? What Happens Internally When You Delete a Row? Download 7.11 Part 1-A Deeper Look at Pages and Extents Using SQL Internals Viewer Download 7.12 Part 2-A Deeper Look at Pages and Extents Using SQL Internals Viewer Download 7.13 Part 3-A Deeper Look at Pages and Extents Using SQL Internals Viewer Download

Chapter 8: Security for SQL Server: Logins, Users, Roles and More 8.1 Creating SQL Server Authentication Logins in the Enterprise Manager Download 8.2 Peculiarities of the Database Role ddl_admin Download 8.3 Part 1 - Cross Database Ownership Chaining - What It Is and When to Use It Download 8.4 Part 2 - Cross Database Ownership Chaining - What It Is and When to Use It Download 8.5 Part 1: How to View Members of a Windows Group Using SQL Download 8.6 Part 2: How to View Members of a Windows Group Using SQL Download

Chapter 9: Disaster Recovery: Backup, Recovery, Clustering, Mirroring, Log Shipping 9.1 Backup and Recovery - An Introduction to the Three Main Types of Backups in SQL Server 2000 Download 9.2 Backup Devices, Backup Sets, Database Dumps and Media Sets Download 9.3 Help - My Transaction Log Is Full and Has Taken Up the Entire Disk! Emergency! Download 9.4 SQL Server 2005 Transaction Log Is Full - log_reuse_wait_desc and sys.databases Error Download 9.5 Pt. 1 - An Overview of SQL Server Clustering Download 9.6 Pt. 2 - An Overview of SQL Server Clustering Download 9.7 Pt. 1 - An Overview of the Active/Passive (Single Instance) Cluster Download 9.8 Pt. 2 - Setting Up an Active/Passive (Single Instance) Cluster Download 9.9 Pt. 3 - Reviewing the Cluster Installation Download 9.10 Pt. 4 - Installing the Client Tools and Managing the Cluster Download 9.11 Pt. 1 - Installing Service Pack 2 on Your SQL Server Cluster Download 9.12 Pt. 2 - Verifying the Service Pack Installation Download 9.13 Pt. 1 - Transactions and Failover Download 9.14 Pt. 2 - Transactions and Failover Download 9.15 Pt. 1 - An Introduction to Log Shipping in SQL Server 2005 Download 9.16 Pt. 2 - Log Shipping Concepts, Architecture and Requirements Download 9.17 Pt. 3 - Why Use Log Shipping? Pros/Cons of Log Shipping and Mirroring/Clustering Download 9.18 Pt. 4 - How to Set Up Log Shipping Using SQL Server Management Studio's Properties Window Download 9.19 Pt. 5 - Configuring the Standby Server for NORECOVERY and Using a Monitor Server Download 9.20 Pt. 6 - Configuring the Standby Server for READ ONLY / STANDBY Access Download 9.21 Pt. 7 - How to Failover Your Log Shipped Database to the Standby Server Download 9.22 Pt. 8 - Log Shipping Security: Credentials, Jobs, Proxy Accounts, Login SIDs and More Download

Chapter 10: Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling 10.1 SQL DBA 101: How to Quickly Schedule a Backup Job Download 10.2 Pt. 1 - Introduction to SQL Server 2005 Maintenance Plans Download 10.3 Pt. 2 - Index-Related Tasks in SQL Server 2005 (the Rebuild Index, Reorganize Index, and Update Statistics options) Download 10.4 Pt. 3 - The Cleanup History, Execute SQL Server Agent job, and Back Up Database Tasks Download 10.5 Pt. 4 - Modifying Maintenance Plans Download 10.6 Part 1 - How to Be a Proactive DBA: What Are Alerts? Download 10.7 Part 2 - Using Event Alerts (Error Alerts) And RAISERROR for Custom Error Alerts Download 10.8 Part 3 - How to Use Alerts with SQL Server System Error Messages and Events Download 10.9 Part 4 - Performance Condition Alerts in SQL Server 2005 Download 10.10 Part 5 - Define a Performance Condition Alert to Keep Your Log From Filling Up Download 10.11 Part 6 - SQL Server 2005 WMI Event Alerts: How to Write WQL for WMI Download 10.12 Part 1- Automation with Stored Procedures: Automate Backup,Restore, Copy with Stored Procedures Download 10.13 Part 2- Writing the Stored Procedure to Backup a Database: Part A Download 10.14 Part 3- Writing the Stored Procedure to Backup a Database: Part B Download 10.15 Part 4- Writing the Stored Procedure to Restore a Database Download 10.16 Part 5 - Writing the Stored Procedure to Copy a Database Download 10.17 Part 6 - Finalizing the Automation with a SQL Job and Windows Task Download

Chapter 11: Monitoring and Performance Tuning SQL Server 11.1 Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Commands Download 11.2 SET Commands for Performance Tuning and Query Execution Statistics Download 11.3 Pt. 1 - Using SQL Profiler - Concepts, Terms and Screens Download 11.4 Pt. 2 - Determining Which Events and Data Columns to Use in Your Trace Download 11.5 Pt. 3 - Performance Tuning Profiler and Traces By Adding Filters and Working with Large Traces Download 11.6 Pt. 4 - Managing, Viewing and Interpreting SQL Server Traces Download 11.7 Pt. 5 - Templates and Working Within the Profiler UI Download 11.8 Part1 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions Download 11.9 Part2 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions Download 11.10 Part3 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions Download 11.11 Part4 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions Download

Chapter 12: Replication in SQL Server 12.1 Pt. 1 - Setting Up the Distributor and Publisher for Transactional Replication Download 12.2 Pt. 2 - Setting Up Publications for Transactional Replication Download 12.3 Pt. 3 - Setting Up Push and Pull Subscriptions Download 12.4 Pt. 1 - An Introduction to the Concepts and Terms of SQL Server Replication Download 12.5 Pt. 2 - The Three Most Common Types of SQL Server Replication Download 12.6 Pt. 3 - Publications and Subscriptions Download

Chapter 13: Miscellaneous - Topics That Do Not Fit Anywhere Else! 13.1 Pt. 1 - Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins Download 13.2 Pt. 2 - Understanding Queues, Routes, Services, and How Our Logon Stored Proc Works Download 13.3 Pt. 3 - Testing the Event Notification and Viewing the Windows Application Event Log Download 13.4 Part 1 - How to Make a Table Read-Only in SQL Server Download 13.5 Part 2 - Filegroups, Data Files, and Placement: How to Place a Table or Index on a Filegroup Download 13.6 Part 3 - Indexes, Data Placement, and How to Kill Everyone (in the Database!) Download 13.7 Pt. 1 - An Introduction to Bulk Operations in SQL Server Download 13.8 Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads Download 13.9 Pt. 3 - Finishing Our Overview of Bulk Load Tools and DROPCLEANBUFFERS Download 13.10 Pt. 4 - An Overview of the BCP Utility and Our Testing Scenarios Download 13.11 Pt. 5 - Format Files and BCP: Creating a Format File To Load Your Flat File Download 13.12 Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files Download 13.13 Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations Download 13.14 Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes Download 13.15 Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP Download 13.16 Pt. 10 - SQL Server Intergration Services BULK INSERT Task Download 13.17 Pt. 11 - Loading Flat Files Using the SQL Server Integration Services Data Flow Task Download 13.18 Pt. 12 - Understanding the FastParse Option Download