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
10 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)
433 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)
262 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
14 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
6 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
6 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)
136 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)
282 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)
572 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
11 reads
Blogs
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
A Prompt AI Experiment
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
SQL Server Is Slow (part 1 of 4)
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
Forums
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers