I don't like dashboards for storing this stuff. What I'd do is use a process that grabs the backup info and drops it in a small db in Express. That...

Perry is correct. The hierarchy on an instance is

SMK

- encrypts DMK (master)

- encrypts certificate in master (can be multiples here for different dbs)

...

I'll drop a note on Twitter, but I doubt it. All the CAS systems I've seen in the past were very, very expensive. As in $100k/appliance. Not something many people...

It would be nice if failures in a trigger referred to a tran error in a trigger. But what if a trigger calls a sproc and there's a failure there?...

For the named instances, you should be able to uninstall any of them from setup. You could just delete the binaries and registry stuff, but that's a pain to dig...

Don't answer here, but feel free to send me a note (sjones at s__s____c____.com)

How would you define data monitor? What does it do? How granular and configurable? I think you're...

They do it differently. When I used to manage all of these,...

Iwas Bornready (4/30/2015)

---

When I ask our DBA about upgrading he just asks why. He says it is too expensive unless there is a compelling reason. We are on 2008 R2...

Ed Wagner (4/30/2015)

---

Great timing for this article. I'm planning the installation of a new server and it'll be 2012, not 2014. As much as I'd like to move...

lshanahan (4/30/2015)

---

In the comments of the SQL Server Blog article someone mentioned the cost issue, to which the team quickly responded by pointing to a study by Forrester Consulting (commissioned...

Xavon (4/30/2015)

---

An interesting point on this; PCI PADSS (credit card industry rules) require that the system be under support. So if your 2005 database holds credit card information, even...

Brent Ozar (4/30/2015)

---

To elaborate a little more about the licensing - here's some of the challenges we've faced in the past.

We found a consulting company that was modifying sp_Blitz®, then...

Gary Harding (4/30/2015)

---

Hmm. As John C. Dvorak might once have said, can...

robert.sterbal 56890 (4/30/2015)

---

I appreciate someone pointing out licensing challenges with this script.

Is there a better forum for asking questions about what metrics you can pull back with sql monitor?

I'd particularly...

LOL, I'm sorry and I can certainly appreciate the frustration, Recurs1on. Glad you figured it out and that's a good one to keep in the back of my mind.

Can...