Schott SQL

 Please note that this site has moved over to https://schottsql.com. Please follow me over there for the most recent posts and updates.

We recently had to work out a way to fetch and display all effective permissions granted to our Production SQL Server. I had been required t...

We were recently re-doing our SQL Server Audits and I was reminded again how painful setting the filters can be. MS expects an integer for ...

I came across an excellent article recently @ Simple-Talk discussing Dacpacs, working with them, structures, etc. in quite a bit of detail f...

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

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

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