Question : I am reviewing freshly generated scripts out of SSDT publish tools. These projects were built from a default […]
Tag: ssdt
SQL Server – Adding non-nullable column to existing table – SSDT Publishing
Question : Due to business logic, we need a new column in a table that is critical to ensure is […]
Automatic Version increment on Data-Tier Applications
Question : In the project settings of a database project I can set the version number form my data-tier application, […]
How to prevent SSDT publishing from dropping columns
Question : I want to create a publishing profile that DOES a complete schema comparison and publishing BUT does not […]
Optimizing syncing of large dataset between 2 servers with SSIS
Question : I have two DBs on different servers, Server A and Server B. Both are SQL Servers. I need […]
SSDT Schema Comparison for Stored Procedure signed by a Certificate
Question : I am using SSDT 14.0.50730.0 in Visual Studio Professional 2015. I am comparing databases between two instances and […]
SSIS Control Flow: Precedence constraints not working as expected
Question : The control flow of my SSIS package is not behaving as expected. What I want to achieve: Test […]
DACPAC Deployment Rebuilding All Indexes
Question : I’m in process of deploying a DACPAC provided by our ISV. The DACPAC is rebuilding every index in […]
Reinitialize Table Values in SQL SSDT Unit Testing
Question : I am creating SQL Server Unit Tests. We are testing various stored procedures. In Unit testing principles, it […]
What does @RC mean in SSDT SQL Server Unit Testing?
Question : In Sql Server Unit Testing, SSDT, what does @RC stand for? Does it mean Row Count, or Row […]