MDX Puzzle #4 - Solution

This puzzle may not have been much of a challenge, but it introduced two new MDX concepts.  I have to...

Personal or Professional Ethics

Steve Jones had an interesting blog post the other day, Do as I Say, Not as I Do, and I...

Presenting to the West Michigan SQL Server User Group / SQL PASS Chapter (Rescheduled)

Presenting to the West Michigan SQL Server User Group / SQL PASS Chapter (Rescheduled)
My presentation scheduled for earlier this week to...

Schedule Announced for SQLSaturday #49 in Orlando

Our schedule for this year has 47 one hour sessions plus another 6 “mini” fifteen minute presentations, plus a separate...

SQL University – Other Capacity Issues

This is the final lecture this week at SQL University. We are covering the topic of capacity planning this week...

SSC Editorial: Becoming Highly Productive

This editorial is about the idea of being highly productive more than how to actually accomplish it. Most of us...

Ambiguities and the wild object.oriented brigades

--Whilst trying to design a more effective way of detecting dependencies in a SQL Server database, I was mulling over...

Checking Users AD Groups Using Windows CMD

Blog Title: Checking Users AD Groups Using Windows CMD

Depending on your role in the organization, there may be a time...

Commenting TSQL Scripts

If you have ever searched for “commenting in TSQL” scripts, I am sure that you’ve found hundreds or maybe even...

Finding Key Lookups In Cached Execution Plans

Ask anyone with performance tuning experience to list the most expensive operations in an execution plan and it's a safe...