Skip to content
sqlkitty

sqlkitty

sql for everyone

Menu
  • Home
  • About
  • Auditing
  • Code
  • Presentations
  • Publications
  • Contact

Category: azure

How to find free space in Azure PostgreSQL

  • Posted onNovember 21, 2024December 2, 2024
  • azure

I wanted to figure out how big (or approximately how big) my dump file would be. In QA, I have (relatively) large dbs (compared to prod). Enter the pgstattuple extension to help me determine how much free space is in my tables. Step 1: Installing…

Continue Reading

Migrate to Azure PostgreSQL Flexible Server

  • Posted onOctober 17, 2024December 20, 2024
  • azure

Warning: It appears the migration doesn’t apply perms in the database related to global roles as part of the Azure migration. https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-user-roles-migration-service. I will be using pg_dumpall for scripting out the perms. You can refer to my last post under dumping from command line for…

Continue Reading

Dumping and Restoring Azure PostgreSQL Databases

  • Posted onSeptember 25, 2024December 2, 2024
  • azure

I wanted to test a migration of Azure PostgreSQL from simple to flexible. I wanted a simple db to restore onto my single server. I may not have needed to do this, but I was then curious how one would go about dumping and restoring…

Continue Reading

Azure PostgreSQL Flexible Server and Entra Groups

  • Posted onSeptember 5, 2024September 5, 2024
  • azure

My company is moving from an Azure PostgreSQL single server to a flexible server. We want to set up managed identity/Entra access instead of having roles with passwords for every person/app. In particular, we want to use Entra groups. What is Azure PostgreSQL Flex? It…

Continue Reading

Using Managed Identities with Azure SQL DB

  • Posted onJuly 25, 2024July 25, 2024
  • azure

We are trying to get apps and users off of using SQL accounts to access the Azure SQL DBs where I work. To make our lives easier, we are implementing managed identities. Benefits of Using Managed Identities and Entra Groups Creating a Managed Identity Navigate…

Continue Reading

Terraform Elastic Jobs

  • Posted onJuly 19, 2024July 29, 2024
  • azure

I did a couple of other posts on Elastic Jobs. But now I want to set them up with Terraform. This aligns with how we create infrastructure where I work. TL;DR check out my Github Repo. Creating Prerequisites If you aren’t familiar with Terraform and…

Continue Reading

Modifying sp_QuickieStore Returned Column Order

  • Posted onJuly 3, 2024July 3, 2024
  • azure

I love QuickieStore, but I wanted some columns to be at the front end of the results returned. Namely, I wanted top_waits, query_sql_text, and query_plan right after database name. This way I don’t have to scroll over to see those values. You can get a…

Continue Reading

Export Azure SQL DB to Storage

  • Posted onJuly 2, 2024July 18, 2024
  • azure

After a data migration, we needed to decommission the old Azure SQL DBs, but we wanted to keep a copy in case we needed anything later. Enter exporting an Azure SQL DB to storage! Updated with new info I discovered as part of the export…

Continue Reading

Create a copy of an Azure SQL DB

  • Posted onJune 25, 2024July 5, 2024
  • azure

Where I work, we will be migrating data from one set of databases into another. I will be making a copy of the destination databases to allow us to roll back in case of issues. Make a copy of the databases in the destination server…

Continue Reading

Query deadlock info in Azure SQL DB

  • Posted onJune 14, 2024June 14, 2024
  • azure

A couple of weeks ago, a developer came to me and wanted to know how to figure out what was causing a deadlock. I honestly didn’t know where to look or if this was even being captured in Azure SQL DB already. It turns out…

Continue Reading

Posts pagination

Previous Page Page 1 Page 2 Page 3 … Page 5 Next Page

Newletter Signup

Loading

Recent posts

  • Query multiple Azure SQL Databases
  • Azure Vulnerability Assessments
  • Using Cron in Postgres Flex
  • Why use XACT_ABORT?
  • Using SQLFluff

Categories

  • audit (2)
  • azure (44)
  • containerization (14)
  • datawarehousing (4)
  • dba (51)
  • editorial (8)
  • excel and others (3)
  • IT Certifications (1)
    • network+ (1)
  • linux (2)
  • network administration (15)
  • newjob (7)
  • other (8)
  • performance (1)
  • postgresql (16)
  • powershell (1)
  • security (3)
  • sql server (22)
  • sql server administration (124)
    • jobs (4)
  • sql sever syntax (78)
  • terraform (5)
  • tsql2sday (1)
  • web dev (6)
  • zen (2)

Archives

  • May 2025 (2)
  • April 2025 (2)
  • March 2025 (3)
  • February 2025 (3)
  • January 2025 (4)
  • November 2024 (3)
  • October 2024 (1)
  • September 2024 (2)
  • August 2024 (1)
  • July 2024 (5)
  • June 2024 (4)
  • May 2024 (4)
  • April 2024 (3)
  • March 2024 (2)
  • February 2024 (1)
  • January 2024 (5)
  • December 2023 (2)
  • November 2023 (5)
  • October 2023 (1)
  • September 2023 (1)
  • August 2023 (2)
  • July 2023 (2)
  • June 2023 (3)
  • May 2023 (4)
  • April 2023 (3)
  • March 2023 (5)
  • January 2023 (1)
  • October 2022 (2)
  • April 2022 (1)
  • December 2021 (1)
  • May 2021 (1)
  • April 2021 (2)
  • February 2021 (7)
  • January 2021 (4)
  • December 2020 (2)
  • November 2020 (1)
  • January 2020 (2)
  • December 2019 (3)
  • August 2019 (2)
  • February 2019 (1)
  • June 2018 (1)
  • January 2018 (1)
  • September 2017 (1)
  • May 2016 (4)
  • January 2016 (2)
  • December 2015 (2)
  • August 2015 (2)
  • July 2015 (4)
  • June 2015 (3)
  • May 2015 (9)
  • April 2015 (4)
  • November 2014 (7)
  • October 2014 (19)
  • September 2014 (3)
  • July 2014 (2)
  • July 2013 (1)
  • December 2012 (1)
  • October 2012 (1)
  • December 2011 (6)
  • October 2011 (6)
  • September 2011 (5)
  • July 2011 (1)
  • June 2011 (1)
  • May 2011 (2)
  • April 2011 (1)
  • February 2011 (15)
  • January 2011 (19)
  • December 2010 (14)
  • November 2010 (16)
  • October 2010 (3)

RSS SQL Kitty RSS

  • Query multiple Azure SQL Databases
  • Azure Vulnerability Assessments
  • Using Cron in Postgres Flex
  • Why use XACT_ABORT?
  • Using SQLFluff
© Copyright 2025 – sqlkitty
Chip Life Theme by TutorialChip ⋅ Powered by WordPress