Automatic Index Compaction
Index maintenance has always meant nightly jobs and a window you have to defend. Azure SQL’s new Automatic Index Compaction targets page density directly — so I tested it.
2026-07-10 (first published: 2026-06-30)
307 reads
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but I’d like to apply the Goldilocks principle to a database object-namely, a materialized view. You...
2026-06-30
86 reads
Monday Monitor Tips: Virtual Machine Usage and Cost
One of the things I’ve been requesting for a number of years is cost information. I could see this coming in 2015 with the move to the cloud and...
2026-07-13 (first published: 2026-06-29)
217 reads
Advice I Like: Respect
“Don’t aim to have others like you; aim to have them respect you.” – from Excellent Advice for Living This is an interesting piece of advice. It’s easy to...
2026-06-26
100 reads
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation project. We were replacing an existing non-Oracle system with an entirely new Oracle database application...
2026-06-27 (first published: 2026-06-26)
92 reads
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac with Apple Silicon is genuinely one of the best machines you can have as a...
2026-07-10 (first published: 2026-06-25)
391 reads
Want to look at cloud reporting but not sure what the costs will be?
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but you have no idea what it would actually cost? ?? That’s the scariest thing, and...
2026-06-25
149 reads
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates one of the most significant independent groups in the field of data analytics, business intelligence...
2026-06-25
51 reads
KDA: Echoes of Deception - Case 5
A deleted podcast episode, 17 million archive log entries, and KQL's time series analysis to find the backup that was never supposed to survive.
2026-06-25
20 reads
Prime Day Recommendations
It’s Prime Day. A few of my recommendations, since I want to do some shopping myself (yes, these are commissioned referrals). These are things I’ve ordered and used this...
2026-06-24 (first published: 2026-06-23)
45 reads
Blogs
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers