Category: SQL Server
Getting All Permissions for Server
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…
SQL Server Audits and Action_IDs
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…
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…
SSIS, MySQL, and invalid Dates–Take #2
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…
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: 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…
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…
SQL Server: Problems with corrupt files or assemblies
Yesterday I found and fixed a bunch of hard drive issues. One of those issues resulted in my “Microsoft.AnalysisServices” assembly for SQL Server 2012 becoming…
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…
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”….