SQL Server Workgroup Cluster FCM Errors

Background One of the new features of SQL Server 2016 is the ability to use SQL Server with Failover Cluster in a workgroup rather than joined to Active Directory. When working with SQL Server and Failover Clustering in a workgroup, many of the abilities that are normally used with Active Directory are no longer available,…

0

SQL 2016 – Temporal Tables – Triggers and Historical Data Tidbits

Hello again and welcome back to the series on Temporal Tables! Today we will take a look at two common questions.  What happens when I put a trigger on a Temporal Table and can I back populate the historical table?   Setup First thing’s first, let’s setup a demo.   Triggers Now, let’s add a…

1