Welcome to EMC Consulting Blogs

Browse by Tags

• Deployment
• Microsoft
• regular expressions
• Service Release 1
• SQL Server
• TableDiff
• Team Foundation Server
• Team System
• TFS
• Visual Studio Team System For Database Professionals

• I'm loving datadude

  I want to take the opportunity give a little bit of love out to the datadude team. Just now I wanted to move one of my tables into a different schema. This table is referenced in countless pieces of code so I used Refactor-->Move Schema to make the Read More... Posted 23 November 2007 08:13 by jamie.thomson | 5 Comments Filed under: Visual Studio Team System For Database Professionals, datadude

• Datadude: New unannounced feature in SR1

  Service Release 1 of Visual Studio 2005 Team Edition for DB Pros (aka datdude) includes a new feature that hasn't been mentioned anywhere by the datadude team. Any database deployed using SR1 will contain an extended property called 'microsoft_database_tools_deploystamp'. Read More... Posted 10 September 2007 22:41 by jamie.thomson | 3 Comments Filed under: Visual Studio Team System For Database Professionals, datadude

• Datadude/DBPro/VSTS4DBP/huh...???

  It has annoyed me for a long time that this product (note I'm linking to it, not naming it) suffers from a lack of identity. The official name is "Visual Studio 2005 Team Edition for Database Professionals" (58 characters for pity's Read More... Posted 24 August 2007 21:40 by jamie.thomson | 3 Comments Filed under: Visual Studio Team System For Database Professionals, datadude

• Very Slow To Satisfy? Vast Silos of Tumultuous Software? What...?

  Do you get lost in the myriad of tools that congregate under the banner of Visual Studio Team System (VSTS)? Perhaps you don't, but I do! Today David Reed pointed me at a resource on MSDN that does a good job of unmuddying the waters as regards these Read More... Posted 21 August 2007 07:03 by jamie.thomson | 0 Comments Filed under: Visual Studio Team System For Database Professionals, datadude, Team System

• Datadude: Gotcha in SR1

  As Gert Drapers has previously reported , the datadude team have released Service Release 1 (SR1) and Power Tools for datadude (aka Visual Studio Team System for Database Professionals ). Back in December 2006 I published this blog entry that explained Read More... Posted 13 August 2007 22:48 by jamie.thomson | 1 Comments Filed under: Visual Studio Team System For Database Professionals, datadude, Service Release 1

• TableDiff utility

  I work predominantly in the data integration space and I suspect most of you reading this do too. One of the most common data integration scenarios is discovering what records in one table don't exist in another and I have previously written about Read More... Posted 08 August 2007 01:55 by jamie.thomson | 4 Comments Filed under: SQL Server, Visual Studio Team System For Database Professionals, datadude, TableDiff

• T-SQL: Remove collation statements using Regular Expressions

  I use datadude quite alot and recently I imported lots of tables into my datadude project but forget to configure it to not import the collation (more on how to configure that some other time). Hence, I had a huge collection of tables with unwanted collation Read More... Posted 04 June 2007 22:47 by jamie.thomson | 0 Comments Filed under: Visual Studio Team System For Database Professionals, datadude, regular expressions

• VSTS4DBP: Check for permissions

  On my current project we are using Visual Studio Team System for Database Professionals aka Datadude to manage the deployment of SQL Server objects to our various dev, test, QA and production environments. In doing that I came across a bit of a problem Read More... Posted 27 March 2007 22:23 by jamie.thomson | 3 Comments Filed under: Visual Studio Team System For Database Professionals, datadude

• VSTS4DBP: Database name does not get included in TFS builds

  I found a bug in datadude yesterday and, with a little help, I was able to come up with a workaround so figured I'd post here in case anyone else comes up against it. In the RTM version of Datadude it is possible to specify the name of the database Read More... Posted 19 January 2007 16:31 by jamie.thomson | 1 Comments Filed under: Visual Studio Team System For Database Professionals, datadude, Microsoft, TFS, Team System, Team Foundation Server, Deployment

• VSTS4DBP: Datadude build version numbers

  I thought it would be useful to know the version numbers for all the various builds of datadude seeing as there is nothing in the installed product that tells you. Gert provided the information here which I'm sure he won't mind me copying into Read More... Posted 17 January 2007 01:53 by jamie.thomson | 3 Comments Filed under: Visual Studio Team System For Database Professionals, datadude, Microsoft, Team System