Categories
SQL Server

Formatting T-SQL in SSMS: It’s About Time

Dealing with endless formats for SQL scripts is a special type of pain you get to enjoy as a data developer. With the arrival of SSMS v22.7 last week, we have a solution in the form of a T-SQL formatter which is now available in preview. What’s new? The ability to format scripts in the […]

Categories
T-SQL Tuesday

T-SQL Tuesday #199 – Back to the Future IV: On-Premises

This month the invitation from Koen asks what would happen if we came back from the cloud. Back to On-Prem. Cloud solutions have sliders which magically reduce downtime, performance issues, and account credit. When you build it, infrastructure and platforms are your challenge, and you get one shot to right-size it. Capacity, resilience, capabilities. They’re your challenges to solve. […]

Categories
SQL

KQL: A SQL Developer’s First Look

Someone drops a KQL query in your lap and says “you know SQL right?”. Honestly, it’s different enough to trip you up, but similar enough that you’ll pick it up quickly. In this post I want to touch on what KQL is, why it matters, and show how familiar (or different) it is compared to […]