As a database developer, when I started using Power BI, I was concerned about it retrieving reams of data only to perform transformations downstream. The Power Query editor misleads us into thinking the retrieval and transformations are applied sequentially. Thanks to Query Folding, that’s not usually the case. And that gives us more power to […]
If you’re building a large INSERT statement using VALUES, you might find yourself hitting the limit of 1000 rows, for example: INSERT statement exceeds the maximum allowed number of 1000 row values Folks may tell you there are better ways to solve the issue, but the likelihood is that you’re doing it this way for a particular reason. […]
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 […]
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. […]
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 […]
Andy Brownsword 