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

    Visual Studio Team System 2008 Database Edition GDR - RTM

    • 43 Comments
    Finally the moment is there, the final version of the Visual Studio Team System 2008 Database Edition GDR has been released to the web. Although the name "GDR", which stands for "General Redistribution Release", implies otherwise,...
  • Home of the Data Dude

    Visual Studio Team System 2008 Database Edition

    • 17 Comments
    Now that Visual Studio 2008 is available, the question arises what has changed for Visual Studio Team Edition for Database Professionals in the 2008 edition? Not much is the answer. Since our first release was done completely out-of-band while other teams...
  • Home of the Data Dude

    v1.0 RTM

    • 16 Comments
    Yeah, it is for real! Today the product team has officially signed off on v1.0 of "Visual Studio Team Edition for Database Professionals". Build x251 is released to manufacturing (RTM). It was Euan Garden who started talking about the need for a product...
  • Home of the Data Dude

    Database References

    • 8 Comments
    Service Release 1 for Visual Studio Team Edition for Database Professionals introduces the concept of "database references" which allows you to represent and resolve 3 and/or 4-part name usage inside a database project. Database references are conceptually...
  • 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

    Variables to the rescue

    • 9 Comments
    Do you have a need to make parts of your build conditional or environment dependent? Variables are here to help you. The variable support inside Visual Studio Team Edition for Database Professionals is based on SQLCMD variables , see SQL Server Books...
  • 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

    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

    What is in the Power Tools v1.0 release?

    • 29 Comments
    For those of you who have been paying close attention, you know that August 6th is the date I promised the first Power Tools to be released. So where are they? We are not there yet, we released the first release candidate today, I need to finish two more...
  • Home of the Data Dude

    Declarative Database Development

    • 10 Comments
    Define What You Want, Not How You Get There!   If Not Exists… Database development is many aspects behind in comparison to regular application development. If you look how database development is integrated with regular application development or...
  • Home of the Data Dude

    Creating T-SQL Static Code Analysis Rules

    • 11 Comments
    One of the new features in the GDR release is that you can create your own T-SQL Static Code Analysis rules. This post will guide you through creating your first rule.   Step 1: Create a new Class Library project Inside Visual Studio 2008 create...
  • 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...
  • 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

    Visual Studio Team System 2008 Database Edition Power Tools

    • 13 Comments
    The “DataDude” team is happy to announce the availability of the Power Tools for Visual Studio Team System 2008 Database Edition. The Power Tools for 2008 contains all the functionality we shipped in 2005 plus: Command line SQL Static Code Analysis execution...
  • Home of the Data Dude

    Pre and Post Deployment Events

    • 2 Comments
    The UI provides support for pre and post build events (see the "Build Events" project property page), however some of you have been asking if it is possible to have steps invoked before or after the deployment step. This will show you how to do this....
  • 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

    VSDB 2008 Version Numbers

    • 0 Comments
    We frequently get asked how to identify the version a user is running with, so here is the list of Visual Studio Team System 2008 Database Edition releases. The information is retrieved using Help => About Microsoft Visual Studio inside the Visual...
  • Home of the Data Dude

    Visual Studio Team System 2008 Database Edition GDR September CTP

    • 15 Comments
    The Visual Studio Team System 2008 Database Edition GDR September CTP is now available for download. This is the last CTP, we started our final descend, we will publish a public RC (release candidate) when it is ready, followed by the RTM release. The...
  • Home of the Data Dude

    RTM of VSDB 2008 GDR R2

    • 10 Comments
    The QFE rollup release for the Visual Studio Team System 2008 Database Edition GDR release is now available. You can download the SETUP.EXE from the regular location. ( http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed...
  • Home of the Data Dude

    File Level Build Warning Suppression in the GDR

    • 7 Comments
    One of the small, but hard to discover new features in the GDR release is the ability to suppress warnings at the file level. Just to be very clear, this is suppression of build level warnings, not of static code analysis or deployment warnings! Imagine...
  • Home of the Data Dude

    Pre-Deployment Scripts

    • 2 Comments
    Pre-deployment script do not change the outcome of deployments! The above statements is something that most users do not realize when using pre-deployment scripts. Since the pre-deployment script is included in to the deployment script, it therefore by...
  • Home of the Data Dude

    Changing Database Ownership

    • 1 Comments
    In today's version it is not possible to model the ownership of the database you are deploying towards. The ownership is determined based on the person who creates the initial database, SQL Server inherits the information from the security context of...
  • Home of the Data Dude

    RegEx Is Your Friend

    • 7 Comments
    The power of VSTE DBPro data generation, lays in the fact you can generate data that closely matches your domain values allowed in your environment. The problem is that knowledge of the allowed and disallowed domain values can not always be derived from...
  • Home of the Data Dude

    System Objects in TEMPDB

    • 10 Comments
    Today a user send me a question how to resolve reference of system objects inside tempdb? My first thought was this should get resolved by loading the master.dbschema file. However this did not resolve the issue, so time to ask for an example, which slightly...
  • Home of the Data Dude

    Table structure changes

    • 9 Comments
    I often receive questions about how we propagate changes to table structure in Visual Studio Team Edition for Database Professionals (VSDBPro)? When you allow users to make arbitrary schema changes, the problem is that they expect miracles to happen when...
Page 1 of 6 (141 items) 12345»