david.gugg (5/1/2015)

---

We run a daily trace that captures SQL running longer that X seconds. This gives us a good idea of what SQL can be tuned to provide the...

I'm in.

FF for 2015 won't be until Aug, so no real hurry. I think Yahoo is hoping for traffic based on the NFL draft.

Thanks

You have to use a T-SQL command. That can be wrapped inside an SMO/PoSh script, but that's what's needed. Shawn has given you a few ways to do that, but...

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