Welcome to 2020, may I take you coat? How about your Customer Data?

That’s right, it’s now 2020, we’re already in the 2nd decade of the “new” millennium. A lot has changed in the last 20 years: High Speed Broadband (cough for most of us) is common place, Computers are faster than ever, cars are more economical, the polar icecaps are smaller (apparently), and a Happy Meal for McDonald’s isn’t 99p any more. There are some things that haven’t change too: The UK is still part of the EU (at time of writing), your neighbour’s dog still barks all night, and customer data is still wide open to theft from SQL injection. Yes,…

Continue reading

3 years later and STRING_SPLIT is still incomplete

Bit of a mini rant today I’m afraid. Many of us are aware that STRING_SPLIT was added in SQL Server 2016, and yet 3 years later it’s still incomplete. Why it’s incomplete There’s two major problems, in my view, with STRING_SPLIT. The first is that it doesn’t provide an ordinal position for the text extracted. For a string like ‘B,D,C,A’ this means you could just as easily get the rows A, B, C and D as you could B, D, C and A. When working with delimited data, knowing the ordinal position is often really important, and often a must….

Continue reading