Using PIVOT function without a CTE

There are some cases when you need to use a PIVOT function in SQL but you cannot use a CTE....

Access Granted or Not? Question of the Day

Access Granted or Not? is my latest Question Of The Day and I think it represents a pretty good troubleshooting...

Attaching All Databases with PowerShell–Attaching Missing Databases

I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...

Busy Busy Weeks, Finally Some Good News! SQL 2008 / 2008 R2 Will Get Their Final Service Pack!

We will actually be getting our final Service Pack! 

The information can be found here. You may still want extended support...

Columnstore Memory Grant Issue

In a previous post about non-clustered columnstore indexes, I mentioned the creation of an index is a very memory intensive...

Handling Perfmon Logs with Relog

In a recent situation, I was tasked by a client to check one of their servers which they believed to...

I Voted For the 2014 PASS NomCom

I was interested to see that the online voting system has changed this year to one powered by Simply Voting....

I'm A Candidate For The 2014 PASS Nomination Committee

The 2014 PASS election cycle begins today when voting opens for the Nomination Committee (NomCom) and I'm one of eleven...

Power Pivot as the Core to your Power BI Solution

I’ve noticed a recent trend with many presentations and articles on Power BI and Excel functionality. Many of these presentations...

Recent Reading: The Food Network, And The White House!

I haven’t posted much on books lately, here are two that are different:
Inside the Food Network. Definitely some gossip, but...