hellosqlkitty

Josephine Bush is a Data Platform MVP and has over 10 years of experience as a Database Administrator. Her experience is extensive and broad-based, including in financial, business, and energy data sectors using SQL Server, MySQL, Oracle, and PostgreSQL along with Azure and AWS. She is a Microsoft Certified Solutions Expert: Data Management and Analytics. She holds a BS in Information Technology, an MBA in IT Management, and an MS in Data Analytics. She presents at SQL conferences and user groups around the world. She is the leader of the Boulder SQL user group. She blogs on sqlkitty.com and you can reach her on Twitter @hellosqlkitty.

Blog Post

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

64 reads

Blog Post

Query multiple Azure SQL Databases

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: )

431 reads

Blog Post

Azure Vulnerability Assessments

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: )

444 reads

Blog Post

Using Cron in Postgres Flex

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: )

388 reads

Blog Post

Why use XACT_ABORT?

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: )

967 reads

Blog Post

Using SQLFluff

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

314 reads

Blog Post

Drop roles in Postgres

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: )

238 reads

Blogs

Restore SQL Server Database to an OrbStack Container

By

In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...

Day of Data Baton Rouge Slides and Code

By

Thanks to everyone for attending my talk today at Day of data Baton Rouge...

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

By

Here’s the scenario: one of my SQL Server instances migrated to the DR array....

Read the latest Blogs

Forums

PowerBI Question - Data Sources

By Brandie Tarvin

I don't see a PowerBI forum, so I'm posting here. I have a need...

SQL Server Certificates

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Certificates

Connect an Azure Function to Azure SQL database Using a Managed Identity

By Kunal Rathi

Comments posted to this topic are about the item Connect an Azure Function to...

Visit the forum

Question of the Day

SQL Server Certificates

Which of these is not true for certificates used for SQL Server connections?

See possible answers