Stefan Krzywicki (5/27/2011)

---

GSquared (5/27/2011)

---

A friend of mine says that what a friend of his does is buy old clunker cars, usually for around $2,000 or so. Then the only...

The passwords in native SQL Server backups are weak.

I was thinking more of managing the encryption keys/passwords for third party tools that encrypt the backups. Tools like SQL Backup...

mgraham 67977 (5/27/2011)

---

We have implemented something we call a poker key server. To retrieve a database encryption key you have to enter a long (20 character) password of which ten...

Arrgggghhhhh.

My apologies. The second sentence was intended to be an example, not part of the questions and I inadvertently phrased it backwards.

I've awarded back points to everyone so far and...

Congrats!

you don't add the service name. You add the account under which the service runs. Those are separate things.

The service name is just meta data, like the full name for...

I think that the OP said both SQL and the custom service are on the same machine (Server1) in this case. Your point is valid, and since services can move,...

Right click in SSMS the database and select Export. Use the wizard. It builds simple SSIS packages.

I think Elliot has good advice here. I'm not sure what happens here with the Local System account. Typically you run that for various services, but not necessarily those that...

Good luck, and I feel for you on the bad design.

Moving to one trigger that simplifies the update sounds like a better idea if you're stuck here. The less...

I've started looking for some, and we'll see.

I think many of the people at SSC are worried about cost, others worried about security or legal issues. There are people using...

GilaMonster (5/26/2011)

---

Roy Ernest (5/26/2011)

---

I have an idea for one of persons who want to go to SQL Pass summit for free (Except air travel). Make list here who wants to...

"may" speaks to possibilities. Extents can be uniform (one object stored) or mixed (multiple objects stored)

Perhaps another word would be better, but I do see so many of our executives as being greedy. Not evil, but getting caught up in the Lord Byron quote about...

Ditto. Hopefully I'll get to see it on a recording or live in Oct.