Excel BI Tip #28: Using member expressions in the CUBEVALUE Function

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

Include File Name in Content Using Power Query

When importing data from a flat file using Power Query, you’d want to combine multiple files and include file name...

Password for SQL Server Service Accounts

I wrote recently about my philosophy for service accounts, and wanted to add a few more thoughts.
Security is important for...

Present at SQL Saturday #386 – Achievement Unlocked!

SQL Saturday #386 (Albany, NY) – My first SQL Saturday Session

So that picture to the right is me out front of...

SSC Editorial: Would You Pay to Wear Jeans at Work?

Would You Pay to Wear Jeans at Work turned out to be popular piece when posted a couple weeks back. The...

When Emotional Intelligence Trumps Math

I have been in Corporate IT long enough to know that when a bad decision is made, you move out...

Culture Differences: US v UK

This is a bit of an off topic post from the technical stuff, but there’s a bit of a tie-in,...

Database Mail shutting down. Mail queue has been stopped.

DB mail in our production servers started acting up last week. We have SQL Server 2012 SP1. There were a couple...

Excel Services in Power BI

**Information current as of 7/22/2015**
There’s lots of exciting news this week with Power BI so expect several short blog posts...

Permissions Posters

I’ve been doing a lot of research recently for my permissions session and for a project at work. During said...