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
Wagner Crivelini
Database Deployment with Terraform - Modules
Deploy resources in Azure using reusable code with Terraform modules.
2022-10-10
10,119 reads
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
2,076 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
2,030 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,813 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)
47,094 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,637 reads
2009-05-19
12,874 reads
Blogs
Daily Coping 26 Jan 2023
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Working With Tags in FlashArray using PowerShell
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
Using SQL Data Compare from the Command Line with a Project
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
Forums
SQL Table Issue
Hi everyone, In below code I am creating a table and inserting some english...
Backup Log Init run again by mistake manually.
backup log to int run every hour. If a log init backup is run...
Ask SSC