Tags » SSDT

Creating a 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. 580 more words


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. 428 more words


Database Project Entropy

With every new release of a software product, some features are altered at the request of the majority of users with the aim to improve the product. 846 more words

SQL Server

Inside Visual Studio 2012 when dragging objects in SSIS package designer it flickers rapidly

In Visual Studio 2012 (ver 11.0.61030.00 update-4) when we design a SSIS package inside business intelligence developer studio (BIDS)
and try to place a SSIS task on the control flow it flickers pretty rapidly which is very annoying and disturbing, (see the below image for reference) 138 more words

Business Intelligence

Thinking about 70-462 and 70-463

Since I’m taking 70-461 next Monday (14th), Im now thinking about the next exam, 70-463 Implementing a Data Warehouse. I might skip 70-462 since I’m currently doing some DW at work. 230 more words

SQL Server 2012

“MSB4025: The project file could not be loaded. Data at the root level is invalid.” error when building SSDT project in TeamCity

I recently encountered this error when attempting to build a solution with a new SSDT project in TeamCity. The error occurred at the 01 – Build configuration “Visual Studio (sln)” step: 236 more words


tSQLt Part 2: Deploying tests

Aim: Deploy the tSQLt framework & tests using TeamCity & Octopus Deploy.

In production, you may have separate TeamCity, Octopus Server & Tentacle environments. However, as this is a basic setup for testing purposes, I will install all three on the same machine as my local SQL Server instance. 1,163 more words