WINNER! Best of Tech Ed, Systems Management & Operations

“For systems administrators who want not only complete control but also remediation capabilities, Configuresoft’s Enterprise Configuration Manager is a solution that answers the questions you don’t know to ask. This enterprise configuration management product enables cross-platform management and can monitor, manage and audit hardware and software configurations for the servers and clients in the organization.”

-- Amy Eisenberg, Windows IT Pro 

Hands on Lab DAT015

Build and Deploy Your Database Schema with Visual Studio 2005 Team System for Database Professionals

Lab Notes – Please read before starting the lab exercises

As soon as the virtual machine environment starts, please log off of the VM by selecting Start/LogOff and then log on again per the instructions in the lab manual. If you do not first log off, the final exercise will not work as expected.

The purpose of this lab is to ensure that a database developer has an understanding of the tools and processes required for working in a Microsoft Team Foundation Server environment. Database developers have traditionally been left “out of the loop” when it comes to collaborative database development tools, and Microsoft has developed Visual Studio Team System for Database Professionals to help bridge that gap.

Visual Studio Team System for Database Professionals is designed to assist database developers in three main areas:

• Control Database Change – Understand the differences between databases deployed in multiple locations (such as Development and Production) or understand how databases change between initial deployment and currently operating revisions.
• Automated Unit Testing – Utilize the built-in framework to develop database specific unit tests to ensure your code is delivered with higher quality
• Improved Collaboration -- Database Administrators can use the built in tools to collaborate with developers to approve or shelve changes to database objects and data, as well as communicate changes to other team members.

This lab consists of 2 exercises that walk database developers through managing a schema change between a development and production environment. In the first exercise, you will compare a database deployed in a development environment with one deployed in production. Although the lab does not have you examine the output, take a moment to examine the differences between the 2 databases, and read through the script that is created by the tool. This will give you a good idea as to the magnitude of the change, and how much work it will be to bring both databases into sync.

In the second exercise, you will make the necessary changes to the schema and submit those changes to the source code depot located within Team Foundation Server. Then you will assume the role of the database manager and either approve or shelve the changes (In the exercise you will shelve the changes)

This lab demonstrates the power of Visual Studio Team System for Database Professionals by introducing database developers to an entirely new way of development collaboration.

HOL ARC003

Explore Team Foundation Server for Architects

Lab Notes – Please read before beginning this lab

The purpose of this lab is to step you through some of the basic features of Microsoft Team Foundation Server. This is NOT a technical lab, but rather a lab that helps you explore some of the project management features that are built into Team Foundation Server and Visual Studio Team System.

Team Foundation Server is an integral part of Visual Studio Team System and contains many useful developer-focused features. It is also a very rich collaboration environment that allows project managers, architects and developers and testers to work together in a tightly coupled manner.

In this lab, you will assume the role of a project manager that has just hired a new lead architect for the project that you are managing. You will add your new team member as an administrator to Team Foundation Server (There is no technical reason that the user needs to be an administrator, this is just how the lab is written) Once you have added your new team member, you will configure the team portal site to contain a new document library and you will upload a document to the library.

Once the team portal is configured, you will begin to build the project plan in Microsoft Project using a checklist that you have already created in Team Foundation Server and you will incorporate tasks from an Excel spreadsheet. Once you have built the project plan, you will make a change in Microsoft Project and note how the Team Foundation Server site is automatically synchronized to these changes.

At the end of this lab there is an optional exercise that steps you through some basic process guidance on agile software development.