SQL Server Archive
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
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.
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 generate select statements for MySQL that would automatically set any invalid date
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 takes a “one size fits all” approach and assumes that you
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 from time to time. Often, those pre/post deploy scripts are designed to
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 database references to the project. That takes care of all of the
SQL Server: Problems with corrupt files or assemblies
Posted by paschott in SQL Server On November 14, 2012
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 corrupt. That in turn resulted in VS2010 throwing errors when I tried
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 setting trigger order for triggers on a table, you could run into
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”. This builds a dacpac file into a folder within the project called
SSDT: Publishing Your Project
Build the project In order to successfully publish your project, it must first be able to build successfully. Start by building your project. Right-click the project and select “Build”. If the build is successful, the project can