Database Deployment with Terraform - The Basics
Learn the basics of using Terraform to declaratively specify how to configure resources in infrastructure.
2022-10-17 (first published: 2022-08-26)
9,284 reads
Learn the basics of using Terraform to declaratively specify how to configure resources in infrastructure.
2022-10-17 (first published: 2022-08-26)
9,284 reads
Deploy resources in Azure using reusable code with Terraform modules.
2022-10-10
10,119 reads
A short look at temporal tables and how to deal with the system generated historical tables.
2021-03-29
2,076 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
2,030 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,813 reads
How the JOIN operator works, the different types of JOINs and relevant information about joining tables.
2011-03-03 (first published: 2009-10-07)
47,094 reads
This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.
2010-10-25
13,637 reads
2009-05-19
12,874 reads
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
Hi everyone, In below code I am creating a table and inserting some english...
backup log to int run every hour. If a log init backup is run...