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...
Date: 04/02/2012
SQL Connections Spring 2012
Next week, at the SQL Server Connections conference, I will be presenting “Database Development with...
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...
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...
Date: 10/17/2011
VSDB Common Pitfalls 1
Symptom: The resulting database deployment script always creates the database This seems to be a...
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...
Date: 12/18/2010
DefaultDataPath
VSDB uses the the ($DefaultDataPath) SQLCMD variable to represent the location where you would place...
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...
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...
Date: 10/13/2009
Pre-Deployment Scripts
Pre-deployment script do not change the outcome of deployments! The above statements is something...
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...
Date: 09/14/2009
MyDevConnections Volume 2 issue 1
The DevConnections conference organization (Tech Conferences Inc.), just released the latest issue...
Date: 09/09/2009
SqlCmdVars.exe
This post announces the availability of a small helper utility that will allow you to maintain your...
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...
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...
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...
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...
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...
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...
Date: 06/10/2009
Declarative Database Development
Define What You Want, Not How You Get There! If Not Exists… Database development is many...
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...
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...
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...
Date: 03/26/2009
DBPROJ vs. DBP
Can the “real” database project please identify itself? Life can be confusing and we did not help...
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...
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...
Date: 03/11/2009
Dealing with Confused Installations
Is your Visual Studio Team System 2008 Database Edition GDR installation confused? Does your...
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...
Date: 02/25/2009
Oracle DSP Announced
Today Quest Software announced that they will offer a Database Schema Provider (DSP) for Oracle that...
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...
Date: 02/24/2009
DBProj.com
Some of you already know or noticed through sites like LinkedIn or Facebook that per the beginning...
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...
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...
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...
Date: 01/11/2009
Two more languages released
Yesterday we released two more languages of the Visual Studio 2008 Team System Database Edition GDR...
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...
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...
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...
Date: 12/19/2008
GDR Language Releases
Today, we released 6 additional languages of the Visual Studio 2008 Team System Database Edition...
Date: 12/19/2008
Troubleshooting SETUP
This post dives in to how to troubleshoot problems when installing the Visual Studio Team System...
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...
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...
Date: 11/22/2008
PDC Session Now Online
The PDC session "TL45 Microsoft Visual Studio Team System Database Edition: Overview",...
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...
Date: 10/27/2008
Partial Projects
The Visual Studio Team System 2008 Database Edition GDR release introduces two new ways on how to...
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...
Date: 10/04/2008
VSDB @ PDC2008
If you happen to go to PDC this year, you might want to check out session TL45, "Microsoft...
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...
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....
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...
Date: 09/29/2008