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.
Leave a CommentMicrosoft 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 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.
Koen Verbeeck performs an installation:
I already had a virtual machine in Azure, running SQL Server 2025 CTP 2.0 (which uses a pre-made image). I explain how to set that one up in the article Install SQL Server 2025 Demo Environment in Azure. But I wanted to use the latest preview, which is Release Candidate 0 at the time of writing. Unfortunately, there’s no image available (yet?), so I had to do it the old-school way: installing SQL Server manually.
Read on to see how to do it, as well as a few extra things necessary to make everything work well in Azure.
Leave a CommentReitse Eskens check the state of the art:
What’s new in SQL 2025 is that the team behind SQL Server 2025 has addressed an issue that I’ve encountered once or twice as well. If you start an extended event, it will run until you stop it. Yes, you have to manually stop it. If you don’t, it will stop eventually. Together with some other services, because the disk space has run out. In my case, I was fortunate that the servers were monitored and alerts were triggered due to low disk space.
In this new version, starting with Release Candidate 0 (RC0), you can configure the duration.
Click through for a demo, as well as current limitations (generally around this not being in the UI yet).
Comments closedPriya Sathy has an announcement:
The first release candidate (RC0) of SQL Server 2025 is now available. As we move toward general availability, our focus shifts to delivering enhanced stability, performance, and product improvements based on your feedback.
There are a few new features that Priya specifies in the post, so check those out. This also puts us on track for a GA delivery right around conference season.
Comments closedKoen Verbeeck writes a regular expression:
I need to do some data validation in our SQL Server database. However, the validation rules are too complex for the T-SQL LIKE function, and I can’t seem to get it done either with PATINDEX or something similar. I’d like to use regular expressions as they’re more powerful. SQL Server 2025 now has a regex function regexep_like to use regular expressions.
Read on for some examples, advice on validating e-mail addresses, and more.
Comments closedRandolph West clears up a few misconceptions about SQL Server Management Studio 21’s installer:
There’s been some confusion lately about the SQL Server Management Studio (SSMS) installation process for version 21.
Before Microsoft released SSMS 21, you had to download an installer file for each release (ever since SSMS was released as a standalone product with v16). This file eventually grew to be over 1GB, which is a significant download, especially in the case of a minor update.
With SSMS 21, Microsoft changed SSMS to use the Visual Studio installer.
Read on to learn more about the ramifications of this decision. And there is still a way to install SSMS 21 in a secure environment without outbound internet access, although it does require a few more steps in addition to “download executable and then deploy executable to other machines.”
Comments closedPhil Yang lays out how to make a migration:
Apache Kafka has made a landmark shift in KIP-500 with the introduction of Kafka Raft (KRaft) mode, eliminating the dependency on Apache ZooKeeper for metadata management. With KRaft, the Kafka nodes themselves can be configured as KRaft controllers – which allow for metadata management and leader elections to work all within just Kafka, resulting in significant performance improvements. This cemented KRaft’s status as the metadata management protocol for Kafka moving forward.
This blog will guide you through the importance of this transition, what migrating from ZooKeeper to KRaft entails, and how we, at NetApp Instaclustr, make this seamless with our automated, streamlined process that is built into our platform.
Click through to see how you can update your own clusters, whether you’re using the Instaclustr service or not.
Comments closedKoen Verbeeck doesn’t believe in import-export businesses:
I want to try some of the new features in SQL Server 2025. I’ve installed the CTP 2.0 preview on a virtual machine, and now I need some sample databases to play around with. Can I use the AdventureWorks database like in previous versions of SQL Server?
The answer is yes, and read on for the process.
Comments closed