A Fine Slice Of SQL Server
In this video, I take you through some of the limitations of window functions in SQL Server, including the lack of intervals and oddities around the APPLY operator.
Intervals would be a really powerful addition to SQL Server’s window function capabilities, but I’m not going to hold my breath for them.
Leave a CommentAaron Bertrand extends a prior article:
In my previous tip, Managing Unused Indexes in SQL Server Availability Groups – Part 1, I showed how I use dynamic SQL to gather index usage statistics for a given table from all replicas in an availability group. Knowing the usage from all workloads is definitely better than focusing on only the primary or a single secondary. But what if I want to make more informed decisions, incorporating row counts, size, and index columns into this output?
Read on to see how you can incorporate this additional information.
Leave a CommentJovan Popovic announces that JSONL format support is now generally available in Microsoft Fabric:
The OPENROWSET function that can read JSONL format empowers you to easily read and ingest JSONL files – for example log files, social media streams, machine learning datasets, configuration files, and other semi-structured sources. With the versatile OPENROWSET T-SQL function, you can reference and query JSONL files as if they were tables, eliminating the need for manual parsing or complex transformation steps.
Read on to see examples of how to ingest and use data in the JSON Lines format.
Leave a CommentKevin Hill wraps up a series on what to do when “SQL Server is slow”:
This post will lean heavily on the First Responder Kit from Brent Ozar, sp_WhoIsActive from Adam Machanic and others. They took what Microsoft provides and made them better. Hundreds or thousands of hours of work to make FREE things for you to use.
This is the most complex blog I’ve ever written. Your experiences may differ, and my code samples might have some bugs. Test first.
Kevin is trying to sum up a lot of material in a blog post, but this serves as a pretty good starting point for people who don’t know where to begin. One of the key takeaways from the post, and the entire series, is to have a plan in place. Regardless of whether you use what Kevin has as-is or make your own modifications, knowing what to do and how to do it will save a lot of time and energy when you need to act.
Leave a CommentJon Vöge walks through a few folder strategies in Microsoft Fabric:
Every time I see a new Fabric Data Platform, I see a new way of using folders. Almost.
Ranging from no folders at all, to using folders to segregate item types, over folders for bronze/silver/gold layers, to even seeing setups of them being used for DEV/TEST/PROD.
I won’t claim all of these to be equally good. But the point is that there are many different approaches you may take.
Read on for a few strategies, including ones Jon would recommend avoiding.
Leave a CommentAnnamarie Van Wyk demonstrates how to use field parameters to slice data in Power BI:
If you’ve ever built a Power BI report and found yourself duplicating charts for daily, weekly, monthly, or yearly views — you’re not alone. It’s one of the most common (and frustrating) dashboard challenges: “Can we see this by day? Actually, make it by week. No wait — what about monthly?”
Instead of building five versions of the same visual, you can do it all with one — thanks to Field Parameters.
Read on to see how it all works.
Leave a Comment