Tags » SSDT

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. 231 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


tSQLt Part 1: tSQLt & SSDT

Aim: Include a SQL Server test framework in an existing SSDT project so it can be added to version control & deployed to environments.

Set up the tSQLt framework: 544 more words