Post image

Basic Availability Groups in SQL Server 2016

One of the new features in SQL Server 2016 Standard Edition, which may appeal to users of the deprecated Database Mirroring feature, is Basic Availability Groups, a variation of Availability Groups found in the Enterprise Edition. At a high level, Availability Groups are an amalgamation of Database Mirroring and Windows Failover Clustering. The Windows Servers
-> Continue reading Basic Availability Groups in SQL Server 2016

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. 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
-> 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

glasses on a book

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

An Introduction to Temporal Tables in SQL Server 2016 using a DeLorean

In 1983, Cyndi Lauper recorded the Billboard chart-topping single, Time After Time, which went on to win the hearts of many lovers in the three decades since then. In 1985, Marty McFly used a DeLorean, invented by scientist Doc Emmett Brown, to travel back to 1955, where he met and interacted with his parents, Lorraine
-> Continue reading An Introduction to Temporal Tables in SQL Server 2016 using a DeLorean

Post image

Time to upgrade your SQL Server 2005 instance

Last edited on 17 November 2016. As you know, SQL Server 2005 is now over ten years old. Microsoft has helpfully provided a list of ten reasons why you should be upgrading from SQL Server 2005. The question is not whether you should be upgrading it (you should, by the way), but to which version? Microsoft even
-> Continue reading Time to upgrade your SQL Server 2005 instance