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  
Database 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. You'll learn all about CREATE DATABASE, the intricacies of ALTER DATABASE as well as how to manipulate (and understand) database properties. You'll work with many of the common admin procedures and functions such as sp_helpdb, sp_helpfile, and DATABASEPROPERTYEX.

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.
Series (5 videos) - How to Synchronize Logins Across Multiple Servers   400 (Click for Videos) 45 mins.
An Overview of the AdventureWorksDW Database   200 Download 24 mins.
An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) ...   200 Download 5 mins.
An Overview of the Northwind Database   100 Download 14 mins.
Database Compatibility Levels and sp_dbcmptlevel   300 Download 11 mins.
Over 3 hours of SQL Server tutorials in this category
< Return to list of all videos
Miscellaneous Bits & Pieces:
Performance Tip: In many instances temporary tables can be rewritten as table variables. Table variables are often faster and do not have the locking issues that temporary tables experience
Helpful Keyboard Shortcuts: "CTRL" + "TAB" navigates forward between panes/worksheets/tabs in an application (add in "SHIFT" to navigate backwards)
Did you know that the fixed server role "Database Creators (dbcreator)" can drop any database on the server? Ouch!
Video search
Company News
T-SQL training videos
     
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/14/2008 5:11:57 PM