blogs.conchango.com

Browse by Tags

• datadude
• Deployment
• Microsoft
• MSBuild
• regular expressions
• Service Release 1
• SQL Server
• TableDiff
• Team Foundation Server
• Team System
• TFS

• 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 | 4 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: Only one license required thanks!

  Here at Conchango there has been quite a bit of discussion by certain people ( JRJ , Dan Perrin , Mick Horne amongst others) about how best to leverage the capabilities of Visual Studio Team System For Database Professionals (DBPro for short). It is generally Read More... Posted 27 February 2007 00:58 by jamie.thomson | 0 Comments Filed under: Visual Studio Team System For Database Professionals, Team System, MSBuild

• 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

• VSTS4DBP: How do I change the name of the output .sql file?

  When you build a datadude project the output is a .sql file that contains the name of the project, the name of the target server, and the name of the database. We ( Andy and I) came across a problem where the name of the output file was too long for MSBuild, Read More... Posted 11 December 2006 18:49 by jamie.thomson | 1 Comments Filed under: Visual Studio Team System For Database Professionals, datadude, Team System

• VSTS4DBP: Pricing for Visual Studio Team System for Database Professionals

  Some information here about licensing for DBPro from Matt Nunn . Hopefully he won't mind me re-posting here: If you purcahse data dude it automatically comes with a full MSDN subscription. If you are already an MSDN subscriber then you can get Data Read More... Posted 07 December 2006 03:03 by jamie.thomson | 0 Comments Filed under: Visual Studio Team System For Database Professionals, datadude, Team System

• Big release day at Microsoft

  A short word about today's massive release from Redmond... As if the world and his dog didn't know, Visual Studio Team System for Database Professionals , is getting released today. This is great news for all us put-upon database developers that Read More... Posted 01 December 2006 04:24 by jamie.thomson | 3 Comments Filed under: Visual Studio Team System For Database Professionals, datadude, Team System

• VSTS4DBP: Be aware when removing objects from your project

  As one uses a new product he or she starts to learn all the intracacies that aren't obvious on the surface. And that is true of Visual Studio Team System for Database Professionals (aka Datadude, aka DBPro) as well. Be aware of something that tripped Read More... Posted 29 November 2006 17:58 by jamie.thomson | 0 Comments Filed under: Visual Studio Team System For Database Professionals, datadude, Team System