Problem with learning on one's own [dt]ime is you can really only barely scrape the surface of all these techs going through books and training courses. The ecosystem is complicated...

Can't tell you how often I've expressed interest in my company investing in developing those skills only to get a response akin to "that sounds great. So if you can...

Yep, you are correct. Thanks for adding this!

I had a similar difficulty in explaining why I felt procs were preferable to EF. My initial reaction was very strongly in favor of procs over EF, although after calming...

The problem with this solution is that the UDF assumes the same order of rows as the substrings in the input string, while the documentation for string_split says the...

Thank you for the responses, and forgive any naivitee I may have on the matter; this was someone else burning firehose from which I was asked to drink.

I guess...

Thanks for the post! I just did the whole Microservices analysis thing too, and here's what I took away from it.
We have a bunch of shared databases which are...

Looks interesting, but the code is a bit of a jumble and doesn't seem to run without a lot of cajoling.

Thanks for the post. I thought fast_forward cursors were the exception to the rule of cursors being slow because it's only supposed to query the data once, and it only...

Hold that thought; I may have actually just written my statement wrong.

Thanks so much for the post. Interestingly enough, the subject of using extended properties for documentation came up just last week at work. As with most new features I learn...

Nice post. Now if someone could just figure out how to do this with procs that return multiple result sets...