Terraform Commands
I realized I never created a post to show how to deploy Terraform from VS Code. I haven’t done that in a while because I don’t do it at...
2025-08-13
27 reads
I realized I never created a post to show how to deploy Terraform from VS Code. I haven’t done that in a while because I don’t do it at...
2025-08-13
27 reads
Logging is a necessity in the database world, well, the entire tech world. You need to know what is happening in and around your databases. It’s easy to setup...
2025-07-07
137 reads
I was sick of changing context in Azure Data Studio while cleaning up things discovered in our vulnerability assessments. Changing things via PowerShell I wanted to be cautious with...
2025-06-04 (first published: 2025-05-16)
408 reads
Regarding managing databases in the cloud, security should never be an afterthought. That’s where Azure Vulnerability Assessments, officially named Microsoft Defender, come in—they help you spot weak spots in...
2025-05-26 (first published: 2025-05-07)
413 reads
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database as an extension. It allows you to schedule PostgreSQL commands directly from your database, similar...
2025-05-19 (first published: 2025-04-24)
345 reads
This came up one day at my work when a developer was using it. I hadn’t used it before and thought I’d better check it out. It’s off by...
2025-04-28 (first published: 2025-04-11)
924 reads
I thought I didn’t care about linting, and lately, I haven’t written a lot of SQL, but for the SQL I do write, I have SQLFluff to help me...
2025-03-18
214 reads
This may or may not be helpful in the long term, but since I’m doing it to be super cautious, I figured I would blog about it. We migrated...
2025-03-31 (first published: 2025-03-14)
207 reads
Thank you to Deborah Melkin for hosting TSQL Tuesday this month! I’ve always considered mentoring and sponsorship very structured. Now, I wonder if they’re also small things we do...
2025-03-24 (first published: 2025-03-11)
6,585 reads
This is more complicated than using the Azure Migration method, but because it’s maxed out on resources for the last week in the east regions (and possibly central), and...
2025-02-10 (first published: 2025-02-09)
58 reads
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
You want the short answer? Well, the only antidote to knowledge stagnation is probably...
Hi, we have a few people who like to experiment on our prod sql...
Comments posted to this topic are about the item Guidelines and Requirements
Comments posted to this topic are about the item Copying Production Schema
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers