Jeff Moden (2/12/2012)

---

Does anyone know how to block "Site Owners" in the "Recent Posts" for today? Although I certainly appreciate links to blog subjects, it's gotten way out of...

codebyo (2/12/2012)

---

tony.turner (2/12/2012)

---

MCM is not really open to us in the third-world (...) Even were it to be available, the price (after currency conversion) relative to salary or contracting rates...

TravisDBA (2/13/2012)

---

Steve,

It's tricky. Even if all I had to go on were ZIP code, birthdate and sex columns, I could still probably find out who you are. But on the...

Richard Sisk (2/10/2012)

---

It works quite well, we have key change procedures that are used to regularly update the keys. If a backup is stolen, it's no good unless they also...

Worth the read: http://www.newyorker.com/reporting/2011/10/03/111003fa_fact_gawande

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