Member of the LearnItFirst.com Video Training Network	Related Video Training Sites: · SQL Programming Training Videos · SQL Server DBA Tutorials

Create a free account · Sign In

SQL Server 2005 Video Tutorial	Home Subscriber Videos

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

Chapter: Installing, Deploying, and Upgrading to SQL Server 2005

Skill Level: 300 (Intermediate)
Duration: 9:30
Size: 10.7MB
Versions/Editions Covered: SQL Server 2005
Added/Updated: Apr 30, 2007

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

Tags for this video: installation quiet mode service packs sp1 sp2

< Back

People Who Downloaded this Video Also Downloaded:

Title	Skill	Download
Creating Database Diagrams in SQL Server Management Studio	200	Download
Part 1 - An Overview of the Default SQL Server Installation	100	Download
Part 2 - My How Things Have Changed - A Video Walk-Through of Some of the New To...	200	Download
Using the PIVOT Operator - An introduction to PIVOT Tables and Crosstab Queries ...	300	Download
ODBC, OLE-DB, UDLs and the SQL Native Client - Connecting to SQL Server and Maki...	200	Download

This video is part of the following video series: "Installing SQL Server 2005 SP2: A Look at the Installation and New Features in Service Pack 2"

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

To view all videos in this series, click here

About the Instructor:

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott Whigham's full bio can be found on the About the Author page)

About Us

· Corporate Philosophy
· Advertise With Us
· Become an Author
· Contact Us

Video Playback

· System Requirements
· TSCC Codec (to play videos)
· Troubleshooting/Problems

Subscriptions

· Pricing/Buy Now
· Testimonials
· Privacy
· Terms of Service