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

    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

    Service Release 1 is HERE!

    • 11 Comments
    The team is very happy to announce that Visual Studio Team Edition for Database Professionals Service Release 1 is finally ready for consumption! It took us much longer then expected, but here it is. This is a single Service Release for all 9 languages...
  • 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...
  • 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

    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

    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

    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

    Diagnosing Problems (updated for the GDR)

    • 4 Comments
    NOTE: This article has been updated to apply to the latest Visual Studio 2008 Team System Database Edition GDR and GDR R2 releases. How to diagnose problems in the Visual Studio 2008 Team System Database Edition GDR (and GDR R2) release is the subject...
  • 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 2005 SP2

    • 2 Comments
    Service pack 2 for SQL Server 2005 is ready! For the users of Visual Studio Team Edition for Database Professional there are some important fixes in this service pack. The good news is that all fixes are related to the BatchParser which is a shared component...
  • 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

    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

    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

    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

    Power Tools Installation Problem (error code 2738)

    • 2 Comments
    Some users have been reporting problems installing the VSDB Power Tools on Vista or Windows Server 2008 (applies to both 32 and 64 bit versions). When they run the Power Tools installer they are confronted with the following mysterious error message:...
  • 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

    Apply Test-Driven Development to your Database Projects

    • 1 Comments
    This months issue of MSDN Magazine features a great article about how to use and extend Database Unit Testing written by Jamie Laflen who is the developer and tech lead in my team responsible for Database Unit Testing, Data Generation, SQL Code Coverage...
  • 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

    CTP 15 Is Here!

    • 10 Comments
    We just released a new CTP of the upcoming 2008 update, Microsoft® Visual Studio Team System 2008 Database Edition GDR July CTP is here! You can download it from MSDN: http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9...
  • Home of the Data Dude

    DesignDB Location

    • 2 Comments
    As you might know Visual Studio Team System Database Edition uses a local SQL Server database instance to validate the correctness of the code inside the database project. When you create a project a local scratch database is create for validation purposes...
  • Home of the Data Dude

    CTP7 is Live!

    • 11 Comments
    We are happy to announce that CTP7 is already here, no need to wait till next Monday, here it is! http://download.microsoft.com/download/3/1/9/319c5020-0fed-4dc1-b043-69567fda3941/TeamDataCTP7.exe CTP6 was only released 2 weeks ago, so what changed? We...
  • 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

    Visual Studio 2005 SP1

    • 2 Comments
    As you probably know by now " Microsoft® Visual Studio® 2005 Team Suite Service Pack 1 " is available for a while now. The question: In which order if any should you install Visual Studio 2005 SP1 in combination with Visual Studio Team Edition for Database...
  • Home of the Data Dude

    External Changes...

    • 3 Comments
    What happens when you make changes outside the scope of your project? What if you edit a file inside Notepad or sync your source code from your SCC system, either from the command line or from the VS IDE? Most users assume that the project automatically...
  • 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,...
Page 3 of 6 (141 items) 12345»