The SQL PASS Summit countdown has already started!

As a SQL Server professional, I consider it an absolute must to attend the SQL PASS Summit each year. Last...

Using PerformancePoint against tabular data

PerformancePoint (PPS) is typically used against multidimensional data sources (i.e. Analysis Services), but it does have the ability, albeit limited, to work against...

Windows 8 First Impressions

I haven’t worked with Window 8 at all. I’m not a big beta tester, and it’s been a busy few...

You don’t like SQLTreeo price

Today is the first day when we turned SQLTreeo into a commercial product and your emails continue to flood into...

Another Stop-Gap Solution for the SQL Server 2012 Identity Crisis

                I haven’t seen this many fake ID’s since I was in college.

                Back on April 26, Grant Fritchey (of execution...

Discovering Binary Pages In Sys.Indexes

In a previous post, we looked at how to take the the binary page values in sysindexes and convert the...

Getting Started with Partially Contained Databases

Before SQL Server 2012, when we move or restore databases to a different SQL Server instance, then any logins associated...

More Thoughts on the Mac Air

I’ve been living with my Mac Air for a few weeks now, thought I’d share some quick thoughts:
I miss the...

perfcollect

This is one of my most closely held DBA secrets.
Do you use PAL? You should.
Clint Huffman is a golden god...

Policy-Based Management, How Sweet It Is

I have just recently changed employers and in doing so, I’ve changed my role from Data Architect to DBA/BI Developer. ...