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

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

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

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

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

924 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

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

216 reads

Blogs

Demystifying Fabric Workspaces: The Nerve Center of Your Data Universe

By

It always starts the same way. You open your laptop on a Monday morning,...

Azure Networking: Designing for Change

By

Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...

The Case of the Forgotten Compatibility Mode – Scooby Dooing Episode 3

By

Like any good mystery, some SQL Server problems look spooky on the surface but...

Read the latest Blogs

Forums

SQL Server authentication vs. Trusted connection

By Rod at work

I maintain an application written years ago, where the database is on a Windows...

The Duplicate Cursor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Duplicate Cursor

Concerns over AI Chat Privacy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Concerns over AI Chat Privacy

Visit the forum

Question of the Day

The Duplicate Cursor

Can I run this code:

DECLARE ANewTable CURSOR FOR 
SELECT * FROM ANewTable

See possible answers