Quite often when creating a database you will need tables of static data. These range from simple lookups to date dimensions in a data warehouse. You can easily create these in an SSDT project. 231 more words
Tags » SSDT
"SQL71508: The model already has an element that has the same name" error when building SSDT solution
I recently came across this error when attempting to build an SSDT solution that had been handed over to me by another developer. The database references within the solution were quite complicated for a couple of reasons: 351 more words
tldr: I have written a free vs package to deploy files quickly from SSDT to sql server, to speed up the red-green tdd cycle.
I find that writing code for sql server using TDD can be a little frustrating, the process I have is that I use SSDT to manage and deploy database projects including tests written using tSQLt, using the standard red-green cycle:542 more words
Today I stumbled upon this post by Koen Verbeeck:
363 more words
Oh wait sorry, I meant SSDT. Or was it SSDTBI? To avoid confusion about the developer tool to create BI solutions, Microsoft has changed its name a few times.
Using SSDT you can immediately publish a fresh database or update an existing one by simply right clicking the database project and choosing ‘Publish’. This will bring up a dialog that lets you edit the connection string to your database and set various options related to the publish. 373 more words