Retrieve data at system time for multiple Temporal Tables

By Greg No comments

If you have multiple temporal tables that join together, can you retrieve the data from the temporal table at a specific point in time? We’ll find out by running a test. First up, let’s create 2 system versioned tables and put some data in them: Next, we’ll update both records which will add data to […]

What is Your “Why”?

By Greg No comments

Andy Leonard (@AndyLeonard) has asked this month on T-SQL Tuesday “Why do you do what you do?” I have two answers to this question. On one hand I do what I do because it pays the bills. I have a full time job working for a company here in Australia and it pays the bills […]