Stacey Decker (10/30/2014)

---

I agree, why allow two values to mean the same thing? I handle this by allowing optional fields such as AddressLine2 to be NULL and then implement a...

The short answer is NULL, the longer answer is to never allow that situation to arise in the first place because it’s as confusing as dividing by zero. In...

Gary Varga (10/24/2014)

---

I do like some of your ideas Peter but my concern would be the performance overhead. When updating a variably size number that is larger than the currently...

Coincidence has it this editorial came one a day after I was feeling strongly we miss a few important types in SQL Server.

Lets start with something very close to the...

I too am a developer, but also an accidental DBA (as is often the case in small software companies). It is understandable that those tasked in large organisations with keeping...

What are the reasons that prevent you from migrating those 2005/2008/2012 instances to 2014?

Mainly two things:

1. The licencing mess

2. Product segmentation

To me there seems not much to gain by upgrading...

The addition of try_DoSomething functions to SQL is like the worst route to take in combating the problem of unwanted exceptions.

Instead of implementing these simple two steps:

1. Force filter operations...

Microsoft seems totally marketing driven these last years, everything else like accessibility and usability be damned. I find it really sad, it could be miles ahead of everything very easily...

Gary Varga (8/29/2014)

---

peter-757102 (8/29/2014)

---

...We have made preparations for gathering all of these errors into a single place, with a single more advanced viewer and an alert system. We just haven't...

Application problems are not necessarily easier solved by logs from a software layer that sits at the lower end end of the architecture pyramid (the database being the foundation of...

Thank you for the article and especially the attention to the restrictions.

Which sadly brings me to stating my opinion that Microsoft spend a lot of time adding a near unusable...

mburbea (5/27/2014)

---

If you look at my github I included an update test script which should make it easier to test your functions. Simply add them to the function array on...

Because I have little time to perfomance test now, I will just hand over the code so someone can check it out and/or improve on it.

This is how the SQL...

Usman Butt (5/26/2014)

---

mburbea (5/25/2014)

---

For those looking for the fastest way to split 8k CSVs in SQL Server, I present hybrid.

Hybrid performs about TWICE as fast as Paul White's Split CLR...

The cloud is probably OK for anything that is NOT demanding steady performance for long periods of time. It has costs advantages for running short jobs like daily web crawlers...