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…

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….

[display-posts category=”SSDT” posts_per_page=”-1″ include_date=”true” order=”ASC” orderby=”date”]

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…

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…

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…

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…

I wanted to add a short post to make sure I highlight some things that will trip people up or otherwise cause issues.   When…

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”….

SSDT includes an Errors and Warnings window that is well worth your attention. Ideally, your project should have no errors or warnings.   However, sometimes…