In my old job where I was at for many years, we made very little use of schemas. Mainly we just didn't get it. Then one day it sort of...

Jeff Moden (11/10/2015)

---

GilaMonster (11/10/2015)

---

I've recently seen a system with many user-defined functions, each with thousands of lines of code, often calling each other. Tests or no tests, I'm not touching...

I completely understand those developers you spoke of who were afraid of modifying some VB6 code. I've known of some code I was afraid of modifying as well. Perhaps a...

Thank you, Anthony.

Eric M Russell (10/23/2015)

---

Rod at work (10/23/2015)

---

I very much prefer using IsActive, or simply put Active. I am adamant about this because at my previous job the guy who set...

I very much prefer using IsActive, or simply put Active. I am adamant about this because at my previous job the guy who set up the database was completely inconsistent....

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.