Join me at SQL Trail 2021 to hear the next thing about Temporal Tables

I’ve had the privilege of presenting all over the world about temporal tables in SQL Server including the United Kingdom, Canada, and the United States. The theme of the session has always been Back to the Future, which is the greatest time travel movie ever, but I haven’t changed the talk much since I debuted
-> Continue reading Join me at SQL Trail 2021 to hear the next thing about Temporal Tables

Glasses, calculator, tablet, white neat desk

System-versioned ledger tables: the next step

In the first post of this series, we learned about a new type of system-versioned table that also works at the database level and introduces a mechanism that demonstrates whether your database has been tampered with. Very simply, if the cryptographic hash does not match what is in the off-site digest, your database has been
-> Continue reading System-versioned ledger tables: the next step

Glasses, calculator, tablet, white neat desk

Introducing system-versioned ledger tables

As long-time readers of this blog know, I’m a big fan of temporal tables, also known as system-versioned temporal tables. Until recently, temporal tables were synonymous with system-versioned tables, but all that changed a short while ago with the introduction — in Azure SQL Database — of system-versioned ledger tables. This new series of posts
-> Continue reading Introducing system-versioned ledger tables

Black and white Texas Instruments calculator

Temporal Tables, and how to deal with computed columns

Long time readers will know I’m a big fan of Temporal Tables since their introduction in SQL Server 2016. Thanks to my friend Erik Darling (blog | Twitter), I can share a tip when dealing with computed columns. As I say in my Back to the future with Temporal Tables session, there are several limitations
-> Continue reading Temporal Tables, and how to deal with computed columns

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