In this part of my "using a calendar table" series, I talk about filling gaps and identifying gaps and islands.
Monthly Archive: April 2021
It seems a lifetime ago I wrote about creating a calendar table; now I've started a new series showing how to use the calendar table. In the first installment, I deal with business day problems.
SQL Server 2019 Cumulative Update #10 is available, with 63 enhancements. The build number is 15.0.4123.1.
A not exactly innovative post about using Temporal Tables functionality to automatically update a LastModified column.