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

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-04-29 (first published: )

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

672 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

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

213 reads

Blogs

Speaking at SQL Saturday Austin 2025

By

SQL Saturday Austin 2025 is in just a few days. I am honored to...

Updating SSMS is Easy (w/ v21)

By

I’ve been using the SSMS preview for v21. This is the next evolution of...

Execute Fabric Data Pipeline from Azure Data Factory

By

In the blog post Call a Fabric REST API from Azure Data Factory I...

Read the latest Blogs

Forums

The Long Running Backup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Long Running Backup

Interview Tips

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Interview Tips

importing from PowerQuery... but with multiple powerqueries

By pietlinden

I finally got the PowerQuery source to "show" in SSIS (so I can see...

Visit the forum

Question of the Day

The Long Running Backup

I have a long running backup of the Sales database during a maintenance window that is going to take another 2 hours to complete on SQL Server 2022. I also need to perform some proactive work and add another file (ndf) to the Sales database to handle the expected growth of the next month. Can I do both simultaneously?

See possible answers