Tags » SSDT

SQL Server Data Tools: A spork of sorts (part two)

In the previous post (a bit of a rant too) I went over SSDT and how it has evolved for whatever reason by Microsoft into SSDT (Database development) and SSDT-BI (Business Intelligence development). 395 more words

SQL Server

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: … 343 more words

SQL Server

SQL Server Data Tools: A spork of sorts (part one)

Prior to SQL Server 2012 the Business Intelligence (BI) toolset was made up of just Business Intelligence Development Studio (BIDS). Easy to install as it was part of the SQL Server installation media. 411 more words

SQL Server

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


Counting logical lines of T-Sql code in a DacPac

There are two general ways of counting lines of code, the first is basically just count the lines in each file that make up a project, the second is to count the logical statements as specified by the language. 528 more words


Dac Fx Api – Use it, write better tools for Sql Server!

The DacFx Api is an api for querying the object model that both DacPac files and SSDT use, it is a giant leap forward in the available tooling for Sql Server and hopefully there will be a raft of great tools to make T-SQL development better. 727 more words