Home of the Data Dude

In the " DesignDB Location " blog post I described where the design-time validation database are created. The attentive reader would have wondered when design-time validation database file get cleaned up, since we create them at project creation time...

When Visual Studio Team System Database Edition opens a design-time validation database, it acquires an exclusive application lock on the DesignDB database using the following code. 1: EXEC @rc = sp_getapplock N 'TSDATA' , N 'Exclusive' , N 'Session'...

This morning I received email from the owner of the DbProGenerators project on CodePlex announcing the availability of the LoremTextGenerator, which is a data generator that creates Lorem ipsum texts. Please check out the CodePlex project site at http...

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

The reference projects needed to resolve objects that reside inside an MSDB database have been posted on the MSDN Code Gallery site. You can find them on: http://code.msdn.microsoft.com/dbpromsdbsamples We did not post .dbmeta files but stub projects...

In case you are coming to the Developer edition of Tech·Ed next week, we have a lot of exiting things for you. As you can see below there are many sessions, hosted in both the developer and database tracks. Breakout sessions, chalk talks, panel discussions...

We just released a new Channel 9 interview that covers the Visual Studio Team System 2008 Database Edition GDR functionality that we introduced today. http://channel9.msdn.com/posts/briankel/New-GDR-Announced-for-Visual-Studio-Team-System-2008-Database...

Visual Studio 2008 beta 2 is now available! The Visual Studio Team System 2008 - Team Suite now includes Visual Studio Team Edition for Database Professionals. The 2008 version is based on the Service Release 1 bits of VSDBPro. The only two additional...

In today's version it is not possible to model the ownership of the database you are deploying towards. The ownership is determined based on the person who creates the initial database, SQL Server inherits the information from the security context of...

If you are planning on visiting 2007 PASS Community Summit in Denver this coming September, we have two sessions that might interest you. We start off with a full day pre-conference day dedicated to VSDBPro, followed by a break-out session on schema versioning...

Before I left for vacation, I did a quick video recording for Channel 9 together with Brian Keller showing off the new functionality in the Visual Studio Team Edition for Database Professionals Power Tools and Service Release 1. You can find the video...

Like every DevConnections conference for the last 6 years, I will be there presenting on a combination of SQL Server and Visual Studio for Database Professionals topics. On November 5th I will be hosting a full day workshop on DataDude (aka Visual Studio...

In case you are wondering, we will be there! Not only are we presenting sessions, we are in the hand-on labs area and doing chalk talks and we are at the booth ready to answer your questions. At the booth we are also showing Service Release 1 and the...

The February 2007 edition of MSDN Magazine, contains a great article, named " Data Joins The Team " written by Brian A. Randell on VSDBPro, check it out! -GertD

Yesterday, on March 21, it was announced at SD West in Santa Clara (CA) that "Visual Studio Team Edition for Database Professionals" has won the Jolt 2007 Award in the "Database Engines and Data Tools" category. As a team we are very proud and truly appreciate...

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

Today we published the a new white paper titled: " A Security Overview of Microsoft Visual Studio 2005 Team Edition for Database Professionals " written by Richard Waymire . In case you missed the first one from Tony Loton " What Microsoft Visual Studio...

You might want to check out Brian Randell his article in MSDN Magazine this month, titled "Data Joins The Team - Introducing Visual Studio 2005 Team Edition for Database Professionals". It will provide you with a great overview of our tool and some of...

Today more then one person asked me about the version numbers of the publicly distributed versions of Visual Studio Team Edition for Database Professionals; so here we go, this is the complete version list. 2.0.50727.354 Service Release 1 2.0.50727.251...

Yes, it has been crazy since our announcement on May 31st. But the cool things is, today we signed off on CTP3, so it is on its way to you and will be available for download very soon, or if you are at TechEd, stop by and pickup your own CD. -GertD

So I did it, my first Podcast! I am actually too scared to listen to myself, but if you want to learn more about the product or who I am (preferably in that order); please check out Greg Low his SQL Server dedicated Podcasts and website at http://www...

Based on your feedback and continuous confusion about what to download or install we created an additional installer for those who currently have Visual Studio 2005 Team System installed. There now is a separate add-on installer specifically for adding...

The SQL Server conference and event season is starting, so the "DataDude" is gonna hit the road; presentations, demonstrations and talk to many many users and customers. I will be presenting at the following events: SQLSkills Immersion Event in New York...

From Mexico, yes I am on vacation, I wanted to let you know that CTP4 is ready for you trlo download and take it for a spin. http://download.microsoft.com/download/6/8/1/681f2f35-365c-4b47-a1ac-044f9801efb0/TeamDataCTP4.exe The main new thing is...

Did you know you can tell us what you think about the product, the approach, problems, product improvements and wishes via the MSDN forums? We have a MSDN forum specifically for the DataDude SKU (Visual Studio Team System - Database Professionals)...