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             * SQL Programming Training Videos
* SQL Server DBA Tutorials
* More Videobooks...
Email
Password
Register
LearnSqlServer2005.com Subscriber Videos
SQL Server 2005 Videos By Category Home  Subscriber Videos  
Working with SQL Server 2005 Databases: Creation, Management and Best Practices - Video Category (all video categories)
Video Image This category of videos discusses the various ways to create databases, how to manage your database files by expanding or shrinking SQL Server's database files, how filegroups work, and Best Practices for SQL Server databases

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
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) - An Overview of the AdventureWorks Database   100 (Click for Videos) 29 mins.
Series (5 videos) - How to Move and Copy Databases to a New Server/Instance   300 (Click for Videos) 55 mins.
An Overview of the AdventureWorksDW Database   200 Download 24 mins.
An Overview of the Northwind Database   100 Download 14 mins.
Database Compatibility Levels and sp_dbcmptlevel   300 Download 11 mins.
Over 2 hours of SQL Server 2005 tutorials in this category
< Return to list of all videos
Miscellaneous Bits & Pieces:
Performance Tip: Don't apply the "Auto Shrink" database option for a production database. Auto Shrink is very expensive and can negatively impact the performance of your live system
Many people get confused about licensing for their SQL Server when their SQL Server is used for the company website. Bottom line: buying one license for your SQL Server because the web server is only one user is not sufficient. Microsoft requires that each connection that takes advantage of the data from your SQL Server be licensed.
Keyboard Shortcut for SQL Server Management Studio: CTRL+R hides/displays the results pane
Video search
Company News
Windows SharePoint Training
     
Home | About Us | Advertising | Become an Author | Contact Us | Privacy | System Req's | Terms | Testimonials | Work for Us! | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© 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.
7/3/2008 10:08:59 PM