Question : Is there any way in Visual Studio SSDT Publish Profile, to Totally Ignore Query Store Options Completely? It […]
Tag: ssdt
How to read data from multiple Excel files with SQL Server Integration Services(New Senario)
Question : Hope you’re doing well. I have a scenario here. As you can see I have a table with […]
Will SSDT publish always fail with “Data Loss May Occur” when table is rebuilt?
Question : Consider the following scenario: We have a SSDT database project. We add a new column to the middle […]
Exclude certain schema along with unnamed constraints in SSDT
Question : Task Automate database deployment (SSDT/dacpac deployment with CI/CD) The database is a 3rd party database It also includes […]
How to Publish Checked-In changes only in Team Foundation Server 2013 to SQL Server?
Question : I would like to ask you how to publish checked-in changes only in Team Foundation Server 2013 to […]
Which install kit installs sqlcmd.exe?
Question : I recently had to uninstall Visual Studio 2012 and DTS, then install VS 2017 and DTS again. Afterwards, […]
Drillthrough action on semi-additive measure group
Question : I have created a semi-additive (Last Non-empty) measure in a cube that I am developing. For that measure […]
Is there a way to easily validate that a SQL Script is compatible with a specific SQL Server version?
Question : I am currently working on a project that needs to operate in different SQL environments. Most of my […]
SSDT 2010 and SQL70590 errors
Question : I have Visual Studio 2010 SP1 with SSDT (with Dec 2012 update). I have created a new SQL […]
Why is :r SQLCMD command marked as wrong in Post Deployment Script?
Question : I have worked a couple of times with post deployment scripts and always, intuitively used the build action […]