blogs.conchango.com

  This issue caught me out today whilst putting together some build scripts for reference data. So I thought I’d share it. USE [tempdb] GO CREATE TABLE [dbo].[Table_1](       [Col1] [int] IDENTITY(1,1) NOT NULL,       [Col2] [char](1) NOT NULL ) ON [PRIMARY] GO delete from ...

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 change. All of my code that references the table is auto checked-out of source control and ...

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'. You can see it here look: The deployment script that is ...

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 sake) though in some places it is listed as "Visual Studio 2005 Team Edition for ...

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 tools. Head to Visual Studio 2005 Team Editions Comparison for an explanation of the ...

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 a hack one could use to change the name of the file that is output from a datadude project build. ...

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 how to achieve that in my tool of choice, SQL Server Integration Services. Recently another tool ...

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 statements in them. An easy way to fix this is to use Visual Studio's find/replace ...

I found this new article written by Sachin Rekhi on Database Unit Testing with Team Edition for Database Professionals. I think it's an excellent read.  The only thing I don't think it covers is what is not included in the product.  The most notable piece of Team System Unit Testing functionality that isn't included with DB Pro is Code ...

I recently put up a post with a unit test for check constraints validating all were defined with the NOT FOR REPLICATION option.  I thought it might be helpful to put up a post with tests for all the other object types that can have this option set. select object_id,name,is_not_for_replication from sys.foreign_keys where ...