Join me next week at my first GroupBy session
2021 has been the year people want to learn about Temporal Tables, it seems. Not only am I speaking at the SQL Trail conference next… Read More »Join me next week at my first GroupBy session
Home »
Temporal Tables
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.… Read More »Join me at SQL Trail 2021 to hear the next thing about Temporal Tables
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… Read More »System-versioned ledger tables: the next step
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… Read More »Introducing system-versioned ledger tables
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… Read More »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… Read More »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.… Read More »Speaking at SQLBits next month
Welcome to 2018
I have been working on a new information session, which I’m hoping to deliver this year. It’s about one of my favourite topics: dates and… Read More »Welcome to 2018
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… Read More »Speaking at SQLSaturday #635 in Vancouver this weekend
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… Read More »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… Read More »Temporal Tables and History Retention
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… Read More »Temporal Tables in Azure SQL Database
Temporal Tables – When To Use Them
Last edited on 18 December 2019. This is the final part of my Temporal Table series. You can read parts one, two and three here.… Read More »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… Read More »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… Read More »Temporal Tables Under The Covers