Database Deployment with Terraform - The Basics
Learn the basics of using Terraform to declaratively specify how to configure resources in infrastructure.
2022-08-26
7,481 reads
Wagner Crivelini
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,943 reads
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,933 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,733 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,991 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,587 reads
2009-05-19
12,819 reads
Blogs
Restore HEADERONLY and FILELISTONLY
By gbargsley
Good day reader. This post is coming to you from a busy week in...
DevOps From Redgate
In a few weeks at the PASS Data Community Summit, I’ll be joining several...
Daily Coping 4 Oct
By Steve Jones
Today’s coping tip is to free up time by canceling any unnecessary plans. I....
Forums
Bệnh thủy đậu: Nguyên nhân, triệu chứng, biến chứng và cách điều trị
Bệnh thủy đậu là bệnh lành tính, không có triệu chứng nặng nề ngoài...
Where to Buy Sugilite Gemstone for Spiritual healing powers
Sugilite Gemstone Bertoua Savanna Local Miners (BSLMgold), Sugilite is one of the major love...
How to buy diseased free Ox/Cow Cattle Gallstone
Bertoua Savanna Local Miners (BSLMgold) After extracting the gallstones from the cattle's intestines they...
Ask SSC