SQL Server Videos by Release Date

 

SQL Server 2008 T-SQL Enhancements

Learn about new T-SQL enhancements in SQL Server 2008.

Covers: T-SQL enhancements, variable assignment, parameters, aggregates and summaries, and coding improvements.

Skill Level: 200 - Intermediate

Video Length: 09:09

Release Date: 2009-03-26

Date and Time Data Types in SQL Server 2008

Learn about new SQL Server 2008 data types designed for larger and more precise date and time storage options.

Covers: T-SQL, SQL Server 2008, Date and Time, Data Type Precision, T-SQL Date and Time Functions.

Skill Level: 200 - Intermediate

Video Length: 08:54

Release Date: 2008-11-24

SQL Server Management Studio 2008

Learn about new additions and features of SQL Server Management Studio 2008.

Covers: SQL Server Management Studio, Connectivity Changes, and Query Output Options.

Skill Level: 200 - Intermediate

Video Length: 10:42

Release Date: 2008-11-06

Introducing SQL Server 2008

Get a high-level overview of what's new in SQL Server 2008 for developers, dbas, analysts, and anyone using SQL Server 2008.

Covers: The SQL Server Storage Engine, New Data Types, Data Warehousing Improvements, Integration Services, and SSMS changes.

Skill Level: 000 - Overview

Video Length: 09:47

Release Date: 2008-11-04

Copying and Moving SQL Server Databases

Learn how to easily copy and move your SQL Server 2005 and 2008 databases using backups - which is much easier than you might think.

Covers: Database Management, SQL Server Management Studio, File System operations, and Administrative Tasks.

Skill Level: 100 - Beginner

Video Length: 10:05

Release Date: 2008-10-30

Copying and Moving SQL Server Logins

Learn how to transfer and re-map SQL Server Logins from one server to another, and see how to enumerate and troubleshoot logins against assigned users and roles within SQL Server databases.

Covers: Database Management, Logins, Security, Roles and Users.

Skill Level: 200 - Intermediate

Video Length: 09:56

Release Date: 2008-10-30

Attaching and Detaching SQL Server Databases

Learn the exact steps you'll need to take to successfully detach and attach SQL Server 2005 and 2008 databases in order to move or copy them.

Covers: SQL Server Management Studio, the SQL Server File System, and Database Management options required to attach and detach SQL Server 2005/2008 databases.

Skill Level: 100 - Beginner

Video Length: 10:33

Release Date: 2008-10-29

Options for Copying and Moving Databases

Learn about technical considerations for moving and copying SQL Server databases, and learn about the videos and options available for copying and moving your own databases.

Covers: Database Management, File System and the SQL Server Storage Engine, Logins, Users and Roles and their impacts on copying and moving databases.

Skill Level: 000 - Overview

Video Length: 05:45

Release Date: 2008-10-20

Using SQL Server Templates

In this video you'll learn how to use, create, and manage SQL Server Templates.

Covers: Code Reuse, T-SQL, SSMS, Query Analyzer, and Code Management.

Skill Level: 200 - Intermediate

Video Length: 07:09

Release Date: 2008-10-08

Nibbling Deletes

Learn how to execute large numbers of deletes from large tables without negatively impacting concurrent write operations.

Covers: The SQL Server Storage Engine, and T-SQL tips and tricks.

Skill Level: 300 - Advanced

Video Length: 09:19

Release Date: 2008-09-24

Restoring SQL Server 2000 Databases

Learn how to use SQL Server Enterprise Manager to test your database backups as part of a disaster recovery and to restore and recover your SQL Server 2000 databases in the case of a disaster.

Covers: Backups, Restore and Recovery, Recovery Options, and SQL Server Enterprise Manager.

Skill Level: 200 - Intermediate

Video Length: 12:45

Release Date: 2008-09-16

Restoring Databases with SQL Server Management Studio

Learn how to both test your database backups as part of your disaster recovery plan, as well as how to restore and recover your SQL Server 2005 and 2008 databases in the case of a disaster.

Covers: Backups, Recovery, Recovery Options, and SQL Server Management Studio.

Skill Level: 200 - Intermediate

Video Length: 12:35

Release Date: 2008-09-05

Troubleshooting SQL 2000 Maintenance Plans

Learn troubleshooting tricks for addressing problems with your SQL Server 2000 maintenance plans.

Covers: Backups, Maintenance Plans, and SQL Server Enterprise Manager.

Skill Level: 200 - Intermediate

Video Length: 07:44

Release Date: 2008-09-02

Troubleshooting SSMS Maintenance Plans

Check out troubleshooting tips and tricks and learn how to troubleshoot problems with your SQL Server 2005 and 2008 Maintenance Plans.

Covers: Backups, Maintenance Plans, and SQL Server Management Studio.

Skill Level: 200 - Intermediate

Video Length: 08:58

Release Date: 2008-08-28

Maintenance Plans with Management Studio

Learn how to create SQL Server 2005 and 2008 Maintenance plans using SQL Server Management Studio.

Covers: Maintenance Plans, Backups, and SQL Server Management Studio.

Skill Level: 100 - Beginner

Video Length: 10:45

Release Date: 2008-08-26

Maintenance Plans with Enterprise Manager

Learn how to create SQL Server Maintenance plans using SQL Server Enterprise Manager.

Covers: Maintenance Plans, Backups, and Enterprise Manager.

Skill Level: 100 - Beginner

Video Length: 10:27

Release Date: 2008-08-21

Backups with SQL Server Management Studio

Learn the ins and outs of manually executing backups for SQL Server 2005 and 2008 databases using SQL Server Management Studio.

Covers: Manual Backups, SQL Server Management Studio, Log File Management.

Skill Level: 100 - Beginner

Video Length: 09:49

Release Date: 2008-08-05

Backups with Enterprise Manager

Learn how to manually backup SQL Server 2000 databases using SQL Server Enterprise Manager.

Covers: Manual Backups, Enterprise Manager, Log File Management.

Skill Level: 100 - Beginner

Video Length: 09:15

Release Date: 2008-08-01

SQL Server Backup Best Practices

Learn about SQL Server Backup best practices and the role of disaster recovery plans.

Covers: Best Practices, Disaster Recovery, Backups, and Recovery.

Skill Level: 000 - Overview

Video Length: 12:14

Release Date: 2008-07-19

How to use SQLServerVideos.com

Want the inside scoop on how to use SQLServerVideos.com? Check out this short video to make the most of your visits to the site.

Covers: How to use SQLServerVideos.com and associated resources.

Skill Level: 000 - Overview

Video Length: 05:19

Release Date: 2008-07-18

Shrinking SQL Server Log Files

Learn about the kinds of conditions that make log files adversely grow - and see how to troubleshoot and prevent these problems from blowing your databases out of space.

Covers: Log Files, Transactions, the SQL Server Storage Engine, and Backups.

Skill Level: 300 - Advanced

Video Length: 11:45

Release Date: 2008-07-18

Managing SQL Server 2000 Log Files

Learn how to set database recovery models and properly size and configure file-growth for your SQL Server 2000 databases.

Covers: Log Files, Recovery, Backups, Management, and Enterprise Manager.

Skill Level: 100 - Beginner

Video Length: 10:38

Release Date: 2008-07-11

Managing SQL Server 2005 & 2008 Log Files

Learn how to set database recovery models and properly size and configure file-growth for your SQL Server 2005 and 2008 databases.

Covers: Log Files, Recovery, Backups, Management, and SQL Server Management Studio.

Skill Level: 100 - Beginner

Video Length: 10:28

Release Date: 2008-07-11

SQL Server Logging Essentials

Take an in-depth look at SQL Server's use of the transaction log and see how write-ahead logging benefits performance, reliability, and data recovery.

Covers: Log Files, Recovery, Backups, the SQL Server Storage Engine, and Transactions.

Skill Level: 000 - Overview

Video Length: 14:15

Release Date: 2008-07-09

Extra-Wide Covering Indexes

Learn how to overcome the 900 byte limit for indexes in SQL Server.

Covers: Indexes, the SQL Server Storage Engine, and T-SQL tips and tricks.

Skill Level: 400 - Guru

Video Length: 07:55

Release Date: 2008-02-25

SQL Server Backups Demystified

Learn why SQL Server Backups can be hard to understand and master. A must-see video for anyone who isn't familiar with SQL Server Backup functionality.

Covers: Backups, Recovery, Log Files, Transactions, and the SQL Server Storage Engine.

Skill Level: 000 - Overview

Video Length: 11:09

Release Date: 2008-01-03

Understanding Backup Options

Learn about backup types, execution options, storage locations, and other options in order to best address your backup and recovery needs.

Covers: Backups, Recovery, Log Files, Storage Engine, and the SQL Server File System.

Skill Level: 000 - Overview

Video Length: 12:46

Release Date: 2008-01-03

Ad-hoc Reporting

Learn how to easily export Query results to non-technical users using the tools you already have.

Covers: Reporting, Query Output, Query Analyzer, and SQL Server Management Studio.

Skill Level: 100 - Beginner

Video Length: 08:27

Release Date: 2007-03-10