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

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

    Release Candidate of GDR QFE

    • 9 Comments
    Yesterday, March 25th, the development team released an RC of the upcoming QFE of the Visual Studio 2008 Team System Database Edition GDR bits. I was surprised to read the new naming “ Visual Studio 2008 Database Edition GDR v2 RC1 ”. Anyhow what is in...
  • Home of the Data Dude

    The GDR RC Is Here!

    • 9 Comments
    During my session at PDC I announce the immediate availability of the Release Candidate (RC) of Visual Studio Team System 2008 Database Edition GDR. We are going through the last stages of the development process and we are getting ready to release. This...
  • 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

    Which 3rd party databases to support?

    • 8 Comments
    As you might know the team is working very hard on the next release of Visual Studio Team Edition for Database Professionals, which is be part of upcoming the Visual Studio Team System " Rosario " release. One of the things we are doing in the Rosario...
  • 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

    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

    New Project Wizard

    • 7 Comments
    CTP5 also introduces the New Project Wizard, which makes it a lot easier to create your initial database project. All important decisions that you need to make when creating your database project are nicely represented in the wizard. Besides setting up...
  • Home of the Data Dude

    So close...

    • 7 Comments
    Today we made what is hopefully the last change for CTP5; one last code change (7 lines in 2 files), one setup fix and the build is running as I write this blog. If everything goes well, build 50727.145 will be CTP5 of "Visual Studio Team Edition for...
  • Home of the Data Dude

    VSDBPRO CTP6 GOES Live!

    • 7 Comments
    Wow, I am happy to announce that CTP6 of Visual Studio Team Edition for Database Professionals is available for download , right now! We took an extra week plus 1 day to get here, but I am sure it is worth the wait, this is an overview of the highlights...
  • 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

    More Team Developer + Data Edition Merge Information

    • 7 Comments
    Per October 1st 2008 MSDN subscribers who own or buy a new Visual Studio Team System Developer license are entitled to also install the Visual Studio Team System Database Edition, and  MSDN subscribers who own or buy a new Visual Studio Team System...
  • 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

    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

    Assigning MSBuild Properties to SQLCMD Variables

    • 7 Comments
    I am receiving the following question a lot: How do I propagate MSBuild properties to SQLCMD variables. In order to make the Visual Studio 2008 Team System Database Edition GDR release use the data from an MSBuild property inside a SQLCMD variable you...
  • Home of the Data Dude

    DBPROJ vs. DBP

    • 5 Comments
    Can the “real” database project please identify itself? Life can be confusing and we did not help you making it much easier by having two types of Database Projects inside Visual Studio. For the longest time there has been a “Database Project” inside...
  • Home of the Data Dude

    Dealing with Confused Installations

    • 5 Comments
      Is your Visual Studio Team System 2008 Database Edition GDR installation confused? Does your menu suffer from multiple instance disorder? Here is what you can do about it. Make sure that Visual Studio (devenv.exe) is closed. Start an elevated command...
  • Home of the Data Dude

    The Data Dude Meets Team Build

    • 5 Comments
    At DevConnections and TechEd Europe every attendee has been receiving a special issue of CoDe Magazine , featuring " Data Programmability ". In this issue you will find an article on how to get started with Team Build and VSDBPro, please check out http...
  • Home of the Data Dude

    Error and Warning Groups

    • 5 Comments
    One of the things we did at the end of the product cycle, when we decided that we need to allow you to filter out warnings, is to clean up all error and warning messages and concisely group them in to specific buckets. Understanding these buckets will...
  • Home of the Data Dude

    To Synchronize or To Refresh?

    • 5 Comments
    Are you confused too? Are you wondering what the difference is between the "Refresh" button in "Solution Explorer" and the "Synchronize" button in "Schema View"? Both buttons share the same icon; but they are named differently; are both option doing the...
  • Home of the Data Dude

    CTP3 Download

    • 5 Comments
    A quick update from TechEd. One day later then supposed to; you can now download the DataDude CTP3 bits http://download.microsoft.com/download/1/a/3/1a32ea84-11a3-4adf-953e-7a65b9831f5a/VSDATAD1.img You can install these bits on top of Visual Studio...
  • Home of the Data Dude

    Data Dude Comes to Live!

    • 4 Comments
    Welcome to the Data Dude blog. For those of you who know a little of my past; my life has been directly connected to SQL Server since 1988. After being a member of the SQL Server development team for many years; it was time for a new adventure,...
  • Home of the Data Dude

    How To Run as Normal User

    • 4 Comments
    Can you use Visual Studio Team Edition for Database Professionals running as a normal Windows user? Yes! You have to provision the Windows user with the appropriate rights and privileges on the local SQL Server instance that is used for design time validation...
  • 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

    Self Referencing

    • 4 Comments
    Lately we have been getting questions about self-referencing database calls. What I mean with that is that you are referencing SQL objects using a 3-part name while referencing objects that reside inside your current database context. For example: 1:...
Page 2 of 6 (141 items) 12345»