VSTE Photos and Screen Shots

Project File

thomas murphy — Tue, 27 Jun 2006 01:43:16 GMT

Project File

project file showing ctp3 folder structure

Gert and Cam

thomas murphy — Tue, 20 Jun 2006 17:09:44 GMT

Gert and Cam

Shot from Campbell Session at TechEd.

Invoice Overflow

thomas murphy — Mon, 12 Jun 2006 21:41:19 GMT

Invoice Overflow

Overflowing the Invoice computed column for ExtendedPrice

GenerationPlan - default northwind plan

thomas murphy — Mon, 12 Jun 2006 21:39:29 GMT

GenerationPlan - default northwind plan

Shows the default northwind plan for Order Details.

BoothTechEd

thomas murphy — Mon, 12 Jun 2006 13:49:59 GMT

BoothTechEd

Keynote Runthrough

thomas murphy — Mon, 12 Jun 2006 03:46:15 GMT

Keynote Runthrough

Keith Smith getting famliar with the keynote podium and the slap back echo.

SQL Editor

thomas murphy — Sat, 10 Jun 2006 06:16:48 GMT

SQL Editor

Just a quick shot of our SQL Editor, no we don't have intellisense. But we are beefing up the SQL edit experience, not the grids.

Unit Test Step 3

thomas murphy — Fri, 02 Jun 2006 07:43:04 GMT

Unit Test Step 3

Here you now see the Unit Test Designer. In the top pane you can see that it is just plain sql, and because we asked it to generate this test based on a specific SPROC, the code has already been built for us including any required arguments and the execution. In the lower portion of the screen is the assertion editor. You can choose assertions you want to test from the drop down list and then select the conditions you want to meet such as the number of rows returned by the query with a RowCount assertion. If you know C# or VB you can "drop behind" the designer experience and extend the tests with your chosen language.

Unit Testing Step 5

thomas murphy — Fri, 02 Jun 2006 07:59:26 GMT

Unit Testing Step 5

After running the test we can see in the test results view that it has passed so we now have a test for the positive case that we will use to affirm changes haven't broken this stored procedure.

Unit Testing Step 4

thomas murphy — Fri, 02 Jun 2006 07:53:54 GMT

Unit Testing Step 4

Once we have set up our test and the assertions, we can now run the test, here I have opened the Test View and by right clicking on the unit test I have just created, I can select run to run the test. All of the features of the Team System's unit testing capabilities can be utilized such as the Test Manager where we can build fixtures (or sets of unit tests) that can be run.

Unit Test Step 2

thomas murphy — Fri, 02 Jun 2006 07:36:02 GMT

Unit Test Step 2

In this dialog we are setting the database that we will test against and also setting up that before we test we will deploy the schema from our project as well as running the data in our generation plan.

Unit Testing Step 1

thomas murphy — Fri, 02 Jun 2006 07:32:31 GMT

Unit Testing Step 1

This dialog lets you set-up a unit test for one or more stored procedures. It will also create a new test project if required. Note that while it says we are creating a C# project that we are not going to force you to learn C# just to create tests for your TSQL code. As you will see in follow-on pictures, TSQL is all you need to know to make this rock.

Data Generation

thomas murphy — Fri, 02 Jun 2006 07:10:35 GMT

Data Generation

Data generation enables the creation of test data. When you create a data generation plan you can make use of a rich environment that understands how your existing database is put together. Data is generated by a set of plug-ins that are mapped to the native SQL data types. You can preview what the generated data will look like and choose alternative generators. In this picture you can see that for CompanyName I have chosen the regular expresion generator and written an expression that results in all companies names begining with AW- followed by 3 lower case leters and 5 numeric digits. Data is generated deterministically using a seed value so that you always have a stable set of test data for unit testing. You can also create you own data generators.

Project with files ready to add to version control

thomas murphy — Fri, 02 Jun 2006 06:58:42 GMT

Project with files ready to add to version control

After you create a project, you can "import" and existing database to turn it into something that can be managed and evolved off-line from the database. These files can be versioned just like any other project items can in Visual Studio. In this picture we can see that all these files would be new additions to source control. I can check them in by right clicking on the project and selecting the check-in item.

Gert Drapers

thomas murphy — Wed, 31 May 2006 22:41:41 GMT

Gert Drapers

Gert Drapers is the Architect and Development Manager for the Visual Studio Team Edition for Database Professionals product; which is providing tooling for database developers allowing them be part of the database development life cycle inside Visual Studio. Prior to his current position Gert was a member of the SQL Server development team where he held various positions contributing to SQL Server 7.0, 2000 and 2005. In between he designed the System.Transactions API which shipped as part of the .NET v2.0 frameworks.

matt nunn

thomas murphy — Wed, 31 May 2006 21:42:48 GMT

matt nunn

Matt is a Senior Product Manager on the Visual Studio Team System team. Matt is responsible for Technical Product Management of the new Database Professional edition in VSTS along with VSTS community efforts. Prior to joining the VSTS team, Matt spent 3.5 years working as a Senior Product Manager in the SQL Server team focused on all developer related initiatives for SQL Server. Before joining Microsoft, Matt worked as a technical consultant designing and building database systems with various consulting companies. Matt has numerous magazine articles and conference talks to his name including sessions at Tech Ed and PDC over the last 6 years and is currently the author of the database development column in SQL Server Magazine.

Create Project Dialog

thomas murphy — Wed, 31 May 2006 21:14:40 GMT

Create Project Dialog

This is the new project dialog allowing you to create database projects. We support SQL 2000 and 2005 projects. A project can be a full database project or a container for maintaining scripts. Note that you can place a project under version control (using any SCCI provider such as Team Foundation Server or Visual Source Safe).