Daily Coping 22 Feb 2023
Today’s coping tip is to share something you find inspiring, helpful, or amusing. Maybe not inspiring to you, but it was for me. We recorded a number of customers...
2023-02-22
11 reads
Blog Posts
New Microsoft Purview features
Microsoft Purview, formally called Azure Purview (see Azure Purview is generally available) has recently released a number of new cool features. I wanted to call out a few of...
2023-02-22 (first published: 2023-02-09)
438 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)
267 reads
Daily Coping 21 Feb 2023
Today’s coping tip is to respond kindly to everyone you talk to today. This is often easy for me. I did this last week while traveling. I got coffee...
2023-02-21
16 reads
What Happens On AWS RDS?
I was talking with some developers from my team about monitoring, and I said, “We all use the same tools,” referring to other monitoring software. Then, it hit me....
2023-02-21
8 reads
Daily Coping 20 Feb 2023
Today’s coping tip is to appreciate the good qualities of someone in your life. We have a person in Redgate that does a lot of work to support our...
2023-02-20
11 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)
141 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)
293 reads
CONCAT_WS Function Truncates Text
I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very...
2023-02-17 (first published: 2023-01-31)
616 reads
Daily Coping 17 Feb 2023
Today’s coping tip is to support a local business with a positive online review or friendly message. When I discover a business I like or one that delivers value...
2023-02-17
16 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers