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)
12,715 reads
Learn the basics of using Terraform to declaratively specify how to configure resources in infrastructure.
2022-10-17 (first published: 2022-08-26)
12,715 reads
Deploy resources in Azure using reusable code with Terraform modules.
2022-10-10
11,229 reads
A short look at temporal tables and how to deal with the system generated historical tables.
2021-03-29
2,752 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,321 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,962 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,362 reads
This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.
2010-10-25
13,807 reads
2009-05-19
13,035 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers