A Fine Slice Of SQL Server
I have the first of a two-part video up:
In this video, I walk through four categories of window function, plus a somewhat-related type of function in SQL Server. From there, I demonstrate how aggregate window functions and ranking window functions work.
The second part will come out next week and will cover the other types of window function. Otherwise, this was shaping up to be a 40-minute video and that’s a bit too long.
Leave a CommentRick Dobson lays out some common issues:
Most SQL bulk insert and SQL Server openrowset tutorials skip file access issues that can stop imports cold. Both the bulk insert statement and openrowset function rely on the SQL Server service account to read a source file. The SQL Server service account must have read permission on the file or its folder. It is also convenient to have read & execute as well as list folder content permissions. Also, non-standard source file locations (e.g., C:\Users\Public\Downloads) may not grant default read access to the SQL Server service account – always verify before use.
Click through for several recommendations, links to additional resources, and a few scripts along the way.
Leave a CommentBen Richardson creates a visual:
Ever wished you could see exactly how customers move through your sales funnel, or how costs flow across your business?
A Sankey Diagram makes those flows visible, showing not just totals but how values split and connect between categories.
In Power BI, the Sankey Diagram is available as a custom visual from AppSource, designed to reveal relationships and flow patterns.
There are specific times and places for Sankey charts. It requires having a natural flow in your data—that is, you need different states of data, those states should typically only “move” in one direction, you have paths to get from one state to another, and there is enough variety in pathing that not all of the data is going to the same location. The more of these rules you violate, the less useful a Sankey diagram is.
Leave a CommentBrent 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.
Leave a CommentMarco 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.
Leave a CommentAndy 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.
Microsoft 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.
Leave a Comment