RonKyle (5/4/2015)

---

It makes the database a little more robust because isolating the system tables from the data tables and indexes reduces the chance that the...

jonathan.crawford (5/1/2015)

---

Jeff Moden (5/1/2015)

---

I had a rare and wonderful opportunity, today. Luis is in town and I finally got to meet him and have lunch with both him and...

Your question or post doesn't really have context or make sense.

Eric M Russell (5/1/2015)

---

Steve Jones - SSC Editor (5/1/2015)

---

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

Looks like security issues. Note that the SQL Agent has to have rights here. The Network Service account doesn't necessarily have rights to get to the files you're working with.

Can...

The error gives you the problem. You need features enabled on the remote machine.

SQL Server is an application that runs inside Windows. As such, it doesn't have access to...

If someone is sending you a string and you want to use it as a part of a WHERE clause, you'll need to be sure you use dynamic SQL in...

1TB, but how big on average? The average size matters more for performance and issues.

If these aren't read often, I might also try to compress them.

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