I believe that Temporal Tables are under-used. They work on all SQL Servers since SQL Server 2016 SP1, including Azure SQL Database.
I’m not talking about #temp tables.

It is a way to store all changes to a table.
I use it on all Settings Tables, so that I can follow changes to the set-up.
I also use it on my Customer tables, so that I can see how customer data is edited.
If I want to see what CustomerID =1234 looked like on New Years day, I just run this

select * from dbo.customer for system_time as of '2020-01-01 00:00:00.0000000' where id=1234


It costs a bit of disk space, but that is just peanuts.
I get full auditing, without doing much work.
I like that…

da_DK
da_DK en_GB