I've never heard of the CAP Theorem before. Very interesting reading!! I can see its application. And I'm quite impressed that it could be proven rigorously. Thanks for writing this...

I quite agree, Ben. And I'm quite fine if no one agrees with me, so long as it's done amicably. 🙂

Oh Ben, you sure know how to pick a hot topic for Friday. 🙂

Well, I can honestly say that I've been on both sides of this issue. At my old...

Dale, et. al.,

Speaking only for myself this long running thread just brings to mind the fact that the thing I've never been able to do is direct my career as...

Grant Fritchey (10/8/2015)

---

Rod at work (10/8/2015)

---

Grant Fritchey (10/8/2015)

---

While SQL Server can store XML, it's not great at it. You might want to consider looking at one of the ID/Value databases...

Grant Fritchey (10/8/2015)

---

While SQL Server can store XML, it's not great at it. You might want to consider looking at one of the ID/Value databases that's meant to cope with...

Jeff,

I'm very sorry to hear of your father's passing away. My father is still with me, for which I'm grateful. I can only imagine how hard that must have been.

Thank you, this sort of helps. But the link you provided didn't give an example of how to insert a blob data item into a column defined as binary(n).

Actually now...

Thank you very much, Steve.

I've never even heard of data masking. I had to look it up to find out what it is. Sounds useful; how is it used in SQL Server? What versions...

I knew that R is going to be in the new SQL 2016, but I didn't know that JSON was also going to be in it. Very interesting. Thanks for...

There were, but I think I've handled them all.

I hadn't thought of renaming the foreign key constraints. That's an interesting idea. However, even if I did rename the foreign key constraints they're definition would still be looking for...

Eric M Russell (9/18/2015)

---

.. Staying or going isn’t about loyalty, it’s about what is best for you and you can measure that in any way you want – money, vacation,...

Excellent follow-up article, Andy.