New Job -> Week 3 -> Creating Alerts - sqlkitty
It's week three at my new job. I want to ensure I see issues with my Azure SQL Databases before someone else does so I'm setting up alerts.| sqlkitty
It's week three at my new job. I want to ensure I see issues with my Azure SQL Databases before someone else does so I'm setting up alerts.| sqlkitty
Category: terraform| sqlkitty
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 work. We have Azure DevOps pipelines to handle that, but I like to test my code…| sqlkitty
It's week four at my new job. I want to audit my Azure SQL Databases to fix performance issues and be aware of possible breaking changes.| sqlkitty
sql for everyone| sqlkitty
This post walks you through settings up error logging and auditing for your Azure SQL DBs, which is easy with diagnostic settings.| sqlkitty
I say store them in GitHub, no matter where you are using an agent these days, whether you are still on SQL Server or a cloud variety.| sqlkitty
It's quite easy to query multiple databases in Azure SQL Database with PowerShell. Gone are the days of having to context switch in a GUI.| sqlkitty
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.…| sqlkitty
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…| sqlkitty
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… The post Using SQLFluff appeared first on sqlkitty.| sqlkitty
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… The post Save Azure PostgreSQL Backup to Storage appeared first on sqlkitty.| sqlkitty
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… The post TSQL Tuesday #184: Mentoring and Sponsorship appeared first on sqlkitty.| sqlkitty
Make your life easier with a keyboard shortcut to comment out a line or lines of code using win + / or command + /| sqlkitty
I wondered why myself as I hadn't used it until I saw a developer using it a while back, and then I wanted to know the ins and outs.| sqlkitty
