Posts tagged with: ssdt
SQL Management Studio 17.1
Starting in 2016 SQL Server Management Studio got its own team at Microsoft and after many years of very little improvement we are starting to see some pretty consistent......
Moving SET NOEXEC OFF in SQLCMD deployment scripts
Currently when we build deployment packages we try to validate that the deployment is properly configured for the customer site to reduce errors. We do this by validating the version......
Deployment Variables Anti-Pattern and Site Configurations
This example has been in my list to post on for quite some time now and a recent conversation reminded me to bump it up the list. The number one......
Trying to Resolve “Failed to deploy database project:..” when running Database Tests
On certain occasions when you try to run the database tests you will receive the dreaded “Failed to deploy database project:” message and then many of your tests will fail.......
SSDT Deployment Optimization for Table Constraints and Calculated Columns
Calculated columns on tables can be helpful. For example let’s assume you have a table with Name Fields and you have a formula for FullName. You typically want that formula......
Incorrect SQL71558 error when joining synonyms in SSDT
I recently ran into an issue where the SSDT compiler in Visual Studio was misreporting an error and I wanted to post about the setup and work-around. SSDT, also known......