Exploring Excel 2013 for BI Tip #11: Color Scales

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

How to become a better, well-rounded SQL Server DBA

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
People are sometimes...

Is Microsoft's Certification Program Value Microsoft's Fault?

I'd be interested if anyone says, "No," to that question. Gail Shaw raised a few points in this post about...

It's not you; it's us

Mirrored from http://www.sqlservercentral.com/articles/Editorial/101894/

By now I expect this news is no longer new: the MCM, MSA, and renamed versions of those...

Learn SQL Server Performance Tuning Basics in a Single Day

Have you always wanted to dig into performance tuning but wasn’t sure where to start? If so, check out this Introduction...

Presentation Slides for Building an Effective Data Warehouse Architecture

Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for the PASS DBA Fundamentals Virtual Chapter.  The abstract is...

Query Stats

DBAs rarely use the full potential of sys.dm_exec_query_stats.  It’s common to see the queries for looking at the most expensive...

Replicated Stored Procedure Execution

One feature that many of my clients are unaware of is that the batched execution of a stored procedure can be...

SQL Server events in the UK September 2013

Sorry things are a little later this month…Summer (like the MCM program) may be coming to an end, but we...

Why Blog?

The main reason I started blogging was a community thing. I leeched from the community to get me to where...