Across the Water Again
I’m in the UK again, for my second trip this year. This time I have no commitments for speaking or presenting anything. I’m in town for a Marketing get-together...
2023-06-12
15 reads
I’m in the UK again, for my second trip this year. This time I have no commitments for speaking or presenting anything. I’m in town for a Marketing get-together...
2023-06-12
15 reads
The HUGE announcement at Microsoft Build yesterday was Microsoft Fabric (see Introducing Microsoft Fabric: Data analytics for the era of AI), now available in public preview. I have been...
2023-06-12 (first published: 2023-05-24)
531 reads
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)
352 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
10 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
52 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)
448 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
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Be Wary of Data
Comments posted to this topic are about the item Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;