Sample Files

The companion CD inside this book contains the sample files that you will use as you perform the exercises in the book. The files and step-by-step instructions in the chapters allow you to learn by doing, which is an easy and effective way to acquire and remember new skills.

Installing the Sample Files

Follow these steps to install the sample files on your computer so that you can use them with the exercises in this book.

1. Remove the companion CD from the package inside this book and insert it into your CD-ROM drive.

   Note 

   An end user license agreement should open automatically. If this agreement does not appear, open My Computer on the desktop or Start menu, double-click the icon for your CD-ROM drive, and then double-click StartCD.exe.

2. Review the end user license agreement. If you accept the terms, select the accept option and then click Next.

   A menu will appear with options related to the book.

3. Click Install Sample Files.

4. Follow the instructions that appear.

   The sample files are installed to the following location on your computer:

   My Documents\Microsoft Press\SQL DB Essentials SBS\\

Using the Sample Files

Each chapter in this book explains when and how to use any sample files for that chapter. When its time to use a sample file, the book will point you to the appropriate file or folder. The chapters are built around scenarios that simulate real programming projects so that you can easily apply the skills you learn to your own work. For SQL Script samples, you will typically open the file in SQL Server Management Studio, highlight the relevant portion of the script, and execute only that portion before proceeding. For Visual Studio projects, you will double-click the .sln file to open the project and navigate within Visual Studio to the relevant code.

Project	Description
Chapter 3	Scripts to learn how to create traces, to study how different actions against the database alter its performance, and to create some deadlock troubleshooting.
Chapter 6	Samples allow you to test each of the different ways to access database information using the different technologies that can be used.
Chapter 7	Samples show you how to perform select operations against the database to obtain different results.
Chapter 8	Samples demonstrate how to create and work with views.
Chapter 9	Samples demonstrate how to use programmable objects to retrieve information.
Chapter 10	AdoNet Samples folder: Shows you how to insert information using ADO.NET objects. Sample Codes folder: Includes different T-SQL scripts to insert information. SSIS folder: Contains samples about how to insert data using Integration Services.
Chapter 11	Samples to learn how to perform delete operations.
Chapter 11-Completed	Contains the final version after performance of all step-by-step operations in the chapter.
Chapter 12	Shows how to perform update operations against the database.
Chapter 12-Completed	Contains the final version after performance of all step-by-step operations in the chapter.

Uninstalling the Sample Files

Follow these steps to remove the  sample files from your computer.

1. In the Control Panel, open Add Or Remove Programs.

2. From the list of Currently Installed Programs, select Microsoft SQL Server 2005 Database Essentials Step by Step.

3. Click Remove.

4. Follow the instructions that appear to remove the sample files.

Note 

Sample files for this book are on the companion CD.