Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Programming Training Videos · SQL Server DBA Tutorials
   
SQL Server 2005 Database Administration Training Videos
SQL Server 2005 Videos in Series Home  Subscriber Videos  

An Overview of the AdventureWorks Database (Video Series)

Video Image Video Category: Working with SQL Server 2005 Databases: Creation, Management and Best Practices

Skill Level: 100 (Beginner)

Versions/Editions Covered: SQL Server 2005
AdventureWorks is a very important database in SQL Server 2005 because it (a) is designed to show you how to (correctly) use many of the new features in SQL Server 2005 (as befits a sample database from Microsoft), and (b) it is used in most of the examples in the Books Online, and (c) because so many people use AdventureWorks in their demos! This video series walks you through the AdventureWorks architecture and tries to make sense of it all. AdventureWorks can be intimidating for someone new to SQL Server 2005 but, after watching this series of videos, you'll have a much stronger knowledge of the design and decisions in AdventureWorks.

Videos in this Series:


Miscellaneous Bits & Pieces:
The command-line command "netstat" can show you active connections, TCP port usage, network statistics and more
Performance Tip: Know your hot set. The "hot set" is the amount of data that your users are currently working with in the database. You want to ensure that you have enough memory in the system to cover (a) the OS requirements, (b) the SQL Server process requirements, (c) the hot set, and (d) a little extra in the event that you need it.
The command-line command "net" can be used to for many administrative tasks such as creating shares, creating mapped drives, and much more. Go to command-line, and execute the command "net help" for more details

Other Websites We Offer
LearnIntegrationServices.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!
 
1/6/2009 3:19:10 AM