Getting All Permissions for Server
Posted by paschott in SQL Server On April 21, 2016
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 to get all permissions at the DB level before, but even then
SQL Server Audits and Action_IDs
Posted by paschott in SQL Server On February 29, 2016
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 “action_id”, but to actually use, them you need to know what those
Database Lifecycle Management – Dacpacs
I came across an excellent article recently @ Simple-Talk discussing Dacpacs, working with them, structures, etc. in quite a bit of detail for a short article. This post discuses benefits, drawbacks, and potential areas of concern for
Pre-deploy SQL Scripts before checking for changes
I just came across a post from Ed Elliot (b | t ) about running Scripts before the SQL Package process runs. Sort of a “Pre” Pre-deploy script. The concept is simple enough, but it’s something people
SSAS Tabular and Excel PowerPivot
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 days I came across several blogs and videos tying the two together.
Exploring BIML
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 can do. Recently, I realized that I had a job to do
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
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