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

    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

    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

    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

    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

    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

    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

    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

    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

    VSDBCMD.EXE Return Codes

    • 2 Comments
    Quick one based on a forum question where somebody asked how to detect if VSDBCMD.EXE failed or succeeded inside a batch file. VSDBCMD.EXE does not return a very elaborate amount of information, there are just two return values 0 and 1, where zero indicates...
  • Home of the Data Dude

    DBSchema file for SQL LiteSpeed XP’s

    • 2 Comments
    Based on a customer request I created a .dbschema file which contains the definitions of all the extended stored procedures used by SQL LiteSpeed 5.0 that live inside the master database. Since schema import does not import the definition of extended...
  • 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

    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

    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

    SQL Server 2008 R2

    • 2 Comments
    Now that SQL Server 2008 R2 November CTP is available, I found some time to install it and test the existing Visual Studio 2008 Team System Database Edition GDR R2 release with it. The only thing that is really different from a SQL Server point of view...
  • 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

    Pre and Post Deployment Events

    • 1 Comments
    Visual Studio makes it relatively easy to hook in to pre and post build events, by using the Project properties tab named Build Events. However when using Database Projects (.dbproj) you more often need to do something at deployment time. The good news...
  • Home of the Data Dude

    SqlCmdVars.exe

    • 1 Comments
    This post announces the availability of a small helper utility that will allow you to maintain your database.sqlcmdvars files from a command line tool. Description: What is the scenario? If you are using vsdbcmd.exe to deploy your schema, you include...
  • Home of the Data Dude

    DefaultDataPath

    • 1 Comments
    VSDB uses the the ($DefaultDataPath) SQLCMD variable to represent the location where you would place your data and log file of your database. The deployment engine sets the value of SQLCMD variable by querying SQL Server using the following query: 1:...
  • Home of the Data Dude

    Up to SQL Connections Spring 2009 (Orlando, FL)

    • 1 Comments
    Next week I will be presenting at SQL Connections in Orlando where I will be covering some fun topics on DataDude and general SQL Server. Here is the list. SQL Connections Spring 2009 (Orlando, FL) SDB413: Automating Database Deployment Do you have a...
  • 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

    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

    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

    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

    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

    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...
Page 4 of 6 (141 items) «23456