Deployment Contributor Logger

Niche tool of the day If you know what a deployment contributor is and have wanted to see what steps were in a plan and have got bored setting...

Session Action Metadata

Knowing how to access the deployed session metadata and the event metadata attached to that session, I will now begin the dive into how to find the same relevant...

Session Action Metadata

In a previous article, I introduced the core concept of Actions. In that article, I explained that an Action is...

New SSRS features in SQL 2016 CTP 2.4

SQL Server 2016 CTP 2.4 hasn’t been released yet (any day now I guess), but someone was apparently very eager...

Updating a view

I was recently asked how to update views. Specifically the question was about using triggers to update a view.
So...

Utility link for excel import to SQL

Utility link for excel import to SQL

Save Excel Data into Databases
http://www.savetodb.com/Connect to databases, edit data, and save changes back. Edit data...

What’s happening in Asia Pacific?

TweetG’day,
I really am going to make an effort to blog more, and this post is really the start of that.

I...

SQL Licensing

Recently, there are lots of questions about SQL licenses, many of them came from the fact that they starting to upgrade to 2012/2014 from their old 2005 servers as...

Bitwise XOR in DAX

In T-SQL and other languages we have bitwise XOR natively supported; the T-SQL operator is simply ^. Here’s the explanation of...

Data Warehouse from the Ground Up at SQL Saturday Orlando, FL on Oct. 10th

SQL Saturday #442 is upon us and yours truly will be presenting in Orlando, Florida on October 10th alongside Mitchell...