MDX #30 – Get The Book: MDX with SSAS 2012 Cookbook

MDX with SSAS 2012 Cookbook
by Sherry Li and Tomislav Piasevoli
Packt Publishing 2013
The book is now available in both paperback...

SQL #50–Deleting or updating data from a table of 20+ GB

I don’t have a definition of what is considered a large SQL table. I am pretty sure, however, that a...

Counting Work Days

Don’t forget that most holiday’s aren’t work days.
Recently while working with a client I was faced with some seriously convoluted...

I am on LinkedIn

I don't know why, but I never "got" LinkedIn and I ended up leaving it in frustration as I was...

Finding Ad Hoc Queries with Query Hash

I was presenting a session on how to read execution plans when I received a question: Do you have a...

Get OS Counter Memory Available Mbytes Using TSQL

I have been working recently in making sure that max memory is configured for the hundred plus database servers I...

Monitoring and Baselines Presentation

Here’s my full presentation for SQL Saturday #250 in Pittsburgh this past Saturday along with some notes on what I...

Power Map Enhancements and Presentation

Power Map for Excel 2013 has had some recent enhancements that are worth noting.  You can download the latest Power...

Reblog: September 13 to September 19

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...

Secrets of successful projects…:)