BUG FIXES:

N/A

NEW FEATURES:

1. tSQLt can now be installed using DACPACs as well as the original tSQLt.class.sql script. Note: Unlike the original tSQLt.class.sql script, DACPACs are SQL Server version specific.
2. tSQLt.FriendlySQLServerVersion function reports the SQL Server Version as a string with commonly used moniker e.g. 2008R2 or 2019.
3. tSQLt is now certified for SQL Server on Linux.

MISCELLANEOUS:

1. Created GitHub Action for building and testing tSQLt on MSSQL 2017 and 2019 using Redgate Spawn.
2. Refactored Azure DevOps Pipeline to use more powerful VMs and azcli to create the SQLVM with a bicep file.
3. Migrated parts of the tSQLt build from ant to PowerShell.
4. Prototyped using AKS (Azure Kubernetes Service) to host MSSQL 2014, 2016, 2017, and 2019.
5. Prototyped Facade dacpacs for use in Visual Studio when developing tests with tSQLt. Ultimately we chose a full tSQLt dacpac for this work, but continue to retain the original Facade code and tests.

Release: V1.0.7682.21917

BUG FIXES:

1. Fix sysname casing for case-sensitive databases. Fixed by Trygve Wastvedt (https://github.com/twastvedt).
2. Fixed issue in tSQLt.Private_GetFullTypeName not handling fractional seconds precision on date and time types. Fixed by saperry (https://github.com/saperry).

NEW FEATURES:

1. FakeFunction now accepts non-functions as data sources for example tables or SELECT statements. Contributed by Dmitrij Kultasev (https://github.com/dkultasev).

MISCELLANEOUS:

1. For tSQLt contributors: allow SQL Server Authentication for build

Release: V1.0.7597.5637

BUG FIXES:

N/A

NEW FEATURES:

1. The tSQLt CLR is now signed with a new key:
   
   Public key (hash algorithm: sha1):
   
   0024000004800000940000000602000000240000525341310004000001000100b9af416ad8dfedec08a5652fa257f1242bf4ed60ef5a7b84a429604d62c919c5663a9c7710a7c5df9953b69ec89fce85d71e051140b273f4c9bf890a2bc19c48f22d7b1f1d739f90eebc5729555f7f8b63ed088bbb083b336f7e38b92d44cfe1c842f09632b85114772ff2122bc638c78d497c4e88c2d656c166050d6e1ef394
    
   Public key token is e8fff6f136d7b53e
   
2. Several improvements to the build process, including switching from NAnt to Ant
3. New prepare server process (this fixes all installation issues with 2017 and 2019) Before installing tSQLt, you can now run the PrepareServer.sql that is part of the tSQLt.zip download.
   It automatically enables CLR and installs a server certificate that allows the installation of the CLR.
   There is no need to disable strict CLR security on the server nor do you need to modify database security settings.
   Executing the script requires SA permissions, but needs to be done only once per server. Reminder: If you are using the tSQLt.NewConnection feature,
   you need to execute tSQLt.EnableExternalAccess after each installation of tSQLt.
4. Annotations tSQLt now allows for test case annotations to modify test behavior. The annotations implemented so far are:
   
   --[@tSQLt:MaxSqlMajorVersion](@MaxVersion)
   Skips the test if the major version of SQL Server is > @MaxVersion
   
   --[@tSQLt:MinSqlMajorVersion](@MinVersion)
   Skips the test if the major version of SQL Server is < @MinVersion
   
   --[@tSQLt:SkipTest](@SkipReason)
   Skips the test and reports @SkipReason as reason in the output
   
5. Implemented a CI pipeline for tSQLt itself in Azure DevOps