Speaking at SQL Saturday Oregon

SQL Saturday Oregon — in the city of Portland — is taking place next weekend on Saturday November 2nd, 2019, and I’ll be presenting a revised edition of my session “Back to the Future with Temporal Tables.” It’s the Saturday before PASS Summit 2019 which is once again in Seattle. I’m giving two sessions there
-> Continue reading Speaking at SQL Saturday Oregon

Speaking at SQLBits next month

As I mentioned a couple of weeks ago, I will be presenting for the first time at SQLBits in London, on Saturday 24 February 2018. My session is called Back to the future with Temporal Tables. Here is the abstract: Back to the Future is the greatest time travel movie ever. I’ll show you how
-> Continue reading Speaking at SQLBits next month

Post image

Speaking at SQLSaturday #635 in Vancouver this weekend

This coming weekend, at SQLSaturday #635 in Vancouver BC, I will be presenting a brand new talk about Temporal Tables, one of my favourite features of SQL Server 2016+ and Azure SQL Database. If you are in the area, and still have not decided to attend, I strongly recommend making some time to check it
-> Continue reading Speaking at SQLSaturday #635 in Vancouver this weekend

Hidden

Temporal Tables and Hidden Period Columns

In my November 2015 post, An Introduction to Temporal Tables in SQL Server 2016 using a DeLorean, I wrote: The HIDDEN property is optional and will hide these columns from a standard SELECT statement for backward compatibility with our application and queries. You cannot apply the HIDDEN property to an existing column. It turns out
-> Continue reading Temporal Tables and Hidden Period Columns

Temporal Tables and History Retention

I’m a huge fan of Temporal Tables in SQL Server 2016. I first wrote about them, in a four-part series in November 2015, before SQL Server was even released. I don’t always get this excited about new features. However, it has some limitations. As part of this week’s T-SQL Tuesday, hosted by the attractive and
-> Continue reading Temporal Tables and History Retention

Post image

Temporal Tables in Azure SQL Database

In the latest Microsoft Azure newsletter I received last week was this most excellent news: Azure SQL Database Temporal Tables generally available Temporal Tables let customers track the full history of data changes in Azure SQL Database without custom coding. Customers can focus data analysis on a specific point in time and use a declarative
-> Continue reading Temporal Tables in Azure SQL Database

Temporal Tables – When To Use Them

This is the final part of my Temporal Table series. You can read parts one, two and three here. Last week I demonstrated how to modify temporal tables in SQL Server 2016. This week I’m answering a very simple question. When should you use Temporal Tables? I see two main reasons for using this feature:
-> Continue reading Temporal Tables – When To Use Them

Modifying Temporal Tables – A Primer

This is part three of the Temporal Tables series. You can read parts one and two here. Last week I demonstrated how temporal tables in SQL Server 2016 work. If you have implemented a history table—populating it with triggers or stored procedures—it works the same way. This week, we are going to look at how
-> Continue reading Modifying Temporal Tables – A Primer

Temporal Tables Under The Covers

(This is a more technical post than last week. If you are not familiar with SQL Server internals, I will not be upset if you skip it. Otherwise, let’s dive in.) Last week I introduced the SQL Server 2016 feature known as System-Versioned Tables, or Temporal Tables. I explained how to convert an existing table
-> Continue reading Temporal Tables Under The Covers