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,610 reads
Wagner Crivelini
TDE BYOK and Geo-Replication in Azure SQL DB
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,755 reads
Cursors for T-SQL Beginners
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,519 reads
SQL and the JOIN Operator
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,544 reads
Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods
This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.
2010-10-25
13,434 reads
2009-05-19
12,674 reads
Blogs
A Live Conference Experience at Data Minds Connect 2021
By Steve Jones
Last week I was privileged to attend a live conference in Belgium. dataMinds Connect...
Daily Coping 25 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
A New Form of Address: Mx
By Steve Jones
When I was presenting at the dataMinds Connect conference, I called on someone in...
Forums
Need advice with backup plan and transaction log file
I am missing something I guess. Here's our backup Plan Full backup weekly Differential...
cannot generate SSPI context
We have one user who face this issue while connecting to SQL server ''Cannot...
Database Corruption - LOB
Hello, I have recently inherited a SQL 2012 database (no backups available), running in...
Ask SSC