Installing SQL Server 2005 SP2: A Look at the Installation and New Features in Service Pack 2 - Video Series Video Category: Installing, Deploying, and Upgrading SQL Server Skill Level: 100 (Beginner) Versions/Editions Covered: SQL Server 2005 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 series include: 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 Installing SQL Server 2005 SP2 Discussions of the features and screens of the SP2 installation An overview of how to install KB933508 as well as a look at the new GUI/UI features in SSMS regarding scripting 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

Videos in this Series:

Title Skill Length Download Pt. 1 - An Overview of Installing SQL Server 2005 Service Pack 2 (SP2)   300 10 mins. Download Pt. 2 - Applying Service Pack 2 to a Default Instance   300 7 mins. Download Pt. 3 - Discussion on Post-Sp2 Hotfix Options and New Features   300 7 mins. Download Pt. 4 - How to Write Custom Reports for SQL Server 2005 SP2   300 8 mins. Download Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports   400 9 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Helpful Tools for your SQL Server: Lumigent's Log Explorer is a great tool that allows you to read the transaction log and even undo transactions - very helpful in a crunch With SQL Server 2000 Service Pack 3 Microsoft updated versions of the SQL Server 2000 sample applications. Available from http://www.microsoft.com/sql Book You Should Probably Own: Rob Viera's "Professional SQL Server 2000 Programming"