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,846 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,850 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,636 reads
SQL and the JOIN Operator
How the JOIN operator works, the different types of JOINs and relevant information about joining tables.
2011-03-03 (first published: 2009-10-07)
46,864 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,541 reads
2009-05-19
12,783 reads
Blogs
Cloud Formations – A New MVP Led Training Initiative
By Kamil
Hello, data friends! Let me spread a few words about the new MVP led...
Daily Coping 20 May 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 19 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Columnstore Index Limits in SQL Server 2019
Comments posted to this topic are about the item Columnstore Index Limits in SQL...
How to use Images in Power BI Report Builder
Comments posted to this topic are about the item How to use Images in...
How to handle sticks on column country1 and country2 columns ?
I work on sql server 2017 i have table data as below i need...
Ask SSC