I explain the ups and downs of a cohesive, consolidated, version-agnostic Books Online for SQL Server.
Monthly Archive: February 2017
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.