I just came across a post from Ed Elliot (b | t ) about running Scripts before the SQL Package process runs. Sort of a…

I don’t know why it took so long before making the connection between PowerPivot models and SSAS Tabular models, but in the last couple of…

Getting Started I attended Varigence’s BIML Workshop last year prior to the PASS conference and got to learn a little BIML while seeing what it…

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…

A while back I posted an article on handling dates in select statements from MySQL. The idea was that I wanted a quick way to…

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…