Detecting changes on SQL Server Temporal Changes

SQL Server temporal tables are a great way to build data audit and to see the state of data at a point in time. However, if you want to calculate what changed over a period of time, it gets a little trickier. Keep reading to see how....

October 29, 2021 · 5 min · lpains

Enforce read only access in SQL Server queries

If you run dynamic or configurable SQL queries and you need to ensure that writes are denied, this post is for you....

July 7, 2020 · 2 min · lpains