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 to SQL Server 2005 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 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:

Did you know that the database role "ddladmin" can TRUNCATE the table (delete all rows) but not SELECT? Helpful Keyboard Shortcuts: "CTRL" + "ESC" displays the Start Menu Helpful Keyboard Shortcuts: "ALT" + "F4" closes the application or, if no applications are open, prompts you to shutdown/log off