A Fine Slice Of SQL Server
Brent Ozar checks out a new DMV:
SQL Server 2025 introduces a new sys.dm_os_memory_health_history view to make it easier for meatbags like you and robots like Copilot to know if the SQL Server has been under memory pressure recently.
To show how it works, let’s run a bunch of simultaneous high-memory-grant queries in the Stack Overflow database:
Read on for a demonstration of how it works.
Comments closedMarco Russo and Alberto Ferrari grab a calendar:
Since its first release in 2010, DAX has had a set of time intelligence functions to simplify calculations like year-to-date, year-over-year, and so on. However, the calculations only supported the Gregorian calendar, without addressing similar requirements for other calendars, such as the 4-4-5, ISO, and many other non-Gregorian calendars. With the classic time intelligence, the columns of the Date table were unknown to the time intelligence functions, with the only exception of the date column in the Date table, typically Date[Date].
Click through to see what Marco and Alberto have come up with.
Comments closedMicrosoft has a new release candidate:
Currently SQL Server 2025 (17.x) Preview includes features available through release candidate (RC) 1.
In addition to features announced previously, RC 1:
- Fixes known issues that were present in previous preview releases.
- Introduces feature improvements.
Click through for the changes. There aren’t a huge number of updates in this candidate, and it came out a bit quicker than I thought it would, with RC0 dropping on August 25th. Given that Ignite isn’t until November 18th, that does still give a fair amount of time for an RC2 to come out, and it’ll be interesting to see if they go that long or release SQL Server 2025 RTM earlier than Ignite.
Comments closedAndy Levy needs an older version of dbatools:
I don’t recall where this came up (probably in SQLSlack), but I had a need to install an older version of
dbatoolsto test something related to loading thedbatools.librarylibrary/dependency.
Read on to see how Install-Module won’t quite cut it because it doesn’t bring in the older versions of dependencies. But there is an alternative.
Mike Robbins has a list and checks it twice:
In Part 1: Getting Started with Markdown for Technical Writers, I introduced the basics of Markdown, including how to format both ordered and unordered lists. This article builds upon that foundation, providing everything you need to know about using lists in Markdown, from basic syntax to advanced formatting techniques.
As a technical writer, understanding how and why to use lists in Markdown isn’t just about syntax. It’s about clarity, structure, accessibility, and intent.
Read on to see how to create ordered and unordered lists, as well as several tips around when to use each and appropriate nesting of lists.
Comments closedMarco Russo and Alberto Ferrari look at a new feature in DAX:
Although DAX is a functional language, it did not previously offer the option to let users define their own functions. Starting from the September 2025 version, it is possible to define functions, which are parametrized expressions that can be reused throughout the entire semantic model. This article explains how the functions work. Watch the related video to see the user interface for defining functions.
Click through for more information, and also check out SQLBI’s DAX Lib website for a few examples of the types of user-defined functions you can create.
Comments closedA lot of people have heard of in-memory/memory-optimized tables in SQL Server. In our experience, however, not many people are using this feature (which first appeared in SQL Server 2014) in their production environments. This introduction will explain what in-memory tables are and how to use them effectively. This post should help guide your decision about using this feature in your production environment.
For the demos below I’m using the Stack Overflow database, you can go grab a copy here. It comes in various sizes, and a small one is perfectly acceptable for this test. We’re only going to deal with 100k rows of data. Once we have the database available and attached to a test instance of SQL Server, we have a few things to do.
I would heavily caution people before going down the road of memory-optimized tables in a user database. The primary benefit is typically not read speed, but rather write speed. There are also so many restrictions around what you are allowed to do, especially if you want to take advantage of memory-optimized stored procedures. IMOLTP puts heavy restrictions on anything involving cross-database querying (and tempdb is a different database, remember!), to the point that I’ve struggled to implement it in brownfield environments. Ultimately, it’s one of those really neat-sounding features that has too many restrictions to be really useful.
Comments closedStefanie Janine Stölting has a new release of pgsql_tweaks:
I decided to make this the 1.0 Version. The First commit is from 2017-08-11, the extension is now more than eight years old.
Click through for the updates in this version and a link to fetch the code.
Comments closedAdam Saxton has a list of updates for us:
Welcome to the Fabric September 2025 Feature Summary! This month’s update is packed with exciting enhancements, such as new certification opportunities, the Power BI DataViz World Championships at FabCon Vienna, and major advancements in the Fabric Platform. Highlights include the Parent-Child Hierarchy in the OneLake catalog, the general availability of the Govern Tab and Domains Public APIs and expanded Microsoft Purview protection and data loss prevention policies. Dive in to discover the latest improvements designed to empower your data experience.
Click through for a few dozen items.
Comments closedBen Richardson builds a carousel:
If you’ve ever tried to cram too many charts onto one report page, you know what happens.
The page gets cluttered, users don’t know where to look, and the story you’re trying to tell gets lost.
Carousel buttons fix that problem.
Instead of stacking visuals side by side:
You place them in the same spot and let people flip through them like slides.
It feels cleaner, takes up less space, and keeps the audience focused.
Click through to see how it works. Note that carousels can be quite useful, but they also go against one of the tenets of dashboard design: glanceability. If I need to click, drag, scroll, or otherwise manipulate the dashboard before I can see the information I need to act, it’s not glanceable—I cannot gather relevant information at a glance and act upon it.
In other words, if I’m giving somebody an interactive Power BI report with the intent that the person will dig into results, then a carousel can be quite reasonable. But if I’m creating a dashboard that should be up most of the time and available for people to see, carousels aren’t a great call.
Comments closed