Creating a Visual Studio SQL Project from an existing database

There are all sorts of reasons why this is a good idea.  Not least because you can version control, unit test and tie into your CI system any existing database. How many times have you found inconsistencies between a test and live database, not known which one is right and been unsure who to ask on your team?  In my...

Continue reading →

Visual Studio SSDT and TeamCity – What you need to do.

I have just spent the last few days trying to get a SQL Project to build, deploy, run unit tests and create a dacpac on our build server which uses TeamCity. It wasn't a simple process and I had to accept a few conditions that I wasn't overly keen on but the upshot is that it works now and...

Continue reading →

TeamCity and MSBuild / MSTest

TeamCity comes with MSBuild so that you can build your solutions directly by selecting a runner type of MSBuild in the Build Step.  You can also choose the version of Visual Studio your developers use and since TeamCity 8.1, Build Tools for 2013 are supported too. However if you need to run MSTest for your unit tests TeamCity recommends you install the...

Continue reading →

Go to SQLBits!

Ok, so you've missed it this year, but next year... Go to SQLBits! I can't say it enough.  It is the best conference in Europe for learning SQL, it is extremely cheap. it is non-profit and it's a lot of fun.  I've been going for the past 5 years and have never regretted it. This year was no exception, the conference...

Continue reading →