SDU Tools v25 is now available for download

Just a heads-up that v25 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.

Backwards Compatibility

We’ve also tried to keep all the code working for all versions of SQL Server that we see clients using. That means from SQL Server 2008 to SQL Server 2022. We also have an Azure SQL DB version.

At times, that has been quite a challenge, mostly with keeping it working on older versions.

From 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.

Enhancements in this version

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

In v25, we’ve added or enhanced the following (new YouTube links included)

- returns all the dates in the calendar year, starting at the beginning of the year, and ending with the supplied date.
- returns all the dates in the financial year, starting at the beginning of the year, and ending with the supplied date. It takes a second parameter to indicate which month the financial year starts in.

Fixes in this version

We’ve also fixed a few things in this version, based upon feedback from users.

Error in Roman Numeral calculation corrected. (Thanks Jonathan Martin)

ListAllDataTypesInUse,ListColumnsAndDataTypes,ListMismatchedDataTypes, ListUseOfDeprecatedDataTypes,ListViewColumnsAndDataTypes, ListUserDefinedDataTypes all had incorrect length for char/nchar data types (Thanks Jacob Lyon)