sql for everyone
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 by last name): Chad Callihan – In his post, Chad talks about stepping away: “Sometimes, the best way…
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 maintaining reliable, efficient systems, trying for absolute perfection can quickly lead to back-breaking workloads and burnout.…
Warning: It appears the migration doesn’t apply perms in the database related to global roles as part of the Azure migration. At least, it didn’t on my db migration, and I need the read and read-write roles we created to actually have perms in the…
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…
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 I’m working on, and here’s a short one for you today. Azure Data Studio on Windows…
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 rest as much as our data does? There is some idea that you need to work…
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…
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…
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…
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…