Partitioning Basics – Part 1 – Creating Partitions

Partitioned tables can be a quick and efficient way to (amongst other things) archive data. In the next couple of...

15 years of experience with Identity columns

An identity column is an auto incrementing columnAn identity column is typically used as a primary keyA primary key that’s...

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....

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...

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...

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....

SSAS Performance Logger Now Available

I’ve created a simple query performance logging tool for Analysis Services, called the SSAS Performance Logger.  The tool allows you...

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...

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...

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...