An Overview of the AdventureWorks Database - Video Series 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:

Title Skill Length Download Part 1 - An Overview of the AdventureWorks Database   100 17 mins. Download Part 2 - An Overview of the AdventureWorks Database - Database Diagrams and DDL ...   200 12 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

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 Windows Server 2003 Service Pack 1: You can now run domain controllers on a virtual machine SQL Server 7.0 was the first time that SQL Server supported bullable BIT data types. Previous versions could only be 1 or 0