:w00t:??? Totally agree!!! The importance of encryption of data at rest (any data, not just SQL-DB) is linearly dependent on the mobility of the medium of said data. Period.

I've followed...

[rant] No it's...

The case of a student paying for school, then paying again to have his/her homework done by someone else (hence getting less value out of more money) is ironic at...

[Quote]As DBAs we often try to control our world and ensure a high degree of stability, often at the cost of slowing or severely impeding changes in our systems. While...

Ulysses_Infinity (9/1/2011)

---

I park about a 20 minute walk from the office - why? To avoid punitive parking charges of approximately £130 per month! And it gives me a little...

The problem of readability of (very) old data from a backup is twofold: a) is the data physically readable (the bits) and b) can those bits be translated into meaningful...

nadabadan (8/16/2011)

---

mar10br0 (8/16/2011)

---

A few months ago I installed 4x 64GB SSD in a RAID 0 configuration using the SATA-controller on my motherboard in my home PC. I can tell you:...

A few months ago I installed 4x 64GB SSD in a RAID 0 configuration using the SATA-controller on my motherboard in my home PC. I can tell you: it FLIES....

Eric M Russell (8/1/2011)

---

mar10br0 (7/29/2011)

---

Eric M Russell (7/29/2011)

---

mar10br0 (7/28/2011)

---

For deduping duplicates in a heap-table, I would just delete all offending rows, then re-insert one record. Since a heap cannot have...

Eric M Russell (7/29/2011)

---

mar10br0 (7/28/2011)

---

For deduping duplicates in a heap-table, I would just delete all offending rows, then re-insert one record. Since a heap cannot have any foreign-keys pointing to...

peter-757102 (7/29/2011)

---

... I however stand corrected on the 512 byte sector size, it seems indeed SQL server despite technically writing data using sector size chunks, it does not attepts to...

For deduping duplicates in a heap-table, I would just delete all offending rows, then re-insert one record. Since a heap cannot have any foreign-keys pointing to it, this will succeed...

paul.knibbs (7/27/2011)

---

I'm not sure increasing the row length in SQL would help much--after all, the largest data types are stored in off-row data pages anyway, and a properly normalised database...

In my database designs my default choice for all tables is for them to have a surrogate key, a TIMESTAMP togethe with Last Modified UserID. For the surrogate key I...

Hi Steve, agree with you in almost all aspects. But, "If a cloud vendor's employees can access your files, so can a hacker that gains access". Well yes, but taking...