Daily Coping 7 Feb 2023
Today’s coping tip is to go to bed in good time and allow yourself to recharge. I need this reminder. Lately I’ve struggled to sleep well, through the night,...
2023-02-07
28 reads
Tales From The Field Weekly Wrap Up for the Week of 01-31-2023
Hello Dear Reader! After a weekend with a lot of activities, it was a down week here at Casa Balls. Woke up and walked a lot. I'm still not...
2023-02-06
47 reads
Creating a Flyway Desktop Shadow Database in PostgreSQL
In order to generate migrations, we need to configure Flyway to use a shadow database. This post looks at that process. This is part of a series of working...
2023-02-08 (first published: 2023-02-06)
133 reads
Query Store Data Cleanup
Microsoft supplies quite a few knobs to control how Query Store performs data cleanup. You can set your cleanup various ways, and, they interact. Let’s talk about how and...
2023-02-22 (first published: 2023-02-06)
285 reads
Daily Coping 6 Feb 2023
Today’s coping tip is to get back in contact with an old friend. This is something I don’t do too often, but I have done a few times. I’ve...
2023-02-06
23 reads
Rotating a Certificate Used by TDE
In terms of encryption, Key Rotation is the process of replacing your encryption keys on a periodic basis. This is considered good practice and is required by many security...
2023-02-20 (first published: 2023-02-06)
313 reads
Daily Coping 3 Feb 2023
Today’s coping tip is to ask other people about things they’ve enjoyed recently I asked the question on Twitter and on Facebook, looking for interesting responses from friends. The...
2023-02-03
19 reads
Daily Coping 2 Feb 2023
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m struggling with some negative thoughts outside of work. This year as I coach older girls,...
2023-02-02
19 reads
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31 March each year to provide the list of their annual contributions. For 2023, the deadline...
2023-02-20 (first published: 2023-02-01)
160 reads
Why Managed Identities are Awesome
For the first workdays of this new year, I had the pleasurable task of resetting a bunch of passwords. The passwords belong to Azure AD users, service principals, SQL...
2023-02-15 (first published: 2023-02-01)
534 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers