New SQL Server 2005 Video Tutorial: How to Move a Database Using The Transfer Database Task in SSIS

How to Move a Database Using The Transfer Database Task in SSIS - view details

Here's yet another option for how to move a database from one server to another (or, 'how to copy a database from one instance to another'): the Transfer Database Task in SQL Server Integration Services (SSIS). The Transfer Database Task can be quite tricky to work with and isn't always the best option so you'll want to watch this video for a good overview before making it a part of your mission-critical operations.

---

• Source: SQL Server videos
• Category: Database Creation, Management and Best Practices
• Skill Level: 300 (Intermediate)
• Length: 12:47 (10.8MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: backups, restores, disaster recovery

New SQL Server 2005 Video Tutorial: How to Move a Database Using The Transfer Database Task in SSIS

How to Move a Database Using The Transfer Database Task in SSIS - view details

Here's yet another option for how to move a database from one server to another (or, 'how to copy a database from one instance to another'): the Transfer Database Task in SQL Server Integration Services (SSIS). The Transfer Database Task can be quite tricky to work with and isn't always the best option so you'll want to watch this video for a good overview before making it a part of your mission-critical operations.

---

• Source: SQL Server videos
• Category: Database Creation, Management and Best Practices
• Skill Level: 300 (Intermediate)
• Length: 12:47 (10.8MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: backups, restores, disaster recovery

New SQL Server 2005 Video Tutorial: Pt. 4 - How to Write Custom Reports for SQL Server 2005 SP2

Pt. 4 - How to Write Custom Reports for SQL Server 2005 SP2 - view details

One of the most interesting new features of SQL Server 2005's Service Pack 2 (SP2) is the ability to write custom reports for administration and include those in your SSMS (SQL Server Management Studio) reports.

Highlights from this video:

• How to write custom reports for SQL Server 2005's SSMS
  
• Deploying the reports to the server
  
• System requirements for using custom reports
• Suggestions for using custom reports in SQL 2005

and much more

---

• Source: SQL Server videos
• Category: Installing, Deploying, and Upgrading SQL Server
• Skill Level: 300 (Intermediate)
• Length: 7:45 (8.02MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: sp1, sp2, service packs, installing, installation, new features

New SQL Server 2005 Video Tutorial: How to Move a Database Using Detach and Attach

How to Move a Database Using Detach and Attach - view details

Yet another way to move a database from one instance/server to another is to detach the database from the source and then attach the database to the destination (or to both the source and destination if you want to just copy the database).

Highlights from this video:

• When should I use detach/attach instead of backup/restore to copy/move my database to a new server?
  
• Best practices using detach/attach
  
• Detaching using SSMS and T-SQL
• Attaching using SSMS and T-SQL

and much more

---

• Source: SQL Server videos
• Category: Database Creation, Management and Best Practices
• Skill Level: 200 (Beginner - Intermediate)
• Length: 10:30 (9.0MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: move drive, new servers

New SQL Server 2005 Video Tutorial: Pt. 3 - Discussion on Post-Sp2 Hotfix Options and New Features

Pt. 3 - Discussion on Post-Sp2 Hotfix Options and New Features - view details

This tutorial is an overview of how to install KB933508 as well as a look at the new GUI/UI features in SSMS regarding scripting.

Helpful links:

• View KB933508 here
• What's New in SQL Server 2005 SP2 document

---

• Source: SQL Server videos
• Category: Installing, Deploying, and Upgrading SQL Server
• Skill Level: 300 (Intermediate)
• Length: 7:15 (6.24MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: sp1, sp2, service packs, installing, installation, quiet mode

New SQL Server 2005 Video Tutorial: SQL DBA 101: How to Quickly Schedule a Backup Job

SQL DBA 101: How to Quickly Schedule a Backup Job - view details

This video is a user request from Ross who asked us to, 'A step-by-step document (or video) outlining the steps required to setup a backup routine (using the built-in management tools) that will backup the entire database, every 12 hours, overwriting the previous backup. Also, if possible, additional comments that explain how "not" to overwrite the previous backups.'

Okay - easy enough! This video is the quickest route to that purpose so, if you want to see how to quickly do backups, this video is for you.

Highlights from this video:

• How to understand the "Backup Database" pane in SSMS
  
• Editing T-SQL backup scripts and understanding the options available
  
• How to create a SQL job
  
• How to create a T-SQL based SQL job
  
• How to Schedule a SQL Job
  
• How to use Maintenance Plans to implement a backup job

and much more

---

• Source: SQL Server videos
• Category: Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling
• Skill Level: 200 (Beginner - Intermediate)
• Length: 6:45 (7.05MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: database administration, shared schedules, jobs

New SQL Server 2005 Video Tutorial: Pt. 2 - Applying Service Pack 2 to a Default Instance

Pt. 2 - Applying Service Pack 2 to a Default Instance - view details

Now that you've downloaded Service Pack 2 and watched the first video on the various bits and pieces associated with SP2, you'll need to begin the installation of Sp2.

Highlights from this video:

• Installing SP2
• Discussions of the features and screens of the SP2 installation
  

and much more

---

• Source: SQL Server videos
• Category: Installing, Deploying, and Upgrading SQL Server
• Skill Level: 300 (Intermediate)
• Length: 6:31 (5.90MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: sp1, sp2, service packs, installing, installation, quiet mode

New SQL Server 2005 Video Tutorial: How to Move a Database Using Backup and Restore

How to Move a Database Using Backup and Restore - view details

This video tutorial shows you one technique for moving/copying a database from one server/instance to another using backup and recovery. There are many techniques for moving and copying databases and, if you haven't moved databases from server to server before, you'll want to be familiar with all techniques.

Highlights from this video:

• Taking and restoring backups
  
• Understanding the RESTORE DATABASE dialog box
  
• Resolving issues with restoring databases on other servers
  
• Discussion of orphaned Logins
  
• Discussion of database compatibility and using sp_dbcmptlevel to view/change compatibility level
• How to view the SQL Server version in T-SQL
  

and much more

---

• Source: SQL Server videos
• Category: Database Creation, Management and Best Practices
• Skill Level: 200 (Beginner - Intermediate)
• Length: 9:15 (8.44MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: backups, restores, disaster recovery

New SQL Server 2005 Video Tutorial: My Favorite SSMS Tweak (by Scott Whigham)

My Favorite SSMS Tweak (by Scott Whigham) - view details

This is a quick video that shows Scott Whigham, author of LearnSqlServer.com, talking about his favorite SQL Server Management Studio (SSMS) tweak. This is only about 6:45 but it could save you a few minutes each day!

---

• Source: SQL Server videos
• Category: Tools, Utilities and Common Tasks for Managing SQL Server
• Skill Level: 100 (Beginner)
• Length: 6:45 (6.65MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: sql tweak, tips and tricks, best practices, sqlwb.exe

New SQL Server 2005 Video Tutorial: Options Available for Moving Databases From One Instance/Server to Another

Options Available for Moving Databases From One Instance/Server to Another - view details

One of the most common questions that Scott Whigham (author of this site) gets is, 'How do I move/copy a database from ServerA to ServerB?' and this series is meant to help you understand the options available and how to do the copy/move.

This video is just an overview of the options for moving databases around your environment are; it is not a demo/tutorial, per se. You'll definitely want to watch the other videos in this series to view the demo/tutorials.

Highlights from this video:

• Options for migrating SQL 2000 to SQL 2005 and SQL 2005 to SQL 2005
  
• Differences between an upgrade and a migration
  
• Backup/Restore
  
• Detach/Attach
  
• SQL Server Integration Services (SSIS) Tasks
  
• Scripting with the SQL Server 2005 Database Publishing Wizard

and much more. NOTE: During the lecture, Scott makes a typo in the discussion of database compatibility levels. The correct stored procedure should be sp_dbcmptlevel

---

• Source: SQL Server videos
• Category: Database Creation, Management and Best Practices
• Skill Level: 300 (Intermediate)
• Length: 12:30 (8.73MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: migrate, upgrade, upgrading, migration, backup and restore, restoring, detaching, how to

New SQL Server 2005 Video Tutorial: Options Available for Moving Databases From One Instance/Server to Another

Options Available for Moving Databases From One Instance/Server to Another - view details

One of the most common questions that Scott Whigham (author of this site) gets is, 'How do I move/copy a database from ServerA to ServerB?' and this series is meant to help you understand the options available and how to do the copy/move.

This video is just an overview of the options for moving databases around your environment are; it is not a demo/tutorial, per se. You'll definitely want to watch the other videos in this series to view the demo/tutorials.

Highlights from this video:

• Options for migrating SQL 2000 to SQL 2005 and SQL 2005 to SQL 2005
  
• Differences between an upgrade and a migration
  
• Backup/Restore
  
• Detach/Attach
  
• SQL Server Integration Services (SSIS) Tasks
  
• Scripting with the SQL Server 2005 Database Publishing Wizard

and much more. NOTE: During the lecture, Scott makes a typo in the discussion of database compatibility levels. The correct stored procedure should be sp_dbcmptlevel

---

• Source: SQL Server videos
• Category: Database Creation, Management and Best Practices
• Skill Level: 300 (Intermediate)
• Length: 12:30 (8.73MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: migrate, upgrade, upgrading, migration, backup and restore, restoring, detaching, how to

New SQL Server 2005 Video Tutorial: Options Available for Moving Databases From One Instance/Server to Another

Options Available for Moving Databases From One Instance/Server to Another - view details

One of the most common questions that Scott Whigham (author of this site) gets is, 'How do I move/copy a database from ServerA to ServerB?' and this series is meant to help you understand the options available and how to do the copy/move.

This video is just an overview of the options for moving databases around your environment are; it is not a demo/tutorial, per se. You'll definitely want to watch the other videos in this series to view the demo/tutorials.

Highlights from this video:

• Options for migrating SQL 2000 to SQL 2005 and SQL 2005 to SQL 2005
  
• Differences between an upgrade and a migration
  
• Backup/Restore
  
• Detach/Attach
  
• SQL Server Integration Services (SSIS) Tasks
  
• Scripting with the SQL Server 2005 Database Publishing Wizard

and much more. NOTE: During the lecture, Scott makes a typo in the discussion of database compatibility levels. The correct stored procedure should be sp_dbcmptlevel

---

• Source: SQL Server videos
• Category: Database Creation, Management and Best Practices
• Skill Level: 300 (Intermediate)
• Length: 12:30 (8.73MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: migrate, upgrade, upgrading, migration, backup and restore, restoring, detaching, how to

New SQL Server 2005 Video Tutorial: Options Available for Moving Databases From One Instance/Server to Another

Options Available for Moving Databases From One Instance/Server to Another - view details

One of the most common questions that Scott Whigham (author of this site) gets is, 'How do I move/copy a database from ServerA to ServerB?' and this series is meant to help you understand the options available and how to do the copy/move.

This video is just an overview of the options for moving databases around your environment are; it is not a demo/tutorial, per se. You'll definitely want to watch the other videos in this series to view the demo/tutorials.

Highlights from this video:

• Options for migrating SQL 2000 to SQL 2005 and SQL 2005 to SQL 2005
  
• Differences between an upgrade and a migration
  
• Backup/Restore
  
• Detach/Attach
  
• SQL Server Integration Services (SSIS) Tasks
  
• Scripting with the SQL Server 2005 Database Publishing Wizard

and much more. NOTE: During the lecture, Scott makes a typo in the discussion of database compatibility levels. The correct stored procedure should be sp_dbcmptlevel

---

• Source: SQL Server videos
• Category: Database Creation, Management and Best Practices
• Skill Level: 300 (Intermediate)
• Length: 12:30 (8.73MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: migrate, upgrade, upgrading, migration, backup and restore, restoring, detaching, how to

New SQL Server 2005 Video Tutorial: Options Available for Moving Databases From One Instance/Server to Another

Options Available for Moving Databases From One Instance/Server to Another - view details

One of the most common questions that Scott Whigham (author of this site) gets is, 'How do I move/copy a database from ServerA to ServerB?' and this series is meant to help you understand the options available and how to do the copy/move.

This video is just an overview of the options for moving databases around your environment are; it is not a demo/tutorial, per se. You'll definitely want to watch the other videos in this series to view the demo/tutorials.

Highlights from this video:

• Options for migrating SQL 2000 to SQL 2005 and SQL 2005 to SQL 2005
  
• Differences between an upgrade and a migration
  
• Backup/Restore
  
• Detach/Attach
  
• SQL Server Integration Services (SSIS) Tasks
  
• Scripting with the SQL Server 2005 Database Publishing Wizard

and much more. NOTE: During the lecture, Scott makes a typo in the discussion of database compatibility levels. The correct stored procedure should be sp_dbcmptlevel

---

• Source: SQL Server videos
• Category: Database Creation, Management and Best Practices
• Skill Level: 300 (Intermediate)
• Length: 12:30 (8.73MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: migrate, upgrade, upgrading, migration, backup and restore, restoring, detaching, how to

New SQL Server 2005 Video Tutorial: Pt. 3 - Discussion on Post-Sp2 Hotfix Options and New Features

Pt. 3 - Discussion on Post-Sp2 Hotfix Options and New Features - view details

This tutorial is an overview of how to install KB933508 as well as a look at the new GUI/UI features in SSMS regarding scripting.

Helpful links:

• View KB933508 here
• What's New in SQL Server 2005 SP2 document

---

• Source: SQL Server videos
• Category: Installing, Deploying, and Upgrading SQL Server
• Skill Level: 300 (Intermediate)
• Length: 7:15 (6.24MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: sp1, sp2, service packs, installing, installation, quiet mode

New SQL Server 2005 Video Tutorial: How to Move a Database Using Backup and Restore

How to Move a Database Using Backup and Restore - view details

This video tutorial shows you one technique for moving/copying a database from one server/instance to another using backup and recovery. There are many techniques for moving and copying databases and, if you haven't moved databases from server to server before, you'll want to be familiar with all techniques.

Highlights from this video:

• Taking and restoring backups
  
• Understanding the RESTORE DATABASE dialog box
  
• Resolving issues with restoring databases on other servers
  
• Discussion of orphaned Logins
  
• Discussion of database compatibility and using sp_dbcmptlevel to view/change compatibility level
• How to view the SQL Server version in T-SQL
  

and much more

---

• Source: SQL Server videos
• Category: Database Creation, Management and Best Practices
• Skill Level: 200 (Beginner - Intermediate)
• Length: 9:15 (8.44MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: backups, restores, disaster recovery

New SQL Server 2005 Video Tutorial: Pt. 4 - How to Write Custom Reports for SQL Server 2005 SP2

Pt. 4 - How to Write Custom Reports for SQL Server 2005 SP2 - view details

One of the most interesting new features of SQL Server 2005's Service Pack 2 (SP2) is the ability to write custom reports for administration and include those in your SSMS (SQL Server Management Studio) reports.

Highlights from this video:

• How to write custom reports for SQL Server 2005's SSMS
  
• Deploying the reports to the server
  
• System requirements for using custom reports
• Suggestions for using custom reports in SQL 2005

and much more

---

• Source: SQL Server videos
• Category: Installing, Deploying, and Upgrading SQL Server
• Skill Level: 300 (Intermediate)
• Length: 7:45 (8.02MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: sp1, sp2, service packs, installing, installation, new features

New SQL Server 2005 Video Tutorial: My Favorite SSMS Tweak (by Scott Whigham)

My Favorite SSMS Tweak (by Scott Whigham) - view details

This is a quick video that shows Scott Whigham, author of LearnSqlServer.com, talking about his favorite SQL Server Management Studio (SSMS) tweak. This is only about 6:45 but it could save you a few minutes each day!

---

• Source: SQL Server videos
• Category: Tools, Utilities and Common Tasks for Managing SQL Server
• Skill Level: 100 (Beginner)
• Length: 6:45 (6.65MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: sql tweak, tips and tricks, best practices, sqlwb.exe

New SQL Server 2005 Video Tutorial: How to Move a Database Using Detach and Attach

How to Move a Database Using Detach and Attach - view details

Yet another way to move a database from one instance/server to another is to detach the database from the source and then attach the database to the destination (or to both the source and destination if you want to just copy the database).

Highlights from this video:

• When should I use detach/attach instead of backup/restore to copy/move my database to a new server?
  
• Best practices using detach/attach
  
• Detaching using SSMS and T-SQL
• Attaching using SSMS and T-SQL

and much more

---

• Source: SQL Server videos
• Category: Database Creation, Management and Best Practices
• Skill Level: 200 (Beginner - Intermediate)
• Length: 10:30 (9.0MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: move drive, new servers

New SQL Server 2005 Video Tutorial: Pt. 2 - Applying Service Pack 2 to a Default Instance

Pt. 2 - Applying Service Pack 2 to a Default Instance - view details

Now that you've downloaded Service Pack 2 and watched the first video on the various bits and pieces associated with SP2, you'll need to begin the installation of Sp2.

Highlights from this video:

• Installing SP2
• Discussions of the features and screens of the SP2 installation
  

and much more

---

• Source: SQL Server videos
• Category: Installing, Deploying, and Upgrading SQL Server
• Skill Level: 300 (Intermediate)
• Length: 6:31 (5.90MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: sp1, sp2, service packs, installing, installation, quiet mode

New SQL Server 2005 Video Tutorial: SQL DBA 101: How to Quickly Schedule a Backup Job

SQL DBA 101: How to Quickly Schedule a Backup Job - view details

This video is a user request from Ross who asked us to, 'A step-by-step document (or video) outlining the steps required to setup a backup routine (using the built-in management tools) that will backup the entire database, every 12 hours, overwriting the previous backup. Also, if possible, additional comments that explain how "not" to overwrite the previous backups.'

Okay - easy enough! This video is the quickest route to that purpose so, if you want to see how to quickly do backups, this video is for you.

Highlights from this video:

• How to understand the "Backup Database" pane in SSMS
  
• Editing T-SQL backup scripts and understanding the options available
  
• How to create a SQL job
  
• How to create a T-SQL based SQL job
  
• How to Schedule a SQL Job
  
• How to use Maintenance Plans to implement a backup job

and much more

---

• Source: SQL Server videos
• Category: Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling
• Skill Level: 200 (Beginner - Intermediate)
• Length: 6:45 (7.05MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: database administration, shared schedules, jobs

New SQL Server 2005 Video Tutorial: How to Copy a Database to a Web Host Using the SQL Server Database Publishing Wizard

How to Copy a Database to a Web Host Using the SQL Server Database Publishing Wizard - view details

The SQL Server Database Publishing Wizard (SSDPW) is yet another technique for moving databases from one server/instance to another (along with using backup/restore, detach/attach, and SSIS' Transfer Database Task).

Highlights from this video:

• Using the SQL Server 2005 Database Publishing Wizard to deploy locally developed databases to a hosted environment (i.e., a web host)
  
• Who should use the SSDPW
  
• How to deploy SQL databases in APP_DATA folder to a web host using the SSDPW
  
• Scripting options in the SSDPW
• Differences between the scripting options in SSMS (SP2) and the SSDPW
  

and much more

Link to the SSDPW (previously called the SQL Server Hosting Toolkit): download here

---

• Source: SQL Server videos
• Category: Database Creation, Management and Best Practices
• Skill Level: 200 (Beginner - Intermediate)
• Length: 9:30 (12.9MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: webhost.

New SQL Server 2005 Video Tutorial: Pt. 1 - An Overview of Installing SQL Server 2005 Service Pack 2 (SP2)

Pt. 1 - An Overview of Installing SQL Server 2005 Service Pack 2 (SP2) - view details

SQL Server 2005's Service Pack 2 (SP2) is full of both bug fixes and new features and this series talks about installing SP2 and previewing the new features.

Highlights from this video:

• An overview of the issues regarding SP2 including�� discussions of KB933508 and versions 9.00.3042 (a.k.a. build 3042), 9.00.3043 (build 3043), 9.00.3050 (build 3050)
  
• Differences between builds
  
• Discussions of how to integrate custom reports in SP2 (a new featuree)
• Understanding what you need to install
• An overview of the installation of SQL Server 2005 SP2
  

Helpful links:

• Download SP2 here
• View KB933508 here
• SQL Server 2005 Performance Dashboard Reports - custom reports kit
• Feature Pack for SQL 2005 (updated)
• Updated Sample Databases and Applications
• What's New in SQL Server 2005 SP2 document
• Read Me for SP2

---

• Source: SQL Server videos
• Category: Installing, Deploying, and Upgrading SQL Server
• Skill Level: 300 (Intermediate)
• Length: 9:30 (10.7MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: sp1, sp2, service packs, installing, installation, quiet mode