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

    FIX: Blank Unit Test Designer Problem

    • 2 Comments
    If you are running in to the following problem when creating unit tests when using database projects, there now is a fix! Consider the following scenario, you have you database project (.dbproj) open and requesting the creation of a Database Unit Test...
  • 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

    Must Read MSDN Magazine Article

    • 4 Comments
    Jamie Laflen and Barclay Hill wrote a great, must read article for MSDN Magazine, detailing the Visual Studio Team System 2008 Database Edition GDR functionality. Besides that it has a great intro describing the base principles of offline database schema...
  • Home of the Data Dude

    Oracle DSP Announced

    • 2 Comments
    Today Quest Software announced that they will offer a Database Schema Provider (DSP) for Oracle that plugs in to the Visual Studio Team System 2010 release. You can read the announcement at the Quest Software website: http://www.quest.com/newsroom/news...
  • Home of the Data Dude

    VSTSDB Blog Site

    • 1 Comments
    The Visual Studio Team System Database Edition team has created a new blog site to keep you informed and update about the latest developments. Please check out: http://blogs.msdn.com/vstsdb Thanks, -GertD
  • Home of the Data Dude

    DBProj.com

    • 2 Comments
    Some of you already know or noticed through sites like LinkedIn or Facebook that per the beginning of this month I started in a new role inside Microsoft. I moved in to an Software Architect role, working on the new Directory Services stack. Hence I needed...
  • Home of the Data Dude

    Data Generator for SQL Server Sparse Columns

    • 2 Comments
    Genevieve, tester on the “DataDude” team, has created a new Data Generator which allows you to populate a random set of sparse columns through the use of an XML column set column. She posted it on the VS Code Gallery, http://code.msdn.microsoft.com/columnsetgenerator...
  • Home of the Data Dude

    Final Language Release of the GDR

    • 2 Comments
    Today we released the last language, Russian, of the planned localized versions of Visual Studio Team System 2008 Database Edition GDR. This brings the total count to 10 (including English). You can download the Russian edition of the GDR from the following...
  • 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

    Two more languages released

    • 1 Comments
    Yesterday we released two more languages of the Visual Studio 2008 Team System Database Edition GDR release, Simplified Chinese and French in addition to the six languages we released on December 19th 2008. Chinese (Simplified) (zh-CN) http://download...
  • 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

    GDR VPC's

    • 2 Comments
    We just released a new set off VPC's for Visual Studio 2008 Team Suite (including TFS) which now have the Visual Studio 2008 Team System Database Edition GDR bits installed. These VPC's provide an easy way to test out the GDR release. There is a Virtual...
  • Home of the Data Dude

    Handling of COMMENTS in the GDR

    • 4 Comments
    In the GDR you will mainly find large improvements, but it is not everything is better. One area where we regressed functionality is the deployment of comments inside T-SQL procedures, triggers,  functions etc. With the move to a true and only model...
  • Home of the Data Dude

    GDR Language Releases

    • 2 Comments
    Today, we released 6 additional languages of the Visual Studio 2008 Team System Database Edition GDR! Chinese (Traditional, Taiwan) http://download.microsoft.com/download/1/9/D/19D1CB8C-82A8-4736-AFF4-51F2E343A312/Readme.mht http://download.microsoft...
  • Home of the Data Dude

    Troubleshooting SETUP

    • 1 Comments
    This post dives in to how to troubleshoot problems when installing the Visual Studio Team System 2008 Database Edition GDR .   Prerequisites Before installing the GDR, please check the prerequisites! Visual Studio Version & Edition: First check...
  • 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

    New VSDB Blog

    • 2 Comments
    Patrick Sirr , one of the key developers in our team started his own blog. If you want to learn about automating the project system using DTE, please check it out. His first three articles are covering: Importing multiple scripts using DTE Schema Compare...
  • Home of the Data Dude

    PDC Session Now Online

    • 3 Comments
    The PDC session "TL45 Microsoft Visual Studio Team System Database Edition: Overview", which I presented last Monday is now available for online viewing on Channel9. The video is stream can be found on: http://channel9.msdn.com/pdc2008/TL45...
  • 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

    Partial Projects

    • 14 Comments
    The Visual Studio Team System 2008 Database Edition GDR release introduces two new ways on how to share information between projects, partial projects and composite projects. This blog post will go in to how to use partial projects, composite projects...
  • Home of the Data Dude

    Model Collation vs. Database Collation

    • 3 Comments
    When you are using the latest CTP of the GDR release, you might have noticed that we introduced a new collation, named the "model collation". However if you go to the Database.sqlsettings file, which contains all the database properties, you...
  • Home of the Data Dude

    VSDB @ PDC2008

    • 2 Comments
    If you happen to go to PDC this year, you might want to check out session TL45, " Microsoft Visual Studio Team System Database Edition: Overview ". The title might not sounds that interesting but this session will be 100% dedicated to the Visual...
  • 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

    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

    Team Developer + Team Data = Team Developer!

    • 11 Comments
    In today's press release titled: " Visual Studio 2010 and .NET Framework 4.0 Overview " we announced the merge of the Developer Edition and Database Edition SKU's.   Better Together – Visual Studio Team System Development Edition...
Page 2 of 6 (141 items) 12345»