Tip : Auditing Who Changed Temporal Table Data in SQL Server

For T-SQL Tuesday #87, I talk about two shiny new toys in SQL Server: STRING_SPLIT() and STRING_AGG().

Tip : Managing Temporal Table History in SQL Server 2016

I show how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.

In an effort to make leading wildcard searches sargable, I play around with a trigram-type implementation in SQL Server.