sql for everyone
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 in Azure SQL DB. This post will guide you through setting up and querying diagnostic settings…
I missed the deadline because I was sick, but wanted to post about it anyway. So, here is my response to this invitation. Managing Agent Jobs It’s a short and sweet answer: Store your job definitions as code in GitHub—that’s my opinion. But in the…
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 drops across multiple subscriptions, so I started with a single subscription. I use Ghostty for my…
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 your database configurations before they become real problems. But do you always need them? Not necessarily.…
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 to using cron jobs at the operating system level. pg_cron on PG Flex is pretty easy…
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 default in SQL server, but why would you use it? TL;DR Setting XACT_ABORT ON is a…
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 format it. A friend of mine is big into SQLFluff and finally talked me into installing…
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 to Flex last week, and to be abundantly cautious, we’re putting the last single server backup…
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 for one another. In the past, I thought mentoring was one-on-one meetings with another person to…
Commenting out code is quick and easy with a keyboard shortcut: Win + / on Windows or Command + / on Mac. You can place your cursor anywhere on the line that you want to comment out, or you can select multiple lines to comment…