Home of the Data Dude
Welcome to the blog where the DataDude talks about SQL Server Data Tools and Visual Studio Database Projects
REDIST
I got lots of questions based on my last post regarding the parser and script generator and the...
Author: Gert Drapers (MSFT) Date: 08/22/2008
Radio TFS covering the VSTSDB 2008 GDR
The hosts of Radio TFS, Martin Woodward, Mickey Gousset and Paul Hacker interviewed me on the what...
Author: Gert Drapers (MSFT) Date: 08/21/2008
Getting to the Crown Jewels
The crown jewels of the Database Edition product are the SQL parsers and script generator, these two...
Author: Gert Drapers (MSFT) Date: 08/21/2008
VSTSDB 2008 GDR CTP16 is here!
The team is happy to announce that we just released CTP16, of the Visual Studio Team System 2008...
Author: Gert Drapers (MSFT) Date: 08/20/2008
VSTSDB GDR CTP15 and VS2008 SP1 AND SQL Server 2008 RTM
I received enough questions asking if the VSTDB 2008 GDR CTP15 release is supported and working in...
Author: Gert Drapers (MSFT) Date: 08/20/2008
Trace Helper
This is the last part of the 3 part diagnostics series. This part will introduce you to a little...
Author: Gert Drapers (MSFT) Date: 08/17/2008
Event Monitor
In part 2 of diagnosing problems I want to introduce you to an other build-in diagnostics tools that...
Author: Gert Drapers (MSFT) Date: 08/17/2008
Diagnosing Problems (updated for the GDR)
NOTE: This article has been updated to apply to the latest Visual Studio 2008 Team System Database...
Author: Gert Drapers (MSFT) Date: 08/17/2008
CTP 15 Is Here!
We just released a new CTP of the upcoming 2008 update, Microsoft® Visual Studio Team System...
Author: Gert Drapers (MSFT) Date: 07/19/2008
Some recent VSDB Articles
Jeff Levinson recently wrote a great article in Visual Studio Magazine covering the upcoming GDR...
Author: Gert Drapers (MSFT) Date: 07/14/2008
Power Tools Installation Problem (error code 2738)
Some users have been reporting problems installing the VSDB Power Tools on Vista or Windows Server...
Author: Gert Drapers (MSFT) Date: 07/12/2008
PNWSQL Meeting July 9th
On Wednesday July 9th, I will be presenting for the Pacific Northwest SQL Server User Group. If you...
Author: Gert Drapers (MSFT) Date: 06/25/2008
Full day hands-on workshop @ Fall 2008 SQL Connections
This coming fall, we will be having a full day, hands-on workshop at SQL Connection in Las Vegas,...
Author: Gert Drapers (MSFT) Date: 06/08/2008
Tech*Ed Online - Visual Studio Team System Panel - Meet the Team
This panel discussion was recorded at Tech*Ed this week, it is a panel discussion about Visual...
Author: Gert Drapers (MSFT) Date: 06/07/2008
DataDude Goes Multi-Platform
Yesterday, during Bill Gates his Tech Ed keynote, Brian Harry had the honor to show the first...
Author: Gert Drapers (MSFT) Date: 06/04/2008
Channel 9 VSDB 2008 GDR Interview
We just released a new Channel 9 interview that covers the Visual Studio Team System 2008 Database...
Author: Gert Drapers (MSFT) Date: 06/03/2008
VSTS 2008 Database Edition GDR June CTP
Today, at Tech*Ed 2008 Developer, we announced the immediate availability of the first public CTP of...
Author: Gert Drapers (MSFT) Date: 06/03/2008
MSDB Reference Projects
The reference projects needed to resolve objects that reside inside an MSDB database have been...
Author: Gert Drapers (MSFT) Date: 04/30/2008
VSDB 2005 Service Release 1 Roll-up Package 1 (KB941278)
Visual Studio 2005 Team System Database Professional post Service Release 1 (SR1) roll-up package 1,...
Author: Gert Drapers (MSFT) Date: 03/11/2008
Command line SQL Static Code Analysis
We have had a lot of requests from users asking us to make T-SQL Static Code Analysis available at...
Author: Gert Drapers (MSFT) Date: 02/18/2008
Database Compatibility Level
VSTS-DB, both the 2005 and 2008 version, makes an assumption with regards to database compatibility...
Author: Gert Drapers (MSFT) Date: 02/17/2008
File Bound Generator
An other new addition to the Visual Studio Team System 2008 Database Edition - Power Tools release...
Author: Gert Drapers (MSFT) Date: 02/16/2008
Apply Test-Driven Development to your Database Projects
This months issue of MSDN Magazine features a great article about how to use and extend Database...
Author: Gert Drapers (MSFT) Date: 02/16/2008
Data Generation Wizard
One of the new features in the Visual Studio Team System 2008 Database Edition - Power Tools release...
Author: Gert Drapers (MSFT) Date: 02/15/2008
Visual Studio Team System 2008 Database Edition Power Tools
The “DataDude” team is happy to announce the availability of the Power Tools for Visual Studio Team...
Author: Gert Drapers (MSFT) Date: 02/15/2008
Lorem ipsum
This morning I received email from the owner of the DbProGenerators project on CodePlex announcing...
Author: Gert Drapers (MSFT) Date: 02/13/2008
Self Referencing
Lately we have been getting questions about self-referencing database calls. What I mean with that...
Author: Gert Drapers (MSFT) Date: 01/04/2008
Is DesignDB In Use?
When Visual Studio Team System Database Edition opens a design-time validation database, it acquires...
Author: Gert Drapers (MSFT) Date: 12/18/2007
Cleaning up DesignDB Leftovers
In the "DesignDB Location" blog post I described where the design-time validation database are...
Author: Gert Drapers (MSFT) Date: 12/18/2007
DesignDB Location
As you might know Visual Studio Team System Database Edition uses a local SQL Server database...
Author: Gert Drapers (MSFT) Date: 12/18/2007
Visual Studio Team System 2008 Database Edition
Now that Visual Studio 2008 is available, the question arises what has changed for Visual Studio...
Author: Gert Drapers (MSFT) Date: 11/21/2007
The Data Dude Meets Team Build
At DevConnections and TechEd Europe every attendee has been receiving a special issue of CoDe...
Author: Gert Drapers (MSFT) Date: 11/06/2007
External Changes...
What happens when you make changes outside the scope of your project? What if you edit a file inside...
Author: Gert Drapers (MSFT) Date: 10/18/2007
Data Bound Generator vs. Sequential Data Bound Generator
The Power Tools v1.0 release adds a new data generator, named the "Sequential Data Bound Generator"....
Author: Gert Drapers (MSFT) Date: 09/05/2007
SQL Connections 2007
Like every DevConnections conference for the last 6 years, I will be there presenting on a...
Author: Gert Drapers (MSFT) Date: 09/02/2007
Channel 9 video Covering Power Tools & Service Release 1 Functionality
Before I left for vacation, I did a quick video recording for Channel 9 together with Brian Keller...
Author: Gert Drapers (MSFT) Date: 08/17/2007
Power Tools Download Link
They are here! Dependency Viewer Refactoring Move Schema Expand Wildcard Fully Quality Name Refactor...
Author: Gert Drapers (MSFT) Date: 08/11/2007
SQL Pass Summit 2007
If you are planning on visiting 2007 PASS Community Summit in Denver this coming September, we have...
Author: Gert Drapers (MSFT) Date: 08/10/2007
What is in the Power Tools v1.0 release?
For those of you who have been paying close attention, you know that August 6th is the date I...
Author: Gert Drapers (MSFT) Date: 08/07/2007
Check it out: Team System Web Access Power Tool Available!
Yet an other great Power Tools from the Team System folks enabling Web Access to Team Foundation...
Author: Gert Drapers (MSFT) Date: 07/30/2007
Visual Studio Team System 2008 - Team Suite Beta 2
Visual Studio 2008 beta 2 is now available! The Visual Studio Team System 2008 - Team Suite now...
Author: Gert Drapers (MSFT) Date: 07/29/2007
CTP of SR1 to Expire on August 1st 2007
The public CTP of the VSDBPro Service Release...
Author: Gert Drapers (MSFT) Date: 07/27/2007
Database References
Service Release 1 for Visual Studio Team Edition for Database Professionals introduces the concept...
Author: Gert Drapers (MSFT) Date: 07/27/2007
VSDBPro Tech*Ed 2007 Sessions Available Online
The VSDBPro sessions that we presented at Tech*Ed 2007 this June are now available online. You can...
Author: Gert Drapers (MSFT) Date: 07/26/2007
Service Release 1 is HERE!
The team is very happy to announce that Visual Studio Team Edition for Database Professionals...
Author: Gert Drapers (MSFT) Date: 07/23/2007
Test-Driving Stored Procedures in SQL Server in VS2008
Cory Foy has written a great blog post about using Database Unit Testing in Visual Studio 2008...
Author: Gert Drapers (MSFT) Date: 07/20/2007
Table structure changes
I often receive questions about how we propagate changes to table structure in Visual Studio Team...
Author: Gert Drapers (MSFT) Date: 07/12/2007
Changing Database Ownership
In today's version it is not possible to model the ownership of the database you are deploying...
Author: Gert Drapers (MSFT) Date: 07/05/2007
Which 3rd party databases to support?
As you might know the team is working very hard on the next release of Visual Studio Team Edition...
Author: Gert Drapers (MSFT) Date: 07/03/2007