System-Versioned Temporal Tables - A Case Study
A short look at temporal tables and how to deal with the system generated historical tables.
2021-03-29
1,000 reads
A short look at temporal tables and how to deal with the system generated historical tables.
2021-03-29
1,000 reads
Recently a customer asked me for help with setting up a test of an Azure SQL Database in the single database tier with Geo-Replication to work with Transparent Data Encryption (TDE) with a customer-managed key, also known as Bring Your Own Key (BYOK). It is very simple to do it when you use service-managed keys, […]
2020-07-21
1,639 reads
Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.
2011-05-27 (first published: 2009-01-01)
22,438 reads
How the JOIN operator works, the different types of JOINs and relevant information about joining tables.
2011-02-25 (first published: 2009-10-07)
46,123 reads
This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.
2010-10-25
13,350 reads
2009-05-19
12,537 reads
By Steve Jones
I started a poll today on the naming for future SQL Saturdays. You can...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Arun Sirpal
A quick post today, quite simply, the error message is: “code”: “ConflictingDatabaseOperation”, “message”: “Operation on server x and database y is in progress. Please wait a few minutes before trying again.” What...
Comments posted to this topic are about the item Easing Back to the Office
Comments posted to this topic are about the item Password Policy