Per Member Per Month Per 1000 Calculations in MDX

In a lot of industries there is a popular calculation called “Per Member Per Month Per 1000” calculation or the...

SQL Server – Show/Hide Results Pane in Management Studio 2012

In earlier version of SQL Server Management Studio (2005, 2008 and 2008 R2) you can show/hide results pane using keyboard...

SQLSaturday#200 PA Event Update!

With less
than two weeks to go until SQLSaturday#200 at 45
Liberty Blvd., Suite 210 Malvern, PA 19355, Malvern, PA, 19355 they're...

Indexes – Understanding basic types and their components

The biggest problem developers and newer DBAs have with understanding indexes is that you don’t realize when you’re using the...

Software Design and Schizophrenic Windows 8 Part 2

I know it’s not schizophrenic, but that sounds better. It’s really a split personality.
I wrote recently about Windows 8 and...

Windows, RIP (1992 – 2013)

Today is a very sad day for me. My love, my dear Windows has passed away. We were together for...

Certifiable?

I have recently begun to contemplate pursuing the MCSA Certification.  I have been working with SQL Server for almost 20...

SQLSaturday #220 Atlanta

From the tweets, it looks like there will be about 800 attendees sitting in on 11 different tracks with 5...

Indexes – Unused and Duplicates

Indexes aren’t free, and many databases end up with unused indexes. Every time you make any update to a table...

SQLSaturday Redmond(SQLSat212) is almost here…Will you be there?

This is my first SQLSaturday and I’m super excited to attend this event.

SQLSaturday’s are always a great opportunity to learn something exciting,...