Category SSDT

SQL Rally Nordic 2015

3rd and 4th of March : 2 days of SQL Server conference delivered by some of the best speakers on the planet. 2nd of March : 1 day of pre-conference History Started in 2011 by some of the pioneers of the European SQL Server community : Raoul Illyes and Johan Åhlén from SolidQ the SQL […]

Deploying Tabular models

1 Introduction The purpose of this document is to document a viable way to deploy tabular models from say development to test to production. The lifecycle of a tabular project can be illustrated as follows : 2 Development All development of tabular models happens with Visual Studio where the developer uses a local instance as […]

Automating database tests with Visual Studio and Team Foundation Server

This is the third post in the series about database development and testing using SQL Server Data Tools and Team Foundation Server. Post 1 : Continuous Integration with SSDT and TFS Post 2 : Unit testing with SQL Server Data Tools You can run test in Visual Studio to test the quality of your build. […]

Unit testing with SQL Server Data Tools

This is the second part on the serie about SSDT and database development and also my second blog post in collaboration with SQLShack. Part I: Continuous integration with SQL Server Data Tools and Team Foundation Server In December 2012, a great addition was made to SSDT: The ability to do database unit testing. However, this […]

Continuous deployment with SQL Server Data Tools and Team Foundation Server

SQL Server Data Tools – a free standalone download or and add-in to visual studio comes in different flavors and versions. Although this blog post uses Visual Studio 2012 and SSDT stand-alone the principles are example are also valid on Visual Studio 2013. As you know SSDT is Microsoft developer tools for working with SQL […]