Home of the Data Dude

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

December, 2007

Blog - About

About the Data Dude



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,


  • Home of the Data Dude

    DesignDB Location

    As you might know Visual Studio Team System Database Edition uses a local SQL Server database instance to validate the correctness of the code inside the database project. When you create a project a local scratch database is create for validation purposes...
  • Home of the Data Dude

    Cleaning up DesignDB Leftovers

    In the " DesignDB Location " blog post I described where the design-time validation database are created. The attentive reader would have wondered when design-time validation database file get cleaned up, since we create them at project creation time...
  • Home of the Data Dude

    Is DesignDB In Use?

    When Visual Studio Team System Database Edition opens a design-time validation database, it acquires an exclusive application lock on the DesignDB database using the following code. 1: EXEC @rc = sp_getapplock N 'TSDATA' , N 'Exclusive' , N 'Session'...
Page 1 of 1 (3 items)