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-01-28 (first published: 2025-01-27)
19 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-01-28 (first published: 2025-01-27)
19 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,899 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)
161 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)
117 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
21 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)
175 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)
132 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)
38 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)
808 reads
We talk a lot about data in the data world – imagine that! Sometimes, we talk about data at rest, but when do we all rest? Do we even...
2024-08-12 (first published: 2024-07-30)
175 reads
By DataOnWheels
Hey data friends! This one comes from my personal vault (aka backlog of drafts...
Data's the new oil, and SQL is your refinery. It's still the go-to language...
You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles...
Comments posted to this topic are about the item Why you should avoid Implicit...
Comments posted to this topic are about the item Creating a Linked Server in...
Comments posted to this topic are about the item Dates and Languages
The string, listopad, translates to a month name in different languages. If I were to run this code, what values are returned?
DECLARE @yourInputDate NVARCHAR(32) = '28 listopad 2018'; SET LANGUAGE Polish; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Polish]; SET LANGUAGE Croatian; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Croatian]; SET LANGUAGE English;See possible answers