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)
25 reads
Blog Posts
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite Join” on the LATERAL clause. The reason I like it is that it lets you...
2026-07-13 (first published: 2026-07-01)
31 reads
A New Word: Attriage
attriage – n. the state of having lost all control over how you feel about someone – not even trying to quench the flames anymore, but lighting other fires...
2026-07-10
14 reads
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)
227 reads
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
Fabric has CI/CD built in, but if you've tried to use it for database deployments, you've probably already run into its limits. It's still very much in its infancy....
2026-07-10
18 reads
Learn about Modern Microsoft Apps in San Diego
I wrote about learning today for the editorial: I Can’t Make You Learn. I sure hope you want to learn. It’s been great for my career and it will...
2026-07-10
14 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)
284 reads
KDA: Echoes of Deception - Case 6
A cryptic message, a book cipher hidden in art provenance records, and a trail of clues leading to the leader of a shadowy cyber organization.
2026-07-09
9 reads
Capturing My Own Metrics: #SQLNewBlogger
A customer was trying to compare two tables and capture a state as a performance metric. In this case, they were wanting to use Redgate Monitor and custom metrics,...
2026-07-08
388 reads
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting build entirely in Fabric where you can have almost live data in reports. The pitch...
2026-07-08 (first published: 2026-06-23)
221 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage
Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL...
DBCC CHECKDB Limits II
Comments posted to this topic are about the item DBCC CHECKDB Limits II
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers