SQL Project Archive
SQL Projects & Change Data Capture
I ran across this article from MSSQLTips.com discussing the use of CDC with SQL Projects. We don’t use CDC with our current systems so I’d never tried to investigate this, but I would also have expected better
SSDT Issue–Online Index Option Ignored
I came across this as we’d recently received a corporate directive that all indexes should be created with the ONLINE=ON option. That’s not too bad. Add that to all indexes as needed, publish the DB project, and
All SSDT Articles
[display-posts category=”SSDT” posts_per_page=”-1″ include_date=”true” order=”ASC” orderby=”date”]
SSDT: Adding Logins for “Execute As” and editing system db dacpacs
We recently encountered an issue requiring us to use “Execute As” syntax in some of our stored procedures. Of course, we have multiple environments which all have different permission definitions so this would cause a bit of
SSDT: Setting Different Permissions per Environment
One of the areas that SSDT doesn’t address adequately is permissions. Many users have different users, logins, and permissions set up across their environments, but SSDT takes a “one size fits all” approach and assumes that you
SSDT: Trick to Not Run Pre/Post SQL on Publish
We’ve run across the need to avoid running certain scripts when publishing a brand new copy of a database from a SQL or DB Project from time to time. Often, those pre/post deploy scripts are designed to
SSDT, Publishing, and Referenced Databases
Had this catch me today in a series of databases that all work together. In order to resolve all of the cross-database dependencies, I’ve added database references to the project. That takes care of all of the
SSDT: Tips, Tricks, and Gotchas
I wanted to add a short post to make sure I highlight some things that will trip people up or otherwise cause issues. When setting trigger order for triggers on a table, you could run into
SSDT: SQL Project Snapshots
SSDT allows for snapshots to be taken of the project at any point. Just right-click the project name and select the option to “Snapshot Project”. This builds a dacpac file into a folder within the project called
SSDT: Errors and Warnings
SSDT includes an Errors and Warnings window that is well worth your attention. Ideally, your project should have no errors or warnings. However, sometimes coding errors slip in to your project or you get warnings that
- 1
- 2