Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · LearnIntegrationServices.com · LearnTransactSql.com
     
Instructor-Led Video Training for SQL Server             * LearnIntegrationServices.com
* LearnTransactSql.com
* More Videobooks...
Email
Password
Register
LearnSqlServer.com LearnSqlServer.com
SQL Server 2008/2005 Videos By Category Home  Subscriber Videos  
Installing, Deploying, and Upgrading SQL Server - Video Category (all video categories)
Video Image This category of videos is designed to help you install and configure your SQL Server 2005 and 2000 installations including keeping your server up-to-date with the latest updates, security patches and hotfixes. You'll learn about configuring all the options during the graphical setup as well as using the automated setup, learn about upgrading SQL Server 2000 to SQL Server 2005, upgrading SQL 7.0 to SQL 2005, running the SQL Server 2005 Upgrade Advisor and more. Also included are best practices and performance tips for installing SQL Server.

Videos in this Category: orange = video series 
blue = individual video 
Click "Download" to download the video or click the video title for more information
TitleSkillView / DownloadLength
Series (2 videos) - Looking at a Default Installation of SQL Server 2005   200 (Click for Videos) 27 mins.
Series (4 videos) - Running The SQL Server 2005 Upgrade Advisor   200 (Click for Videos) 54 mins.
Series (5 videos) - Installing SQL Server 2005 SP2: A Look at the Installation a...   100 (Click for Videos) 40 mins.
Series (7 videos) - Installing SQL Server 2005 for the First Time (SQL Server 20...   200 (Click for Videos) 70 mins.
Over 3 hours of SQL Server tutorials in this category
< Return to list of all videos
Miscellaneous Bits & Pieces:
Disk defragmenters can make your system run faster by reorganizing your files according to usage statistics and by keeping files contiguous. Disk defragmentation programs search out the parts of files that are scattered around the hard drive and attempt to put the files into a contiguous block.
Performance Tip: "WHERE LastName LIKE 'Sm%'" is a fast query but "WHERE column LIKE '%Sm%' is a performance killer. Imagine searching in a phone book for anyone whose last name starts with 'Sm' - easy right? Now try to find anyone whose last name contains the two letters 'sm'. There's a huge difference in the number of pages required to satisfy the two queries
Security Tip: Protect your backups! Many DBAs often do not realize that anyone that can get to your SQL Server database backups can also restore those backups on their own SQL Server. One additional layer of file-based security that you can add in is to put a password on your backup file. This can only be done with Transact-SQL but it cannot be bypassed during the restore
Video search
Company News
ISA Server 2006 tutorials on video
     
Home | About Us | Advertising | Contact Us | Privacy | System Requirements | Terms and Conditions | Testimonials | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© Copyright 2004-2007 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.
5/11/2008 10:21:02 PM