Home of the Data Dude

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

Blog - About

About the Data Dude

Hello,

 

My name is Gert Drapers, I am a Software Architect in the Windows Server Directory Services team, working on incubation projects. Before my current role I was the Lead Software Architect and Engineering Manager of the Visual Studio Team System Database Edition product, where I designed and developed the declarative database development tooling which is now shipping inside Visual Studio. Since 1991, I contributed to many parts and releases of Microsoft SQL Server and on the Transaction Management infrastructure (MS-DTC, WS-AtomicTransaction and System.Transactions).

 

When I am not working, I am spending time with my wife and three lovely daughters; I love to cook and make music. Besides that I am trying to serve the SQL Server community by writing tools and articles which are published on http://SQLDev.Net

 

I hope you enjoy the blog,

-GertD

  • Home of the Data Dude

    REDIST

    • 7 Comments
    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...
  • Home of the Data Dude

    Radio TFS covering the VSTSDB 2008 GDR

    • 3 Comments
    The hosts of Radio TFS, Martin Woodward , Mickey Gousset and Paul Hacker interviewed me on the what is new and changed in the Visual Studio Team System 2008 Database Edition GDR CTP16 release. Since there are so many new things in the GDR we ran out of...
  • Home of the Data Dude

    Getting to the Crown Jewels

    • 13 Comments
    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...
  • Home of the Data Dude

    VSTSDB 2008 GDR CTP16 is here!

    • 13 Comments
    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...
  • Home of the Data Dude

    VSTSDB GDR CTP15 and VS2008 SP1 AND SQL Server 2008 RTM

    • 2 Comments
    I received enough questions asking if the VSTDB 2008 GDR CTP15 release is supported and working in combination with the released versions Visual Studio 2008 SP1 and SQL Server 2008? And if so what the correct order of installation is? GDR CTP15 is working...
  • Home of the Data Dude

    Trace Helper

    • 1 Comments
    This is the last part of the 3 part diagnostics series. This part will introduce you to a little helper utility that I wrote to make configuring the diagnostics and tracing options a lot simpler and more accessible. As discussed in the previous two blog...
  • Home of the Data Dude

    Event Monitor

    • 2 Comments
    In part 2 of diagnosing problems I want to introduce you to an other build-in diagnostics tools that we might ask you to run with tracking down problems, the "event monitor". The event monitor is one of those tools that we use during development...
  • Home of the Data Dude

    Diagnosing Problems (updated for the GDR)

    • 4 Comments
    NOTE: This article has been updated to apply to the latest Visual Studio 2008 Team System Database Edition GDR and GDR R2 releases. How to diagnose problems in the Visual Studio 2008 Team System Database Edition GDR (and GDR R2) release is the subject...
  • Home of the Data Dude

    CTP 15 Is Here!

    • 10 Comments
    We just released a new CTP of the upcoming 2008 update, Microsoft® Visual Studio Team System 2008 Database Edition GDR July CTP is here! You can download it from MSDN: http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9...
  • Home of the Data Dude

    Some recent VSDB Articles

    • 2 Comments
    Jeff Levinson recently wrote a great article in Visual Studio Magazine covering the upcoming GDR release: Introducing the VSTS Database Edition GDR and Jeffrey Juday just published an article on Developer.com about Database Unit Testing: Introducing Visual...
  • Home of the Data Dude

    Power Tools Installation Problem (error code 2738)

    • 2 Comments
    Some users have been reporting problems installing the VSDB Power Tools on Vista or Windows Server 2008 (applies to both 32 and 64 bit versions). When they run the Power Tools installer they are confronted with the following mysterious error message:...
  • Home of the Data Dude

    PNWSQL Meeting July 9th

    • 1 Comments
    On Wednesday July 9th, I will be presenting for the Pacific Northwest SQL Server User Group. If you are in the neighborhood, feel free to join us. The meeting will be held at the Microsoft Campus, building 35. The topic du jour will be about what is in...
  • Home of the Data Dude

    Full day hands-on workshop @ Fall 2008 SQL Connections

    • 0 Comments
    This coming fall, we will be having a full day, hands-on workshop at SQL Connection in Las Vegas, covering the upcoming Visual Studio Team Edition 2008 Database Edition GDR release. The goal of the workshop is to get you acquainted with the new functionality...
  • Home of the Data Dude

    Tech*Ed Online - Visual Studio Team System Panel - Meet the Team

    • 1 Comments
    This panel discussion was recorded at Tech*Ed this week, it is a panel discussion about Visual Studio Team System at large. Participants Brian Harry (Technical Fellow of Team Foundation Server), Neelesh Kamkolkar (Senior Product Manager VSTS Test Edition...
  • Home of the Data Dude

    DataDude Goes Multi-Platform

    • 8 Comments
    Yesterday, during Bill Gates his Tech Ed keynote , Brian Harry had the honor to show the first glimpse of the results of our partnership with IBM, DB2 support inside Visual Studio Team System Database Edition. As you might know or have read in one of...
  • Home of the Data Dude

    Channel 9 VSDB 2008 GDR Interview

    • 1 Comments
    We just released a new Channel 9 interview that covers the Visual Studio Team System 2008 Database Edition GDR functionality that we introduced today. http://channel9.msdn.com/posts/briankel/New-GDR-Announced-for-Visual-Studio-Team-System-2008-Database...
  • Home of the Data Dude

    VSTS 2008 Database Edition GDR June CTP

    • 22 Comments
    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...
  • Home of the Data Dude

    Tech·Ed 2008 Developers

    • 1 Comments
    In case you are coming to the Developer edition of Tech·Ed next week, we have a lot of exiting things for you. As you can see below there are many sessions, hosted in both the developer and database tracks. Breakout sessions, chalk talks, panel discussions...
  • Home of the Data Dude

    MSDB Reference Projects

    • 1 Comments
    The reference projects needed to resolve objects that reside inside an MSDB database have been posted on the MSDN Code Gallery site. You can find them on: http://code.msdn.microsoft.com/dbpromsdbsamples We did not post .dbmeta files but stub projects...
  • Home of the Data Dude

    VSDB 2005 Service Release 1 Roll-up Package 1 (KB941278)

    • 2 Comments
    Visual Studio 2005 Team System Database Professional post Service Release 1 (SR1) roll-up package 1, is now available. For a list of issues that are fixed, please see knowledge base article KB941278 . You can download the roll-up from the Microsoft Connect...
  • Home of the Data Dude

    Command line SQL Static Code Analysis

    • 7 Comments
    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...
  • Home of the Data Dude

    Database Compatibility Level

    • 3 Comments
    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...
  • Home of the Data Dude

    File Bound Generator

    • 4 Comments
    An other new addition to the Visual Studio Team System 2008 Database Edition - Power Tools release is the File Bound Generator. This data generator grovels through files inside a directory or optionally through its subdirectories, based on some search...
  • Home of the Data Dude

    Apply Test-Driven Development to your Database Projects

    • 1 Comments
    This months issue of MSDN Magazine features a great article about how to use and extend Database Unit Testing written by Jamie Laflen who is the developer and tech lead in my team responsible for Database Unit Testing, Data Generation, SQL Code Coverage...
  • Home of the Data Dude

    Data Generation Wizard

    • 12 Comments
    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...
Page 3 of 6 (141 items) 12345»