I’m using SQL and KQL to solve Advent of Code puzzles this year. It’s an annual event in which participants solve a series of increasingly complex challenges.
This blog post will show you how to find and affect the default Extended event file target’s path.
I write about how to triage the Scalar UDFs in your environment. This is probably the final article in this series.
In this longest post in the series, I’ll show you how you can fix the problems with Scalar UDFs.
Continuing the series, we’ll examine how Scalar functions are terrible for performance.
Have you ever encountered a situation where you mark the constraint as trusted, but the next day, it’s back to untrusted again? This blog post will help you find the cause.
Consultants hate me for this one weird trick. Because I’ll be uncovering all the mess Scalar functions can cause in a series of articles.