Nadrek (2/10/2012)

---

I would say hashing should be done on the application side at this point, because

A) SQL Server does not provide us modern hash algorithms (i.e. the SHA-2...

Good advice from Ron. I might also say give it a chance, and let some of the DBA stuff go. Or let it happen slower. They may decide to move...

Proper beer?

Who cares. Beer, wine, liquor are meant to be enjoyed....

Hugo Kornelis (2/8/2012)

---

So I disagree that the minimum version should be included in all QotD questions. I think we should all assume that questions apply to supported versions of SQL...

michael.kaufmann (2/9/2012)

---

I'd second this; it's my understanding that concatenating a fixed string as salt (in Steve's example assigned to a variable) to another string can't be considered a salt parameter,...

Raghavendra Mudugal (2/9/2012)

---

For me this question did not made any sense.

the sample code is just concatenating another variable to it, you can name it @salt to @sugar... still the sample...

Rich Weissler (2/9/2012)

---

Yeah, I decided SALE had to be a typo for SALT. (If that isn't want happened, someone please yell... I'm...

Feel free to private message me the author of the message. As far as I know, we do not sell any addresses. I'd like to say "I don't", but I'm...

I agree with Nicholas, I don't see anything about centralization of data.

I am assuming this means db01 data moved to db02 for reporting. Is this real time? How much delay...

george sibbald (2/7/2012)

---

when you get into terrabyte databases the emphasis shifts (IMHO) and direct backups to tape begin to make more sense. Thats a lot of disk to tie up...

congrats, Grandpa!

Is this for DR? Or another purpose? There are P2V tools (physical to virtual) that can capture an image of a machine for migration purposes, but this can work well...

Added a note. I...

webrunner (2/7/2012)

---

Thanks, Steve, this editorial, though brief, gave me lots of food for thought. I don't want to get too philosophical, but for some reason (maybe the fact that part...

What you are asking for, and I'm still not clear on this, is something that is completely custom. There's no way a component is going to be available for pulling...