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

Installing Service Packs In Your Clustered SQL Server Environment (Video Series)

Video Image Video Category: Disaster Recovery: Backup, Recovery, Log Shipping, Clustering and Database Mirroring

Skill Level: 500 (Advanced)

Versions/Editions Covered: SQL Server 2005
Service pack installations are very easy (cross your fingers - maybe we should say that they probably are very easy!) and THANK YOU to the folks at Microsoft for making it so easy. Still, you'll want to have a certain level of comfort with the installation before you have to go do it yourself, right?

This series focuses specifically on installing Service Pack 2 for SQL Server 2005 and, if you will be installing SP1 or another service pack, the screens may be a bit different.

Videos in this Series:


Miscellaneous Bits & Pieces:
Helpful Keyboard Shortcuts: "CTRL" + "ESC" displays the Start Menu
Security Tip: Do not allow applications to issue SELECT,INSERT,UPDATE, or DELETE statements to your database. Instead create a set of stored procedures and require that your applications use these "interfaces" into your database
What query would return the first day of this month? SELECT DATENAME(dw, DATEADD(dd, - DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay

Other Websites We Offer
LearnTransactSQL.com
Don't Forget!
Become a Guru
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
8/21/2008 5:13:03 PM