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
55 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
55 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
233 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)
427 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)
437 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)
386 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)
957 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)
212 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,592 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
281 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)
229 reads
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
I’ve been doing storage load tests for SQL Server for a long time, both...
Hi all Can I get some perspective from the community please on performing in-place...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers