Home of the Data Dude

Welcome to the blog where the DataDude talks about SQL Server Data Tools and Visual Studio Database Projects

Schema View for SQL Server Data Tools

Today the team released the first version of the SQL Server Data Tools – Power Tools, which adds the...

Author: Gert Drapers (MSFT) Date: 04/02/2012

SQL Connections Spring 2012

Next week, at the SQL Server Connections conference, I will be presenting “Database Development with...

Author: Gert Drapers (MSFT) Date: 03/23/2012

SQL Server Data Tools Released, Available Today!

Today we released the first official release of the “SQL Server Data Tools” (SSDT) to the web. Even...

Author: Gert Drapers (MSFT) Date: 03/06/2012

SQL Server Developers Tools code-named “Juneau” becomes SQL Server Data Tools (SSDT)

Last week at the SQL PASS SUMMIT 2011 in Seattle, Ted Kummert announced during his keynote that the...

Author: Gert Drapers (MSFT) Date: 10/17/2011

VSDB Common Pitfalls 1

Symptom: The resulting database deployment script always creates the database This seems to be a...

Author: Gert Drapers (MSFT) Date: 12/18/2010

Let’s pick up blogging again…

Sorry it has been really quiet on this blog for a while now, new job and new projects get in the...

Author: Gert Drapers (MSFT) Date: 12/18/2010

DefaultDataPath

VSDB uses the the ($DefaultDataPath) SQLCMD variable to represent the location where you would place...

Author: Gert Drapers (MSFT) Date: 11/30/2009

SQL Server 2008 R2

Now that SQL Server 2008 R2 November CTP is available, I found some time to install it and test the...

Author: Gert Drapers (MSFT) Date: 11/24/2009

Pre and Post Deployment Events

Visual Studio makes it relatively easy to hook in to pre and post build events, by using the Project...

Author: Gert Drapers (MSFT) Date: 10/13/2009

Pre-Deployment Scripts

Pre-deployment script do not change the outcome of deployments! The above statements is something...

Author: Gert Drapers (MSFT) Date: 09/14/2009

NESQL Presentation – Declarative Database Development

Last week, September 10, I was invited by the New England SQL Server User Group to present about my...

Author: Gert Drapers (MSFT) Date: 09/14/2009

MyDevConnections Volume 2 issue 1

The DevConnections conference organization (Tech Conferences Inc.), just released the latest issue...

Author: Gert Drapers (MSFT) Date: 09/09/2009

SqlCmdVars.exe

This post announces the availability of a small helper utility that will allow you to maintain your...

Author: Gert Drapers (MSFT) Date: 08/01/2009

VSDB 2008 Version Numbers

We frequently get asked how to identify the version a user is running with, so here is the list of...

Author: Gert Drapers (MSFT) Date: 07/29/2009

VSDBCMD.EXE Return Codes

Quick one based on a forum question where somebody asked how to detect if VSDBCMD.EXE failed or...

Author: Gert Drapers (MSFT) Date: 07/21/2009

Agile Database Techniques

I am happy to announce that there is a new class dedicated to VSDB. “Agile Database Techniques”, is...

Author: Gert Drapers (MSFT) Date: 07/08/2009

Assigning MSBuild Properties to SQLCMD Variables

I am receiving the following question a lot: How do I propagate MSBuild properties to SQLCMD...

Author: Gert Drapers (MSFT) Date: 06/21/2009

DBSchema file for SQL LiteSpeed XP’s

Based on a customer request I created a .dbschema file which contains the definitions of all the...

Author: Gert Drapers (MSFT) Date: 06/10/2009

System Objects in TEMPDB

Today a user send me a question how to resolve reference of system objects inside tempdb? My first...

Author: Gert Drapers (MSFT) Date: 06/10/2009

Declarative Database Development

Define What You Want, Not How You Get There!   If Not Exists… Database development is many...

Author: Gert Drapers (MSFT) Date: 06/05/2009

RTM of VSDB 2008 GDR R2

The QFE rollup release for the Visual Studio Team System 2008 Database Edition GDR release is now...

Author: Gert Drapers (MSFT) Date: 04/22/2009

Release Candidate of GDR QFE

Yesterday, March 25th, the development team released an RC of the upcoming QFE of the Visual Studio...

Author: Gert Drapers (MSFT) Date: 03/26/2009

SQL Connections Slides and Demo Posted

It was great to be able to meet many new users of the Database Edition product at the SQL Connection...

Author: Gert Drapers (MSFT) Date: 03/26/2009

DBPROJ vs. DBP

Can the “real” database project please identify itself? Life can be confusing and we did not help...

Author: Gert Drapers (MSFT) Date: 03/25/2009

Up to SQL Connections Spring 2009 (Orlando, FL)

Next week I will be presenting at SQL Connections in Orlando where I will be covering some fun...

Author: Gert Drapers (MSFT) Date: 03/20/2009

FIX: Blank Unit Test Designer Problem

If you are running in to the following problem when creating unit tests when using database...

Author: Gert Drapers (MSFT) Date: 03/11/2009

Dealing with Confused Installations

  Is your Visual Studio Team System 2008 Database Edition GDR installation confused? Does your...

Author: Gert Drapers (MSFT) Date: 03/08/2009

Must Read MSDN Magazine Article

Jamie Laflen and Barclay Hill wrote a great, must read article for MSDN Magazine, detailing the...

Author: Gert Drapers (MSFT) Date: 02/25/2009

Oracle DSP Announced

Today Quest Software announced that they will offer a Database Schema Provider (DSP) for Oracle that...

Author: Gert Drapers (MSFT) Date: 02/24/2009

VSTSDB Blog Site

The Visual Studio Team System Database Edition team has created a new blog site to keep you informed...

Author: Gert Drapers (MSFT) Date: 02/24/2009

DBProj.com

Some of you already know or noticed through sites like LinkedIn or Facebook that per the beginning...

Author: Gert Drapers (MSFT) Date: 02/19/2009

Data Generator for SQL Server Sparse Columns

Genevieve, tester on the “DataDude” team, has created a new Data Generator which allows you to...

Author: Gert Drapers (MSFT) Date: 02/06/2009

Final Language Release of the GDR

Today we released the last language, Russian, of the planned localized versions of Visual Studio...

Author: Gert Drapers (MSFT) Date: 01/20/2009

File Level Build Warning Suppression in the GDR

One of the small, but hard to discover new features in the GDR release is the ability to suppress...

Author: Gert Drapers (MSFT) Date: 01/11/2009

Two more languages released

Yesterday we released two more languages of the Visual Studio 2008 Team System Database Edition GDR...

Author: Gert Drapers (MSFT) Date: 01/09/2009

Creating T-SQL Static Code Analysis Rules

One of the new features in the GDR release is that you can create your own T-SQL Static Code...

Author: Gert Drapers (MSFT) Date: 01/01/2009

GDR VPC's

We just released a new set off VPC's for Visual Studio 2008 Team Suite (including TFS) which now...

Author: Gert Drapers (MSFT) Date: 12/24/2008

Handling of COMMENTS in the GDR

In the GDR you will mainly find large improvements, but it is not everything is better. One area...

Author: Gert Drapers (MSFT) Date: 12/19/2008

GDR Language Releases

Today, we released 6 additional languages of the Visual Studio 2008 Team System Database Edition...

Author: Gert Drapers (MSFT) Date: 12/19/2008

Troubleshooting SETUP

This post dives in to how to troubleshoot problems when installing the Visual Studio Team System...

Author: Gert Drapers (MSFT) Date: 12/16/2008

Visual Studio Team System 2008 Database Edition GDR - RTM

Finally the moment is there, the final version of the Visual Studio Team System 2008 Database...

Author: Gert Drapers (MSFT) Date: 11/25/2008

New VSDB Blog

Patrick Sirr, one of the key developers in our team started his own blog. If you want to learn about...

Author: Gert Drapers (MSFT) Date: 11/22/2008

PDC Session Now Online

The PDC session "TL45 Microsoft Visual Studio Team System Database Edition: Overview",...

Author: Gert Drapers (MSFT) Date: 10/29/2008

The GDR RC Is Here!

During my session at PDC I announce the immediate availability of the Release Candidate (RC) of...

Author: Gert Drapers (MSFT) Date: 10/27/2008

Partial Projects

The Visual Studio Team System 2008 Database Edition GDR release introduces two new ways on how to...

Author: Gert Drapers (MSFT) Date: 10/05/2008

Model Collation vs. Database Collation

When you are using the latest CTP of the GDR release, you might have noticed that we introduced a...

Author: Gert Drapers (MSFT) Date: 10/04/2008

VSDB @ PDC2008

If you happen to go to PDC this year, you might want to check out session TL45, "Microsoft...

Author: Gert Drapers (MSFT) Date: 10/03/2008

More Team Developer + Data Edition Merge Information

Per October 1st 2008 MSDN subscribers who own or buy a new Visual Studio Team System Developer...

Author: Gert Drapers (MSFT) Date: 10/03/2008

Visual Studio Team System 2008 Database Edition GDR September CTP

The Visual Studio Team System 2008 Database Edition GDR September CTP is now available for download....

Author: Gert Drapers (MSFT) Date: 10/01/2008

Team Developer + Team Data = Team Developer!

In today's press release titled: "Visual Studio 2010 and .NET Framework 4.0 Overview" we...

Author: Gert Drapers (MSFT) Date: 09/29/2008

Next>