I’ve covered how to create Elastic Jobs in the portal (this one is important to read if you aren’t familiar with elastic jobs already), with Terraform, and with Bicep....
2025-02-09 (first published: 2025-02-07)
50 reads
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: 2025-01-27)
216 reads
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also using the Azure migration tool. I had to ultimately do a combo of those because...
2025-01-13 (first published: 2025-01-07)
1,934 reads
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...
2024-12-02 (first published: 2024-11-21)
184 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all who posted on this topic! Here are the highlights of the posts (in alphabetical order...
2024-11-21 (first published: 2024-11-20)
126 reads
How can you achieve good enough without compromising the process/product? In the world of database technology, striving for perfection is a double-edged sword. While high standards are important for...
2024-11-05
27 reads
I need to migrate from a single server to a flex server. Instead of doing a dump and restore, I’m going to try out the migration service that Azure provides. Single...
2024-11-01 (first published: 2024-10-17)
194 reads
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...
2024-10-14 (first published: 2024-09-25)
148 reads
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...
2024-09-23 (first published: 2024-09-05)
47 reads
I wanted to migrate some connections without recreating them and wondered how to do that in Azure Data Studio. It turns out to be easy. I post about whatever...
2024-08-28 (first published: 2024-08-12)
2,404 reads
By Steve Jones
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into...
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Building a RESTful API with...
Comments posted to this topic are about the item The Journey to PostgreSQL (or...
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers