SDU Tools v26 is now available for download - added support for Fabric SQL Database

Just a heads-up that v26 of SDU Tools went out to SDU Insiders last week. If you haven’t used SDU Tools, they are just a large library of functions implemented in T-SQL. You can use them as a full library or use them as examples of code in work you are trying to do.

Fabric SQL Database Release

The main reason for this release (apart from the standard list updates for SQL Server versions, etc.) is to introduce a new target for SDU Tools. When you download v26, you’ll notice there are now three installation scripts, and three removal scripts. So, there are now versions for:

• SQL Server
• Azure SQL Database
• Fabric SQL Database

I’d been holding off Fabric SQL Database until I thought it was all pretty stable. It’s still in Preview but not likely to change much now. Almost everything that worked on Azure SQL Database still worked on Fabric SQL Database but there was one item that I needed to remove, mostly because the SWITCH statement isn’t supported on Fabric SQL Database. Otherwise, all the goodness from the Azure version is now working on the Fabric version.

We’re currently working on a Fabric SQL Warehouse version but that is going to take quite a bit more work. I’ll advise you when it’s ready.

Backwards Compatibility

As noted with the last version (v25), we stopped doing any testing on SQL Server 2008 and now test from SQL Server 2012 forwards. That will also give us the opportunity over time, to improve the code base where we can take advantage of many of the improvements added in 2012. There’s quite a bit of code to change.

Getting SDU Tools

You can find details about SDU Tools here: https://sdutools.sqldownunder.com

I hope you find the new version useful.

2025-09-30