Home of the Data Dude

Finally the moment is there, the final version of the Visual Studio Team System 2008 Database Edition GDR has been released to the web. Although the name "GDR", which stands for "General Redistribution Release", implies otherwise,...

Now that Visual Studio 2008 is available, the question arises what has changed for Visual Studio Team Edition for Database Professionals in the 2008 edition? Not much is the answer. Since our first release was done completely out-of-band while other teams...

Yeah, it is for real! Today the product team has officially signed off on v1.0 of "Visual Studio Team Edition for Database Professionals". Build x251 is released to manufacturing (RTM). It was Euan Garden who started talking about the need for a product...

Service Release 1 for Visual Studio Team Edition for Database Professionals introduces the concept of "database references" which allows you to represent and resolve 3 and/or 4-part name usage inside a database project. Database references are conceptually...

The crown jewels of the Database Edition product are the SQL parsers and script generator, these two pieces form the foundation of what the database project system does internally. The parser, parses T-SQL code and turns it in to a script fragment, where...

Do you have a need to make parts of your build conditional or environment dependent? Variables are here to help you. The variable support inside Visual Studio Team Edition for Database Professionals is based on SQLCMD variables , see SQL Server Books...

For those of you who have been paying close attention, you know that August 6th is the date I promised the first Power Tools to be released. So where are they? We are not there yet, we released the first release candidate today, I need to finish two more...

VSTS-DB, both the 2005 and 2008 version, makes an assumption with regards to database compatibility levels, which can cause problems in certain use cases. The assumption is that the DesignDB instance used for validation of the schema inside the project...

Today, at Tech*Ed 2008 Developer, we announced the immediate availability of the first public CTP of the Visual Studio Team System 2008 Database Edition GDR. GDR stands for General Distribution Release. The GDR will be an out-of-band release enabling...

Define What You Want, Not How You Get There!   If Not Exists… Database development is many aspects behind in comparison to regular application development. If you look how database development is integrated with regular application development or...

One of the new features in the Visual Studio Team System 2008 Database Edition - Power Tools release is the addition of the Data Generation Wizard. The Data Generation Wizard is an item template wizard that allows you to create and configure a data generation...

One of the new features in the GDR release is that you can create your own T-SQL Static Code Analysis rules. This post will guide you through creating your first rule.   Step 1: Create a new Class Library project Inside Visual Studio 2008 create...

We have had a lot of requests from users asking us to make T-SQL Static Code Analysis available at build time and from the command line. The latest Visual Studio Team System 2008 Database Edition Power Tool release, adds this ability to the product through...

The “DataDude” team is happy to announce the availability of the Power Tools for Visual Studio Team System 2008 Database Edition. The Power Tools for 2008 contains all the functionality we shipped in 2005 plus: Command line SQL Static Code Analysis execution...

The Visual Studio Team System 2008 Database Edition GDR September CTP is now available for download. This is the last CTP, we started our final descend, we will publish a public RC (release candidate) when it is ready, followed by the RTM release. The...

The QFE rollup release for the Visual Studio Team System 2008 Database Edition GDR release is now available. You can download the SETUP.EXE from the regular location. ( http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed...

I got lots of questions based on my last post regarding the parser and script generator and the ability to redistribute the bits. If you own an official copy of Visual Studio Team System 2008 Database Edition GDR you are allowed to redistribute these...

The power of VSTE DBPro data generation, lays in the fact you can generate data that closely matches your domain values allowed in your environment. The problem is that knowledge of the allowed and disallowed domain values can not always be derived from...

One of the small, but hard to discover new features in the GDR release is the ability to suppress warnings at the file level. Just to be very clear, this is suppression of build level warnings, not of static code analysis or deployment warnings! Imagine...

I often receive questions about how we propagate changes to table structure in Visual Studio Team Edition for Database Professionals (VSDBPro)? When you allow users to make arbitrary schema changes, the problem is that they expect miracles to happen when...

We frequently get asked how to identify the version a user is running with, so here is the list of Visual Studio Team System 2008 Database Edition releases. The information is retrieved using Help => About Microsoft Visual Studio inside the Visual...

The UI provides support for pre and post build events (see the "Build Events" project property page), however some of you have been asking if it is possible to have steps invoked before or after the deployment step. This will show you how to do this....

The team is happy to announce that we just released CTP16, of the Visual Studio Team System 2008 Database Edition GDR release. We are yet another step closer to reaching the finish line which is waiting for us at PDC in Oct of this year. This release...

Pre-deployment script do not change the outcome of deployments! The above statements is something that most users do not realize when using pre-deployment scripts. Since the pre-deployment script is included in to the deployment script, it therefore by...

In today's version it is not possible to model the ownership of the database you are deploying towards. The ownership is determined based on the person who creates the initial database, SQL Server inherits the information from the security context of...