October 03, 2008

With my series on Backups mostly complete, here's a sneak peak at the videos that I plan on producing next, in roughly the order that I plan to work on them:

Copying and Moving SQL Server Databases (a new series)

• Overview of Copying and Moving Databases
• Moving Databases by Detaching and Attaching
• Moving Databases by Backing-up and Restoring
• Handling Login/Security Concerns after Moving Databases

What's New in SQL Server 2008 (another new series)

• Introduction to SQL Server 2008
• Changes to SQL Server Management Studio 2008
• Depricated and Obsolete
• Upgrading to SQL Server 2008
• Expanded Data Types (datetime2, etc.)
• Spatial Data Types
• Hierarchical Data Types
• T-SQL Improvements
• FILESTREAM operations
• etc.

SQL Server Backups (some additions to the existing backup series)

• Backing up databases with T-SQL
• Recovering databases with T-SQL
• Third Party Backup Solutions
• Speeding up Backup and Restore Operations

Creating these should keep me busy for a while, but I've already got a good start on the new Copying and Moving databases series. (I'm probably going to release them probably as a group as the first video will be very short, and won't be much good without the other videos.)