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 Videos in Series
Home
Subscriber Videos
Installing Service Packs In Your Clustered SQL Server Environment (Video Series)
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:
Title
Skill
Length
Download
Pt. 1 - Installing Service Pack 2 on Your SQL Server Cluster
500
13 mins.
Download
Pt. 2 - Verifying the Service Pack Installation
500
10 mins.
Download
Miscellaneous Bits & Pieces:
Keyboard Shortcut for SQL Server Management Studio: CTRL+N opens a new query window
Performance Tip: TRUNCATE TABLE is much faster than DELETE when removing all rows from a table. One caveat: TRUNCATE TABLE cannot be run on a table with foreign keys
If you see a file/folder that is green in color in Windows Explorer that is an indication that the file is encrypted using EFS (Encrypted File System)
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
More Video Training
·
SQL Programming Training Videos
·
SQL Server DBA Tutorials
·
All of Our Websites
More
·
FAQs
·
Search for videos
·
Site Map
© 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.
1/6/2009 3:57:44 AM