In SQL Server you can also compress your encrypted backups. Unlike TDE this has been possible with Backup Encryption since the feature was first made available, and there have...
2023-06-12 (first published: 2023-05-24)
351 reads
There is a scenario I have seen again and again. A company has developed a nice piece of software which many clients are running with happily. Then along comes...
2023-06-12
16 reads
Hello Dear Reader! Let's address the missing week. Last week I was really behind due to the move. We did not have a Monday video and despite my best...
2023-06-12
12 reads
slipfast adj. longing to disappear completely; to melt into a crowd and become invisible, so you can take in the world without having to take part in it –...
2023-06-09
82 reads
For those that attended my talk at Denver Dev Days, here are the slides: BloggingFortheTechPro.pptx A couple interesting questions that I need to add to the deck. What do...
2023-06-09
8 reads
As a part of my AI experiments, I decided to ask CoPilot to write some unit tests. Here is what happened. The Prompt To get started, you enter a...
2023-06-09
48 reads
I ran across an interesting post from Rita Fainshtein that looked at the different types of graphs for a set of data. I thought that was interesting, so I...
2023-06-09 (first published: 2023-05-22)
447 reads
I have been living with ALS for the past two years. I was diagnosed in September 2022 but had my first symptoms and started researching what was going on...
2023-06-09 (first published: 2023-05-25)
121 reads
I am proud to announce the launch of a new book, centered around the importance of SQL, authored by six consultants from 3Cloud. Our new book is called “SQL...
2023-06-07
18 reads
Database maintenance is crucial for the health and performance of any database system, including those in Azure. Without regular maintenance, databases can become slow, unstable, and prone to crashes...
2023-06-07 (first published: 2023-05-08)
799 reads
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
i have sqlexpress on rds, is there any way i can get notifacation that...
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers