Visual Studio Team Edition for Database Professionals

I want to apologize for not posting some really great technical stuff lately but it's been a really busy summer here in Houston and I've been swamped with projects, Projects, PROJECTS! So I thought I'd give you a brief rundown on the new and (hopefully) exciting technologies I've been playing around with for the past few months, the projects I've been working on and a glimpse of things to come…

Visual Studio Team Edition for Database Professionals

Call it "DataDude", "TeamData", "VSTSDBP" or whatever. This new Visual Studio sku is real step in right direction for getting the database development part of your projects under control.

Oh yeah. I know. Your database development is already under control. Your developers already create the ALL the databases they need, and the tables, the indexes, the user defined functions, the stored procedures, etc. It's working just fine and you really don't need another "tool". Well, that's exactly what I thought till I started using this new Visual Studio sku. The first thing to understand about this new toolset is that it will dramatically change the way you look at database development and the database development lifecycle.

Most of my previous database development efforts were accomplished using the SQL Enterprise Manager, Query Analyzer and the SQL Management Studio (for SQL 2005). I used these tools to create my databases, tables, indexes, user defined functions, stored procedures, etc. running against a local instance of SQL Server. All of this was done "ad-hoc", without the benefit of source control, unit testing or any proper build procedure. If I forgot to backup my test database and changed something (such as a table name) which broke several functions and sprocs, it took hours and hours to find and fix. Not really a "robust" and "professional" way to develop the data store for an important application but given the tools available at the time, it was the best most of us could do!

Well, that's no longer the case and with Visual Studio Team Edition for Database Professionals, database development now becomes a fully supported part of your application's development lifecycle. Now all database development is done "off line" and in a "sandbox" environment (this should make your dba stand up and sing!). All user defined functions and stored procedures can be fully unit tested using representative test data automatically generated by the toolset. And best of all, this new Visual Studio sku fully integrates into Team Foundation Server so your database schema (SQL scripts) can be put under source control just like any other C#, BizTalk or Web Application!

I really recommend that ALL developers doing ANY database development at all, download the latest CTP of this new Visual Studio sku and take it for a spin. This is exactly the kind of extra value that may entice many of us to upgrade to Visual Studio Team Suite!

[tags: Visual Studio, Team Foundation Server]

This entry was posted in Visual Studio 2005. Bookmark the permalink. Follow any comments here with the RSS feed for this post.

One Response to Visual Studio Team Edition for Database Professionals

  1. Sonal says:

    I’ve just started to use TeamData to create unit tests for Stored Porcedures. Can anyone tell me where I can find information on how to dynamically change the parameters in my stored procedure unit tests. I need to try a variety of dates which will change according to the month we’re in. I can see anywhere how this is done!!! HELP

    DECLARE @RC INT,
    @NextBusinessDate DATETIME

    SELECT @RC = 0,
    @NextBusinessDate= ‘Variable date’ — This is what I need to state as a parameter

    EXEC @RC = [dbo].[GetNextBusinessDate] @NextBusinessDate OUTPUT

    SELECT RC=@RC,
    NextBusinessDate=@NextBusinessDate

Leave a Reply