Tags » SSDT

Build a testing database with SSDT and NuGet

tldr; My central idea was to use SSDT to build a dacpac file that would define the schema of our testing database and wrap that DACPAC artifact in a nuget package that testing projects could reference.

3,223 more words

SSDT Build Action (AHA!)

One feature I really enjoy in SQL Server Data Tools (SSDT) for database development is the ability to include scripts in the project that are not used in the build process.   332 more words

SQL Server Data Tools

Deploying SSDT Scripts (With My Good Eye Closed)

(If anyone actually gets the reference: kudos. If not, then it’s just that you’re not a Soundgarden fan)

So, there’s something that has been troubling me about deploying to databases with SSDT for some time. 948 more words

Unknown Unknowns

Tabular Model Explorer for SSDT

SQL Server Data Tools (SSDT) 16.3 was made available last week and features a new Analysis Services Tabular Model Explorer for SSAS 2016 (1200 compatibility level) models. 650 more words

SQL Server Analysis Services (SSAS)

Power BI – (Twitter Solution Template, Real-time Data, Embedded GA Pricing Update, On-Premise Data Gateway Update, Monitor On-Premise Gateway) – SQL Server 2016 (SSDT Update, SSMS Update)

Here is this week’s BI updates

Power BI – Twitter Solution Template

This is the second solution template offered by the Power BI team and this time I think they have done a fantastic job. 581 more words

Power BI

DROP all you know about DB development (or: What is SSDT?)

TL;DR – I am using SSDT for developing a new SQL Server Database, and it changed my life. Everything is version-controlled, scripts are being generated automatically and DB deployment is finally a piece of cake. 779 more words

Visual Studio

Installing SSDT on Visual Studio 2015

You’d imagine this would be pretty straight forward right? Something like, VS2015 and then install SSDT right? WRONG!

First you need to install VS 2015 and then install the LATEST version of SSDT available… 44 more words