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

    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

    VSTSDB 2008 GDR CTP16 is here!

    • 13 Comments
    The team is happy to announce that we just released CTP16, of the Visual Studio Team System 2008 Database Edition GDR release. We are yet another step closer to reaching the finish line which is waiting for us at PDC in Oct of this year. This release...
  • 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

    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

    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

    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

    Power Tools Download Link

    • 11 Comments
    They are here! Dependency Viewer Refactoring Move Schema Expand Wildcard Fully Quality Name Refactor in to strongly typed DataSet definitions Refactor Command Generator Data Generation Sequential Data Bound Generator Editors for the Data Bound Generator...
  • 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

    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

    Importing SQL Scripts in to the Database Project

    • 9 Comments
    One of the new things you will find in CTP5, is the Import Script Wizard. This wizard allows you to select a existing .SQL script file and import the DDL statement in to the database project as schema objects. First you select an existing SQL script file...
  • 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

    Public CTP of VSDBPro Service Release 1 is NOW available (KB936202)

    • 11 Comments
    Or should I say is finally available. Anyhow here it is; the public first and last public CTP of the Visual Studio Team Edition for Database Professionals first Service Release. What is in it? 3+4 part name resolution through a new feature called "database...
  • 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:...
  • Home of the Data Dude

    Idempotent Scripts Required

    • 1 Comments
    Idempotent, as a former transaction guy I love this word and believe you are not alone if you are not clear on the meaning or impact of this word. Wikipedia is there to help. Idempotent: In computing , idempotence ( IPA /ˈaɪdɛmˌpotn̩s/, like eye-DEM-potence...
  • 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

    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

    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

    RTM Download Available on MSDN (updated Jan 8th 2007)

    • 13 Comments
    The Visual Studio Team Edition for Database Professionals RTM bits are available for download! MSDN subscribers can find the bits by looking at their available subscription downloads. MSDN provides the full image download of the standalone SKU which is...
  • 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

    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

    Data Bound Generator vs. Sequential Data Bound Generator

    • 3 Comments
    The Power Tools v1.0 release adds a new data generator, named the "Sequential Data Bound Generator". Since there already exists a data generator named the "Data Bound Generator" this yields the question what the difference is between the two is and when...
  • Home of the Data Dude

    Announcing Service Release 1

    • 10 Comments
    Customer Driven I am happy to announce that first Service Release of Visual Studio 2005 Team Edition for Database Professionals is in the works and will be available in the second quarter of CY 2007 . In this service release we are addressing issues that...
  • 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

    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

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