sp_executesql, Parameters and Parameter Sniffing

I’m honestly not crazy about dynamic T-SQL within stored procedures. There are just a few too many opportunities to mess...

SQLSaturday #250 in Pittsburgh

Welcome to SQLSaturday #250 in Pittsburgh
http://www.sqlsaturday.com/250/

SQLSaturday is a full day FREE  training event for SQL Server professionals and those wanting to learn more about SQL...

SQLSaturday Salt Lake City #246

Fast approaching (yeah just a couple of days out now), is SQLSaturday 246.  This year t
he event is sort of...

SQLSaturday Salt Lake City #246

Fast approaching (yeah just a couple of days out now), is SQLSaturday 246.  This year t he event is sort of in Salt Lake City, being another 10-15 minutes...

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