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

    Schema View for SQL Server Data Tools

    • 0 Comments
    Today the team released the first version of the SQL Server Data Tools – Power Tools, which adds the ability to navigate the schema of your project inside the SQL Server Object Explorer. Blog post detailing the release: http://blogs.msdn.com/b/ssdt/archive...
  • Home of the Data Dude

    SQL Connections Spring 2012

    • 0 Comments
    Next week, at the SQL Server Connections conference, I will be presenting “Database Development with SQL Server Data Tools”, a 60 minute overview how you can leverage SQL Server Data Tools (SSDT) for your daily database development and deployment tasks...
  • Home of the Data Dude

    SQL Server Data Tools Released, Available Today!

    • 0 Comments
    Today we released the first official release of the “SQL Server Data Tools” (SSDT) to the web. Even though this release accompanies SQL Server 2012 RTM, you can use SSDT against SQL Server 2005 or later, including SQL Azure. So download it now! and get...
  • Home of the Data Dude

    SQL Server Developers Tools code-named “Juneau” becomes SQL Server Data Tools (SSDT)

    • 0 Comments
    Last week at the SQL PASS SUMMIT 2011 in Seattle, Ted Kummert announced during his keynote that the final name of SQL Server Developers Tools code-named “Juneau” will be SQL Server Data Tools or SSDT for short. Additionally, the final name for SQL Server...
  • Home of the Data Dude

    VSDB Common Pitfalls 1

    • 0 Comments
    Symptom: The resulting database deployment script always creates the database This seems to be a common problem users are struggling with like illustrated by the following set of forum post . A user creates a database project, imports an existing database...
  • Home of the Data Dude

    Let’s pick up blogging again…

    • 0 Comments
    Sorry it has been really quiet on this blog for a while now, new job and new projects get in the way. However when going through the MSDN forum for Visual Studio Database Projects it seems there is a need for more hands-on examples and understanding about...
  • 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

    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 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

    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

    NESQL Presentation – Declarative Database Development

    • 0 Comments
    Last week, September 10, I was invited by the New England SQL Server User Group to present about my favorite topic “ Declarative Database Development ”. I posted the slides of the presentation at DBProj.com . GertD @ www.DBProj.com
  • Home of the Data Dude

    MyDevConnections Volume 2 issue 1

    • 0 Comments
    The DevConnections conference organization (Tech Conferences Inc.), just released the latest issue of the magazine accompanying the conferences, named: MyDevConnections . In this edition (volume 2, issue 1) you will find an article that I wrote about...
  • 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

    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

    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

    Agile Database Techniques

    • 3 Comments
    I am happy to announce that there is a new class dedicated to VSDB. “ Agile Database Techniques ”, is a 3-days course that provides students with the knowledge and skills to properly manage the SQL Server database development lifecycle in an agile environment...
  • 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

    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

    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

    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

    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

    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

    SQL Connections Slides and Demo Posted

    • 3 Comments
    It was great to be able to meet many new users of the Database Edition product at the SQL Connection Spring 2009 conference this week. Thank you for attending the sessions. There were lots of great questions, critical feedback and input for new features...
  • 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

    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...
Page 1 of 6 (141 items) 12345»