Vendor Management Systems

A vendor management system (VMS) is a web-based application that acts as a mechanism for businesses to manage and procure...

Azure Capabilities Expand

But then, the capabilities in Azure are always expanding. Here’s the new stuff that was just released in a blog...

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...