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
110 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
110 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
304 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)
486 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)
499 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)
454 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)
1,035 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)
264 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,614 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
404 reads
You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles are granted to it. I had to go fishing to find all the grants to...
2025-02-12 (first published: 2025-01-27)
269 reads
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
By Steve Jones
This month I want to look at a few of the things I’ve seen...
By SQLPals
SQL Server 2016 Has Reached End of Support. Now What? On...
Wa:083849450961 Jl. Pangeran Diponegoro No.296, Brebes, Kec. Brebes, Kabupaten Brebes, Jawa Tengah 52212
Wa:083849450961 Jl. Jend Sudirman No.46, Curah, Slawi Wetan, Kec. Slawi, Kabupaten Tegal, Jawa Tengah...
Comments posted to this topic are about the item PostgreSQL 19 Is Late
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers