What’s New Type BlogEvents & Workshops Ghosting in the Transaction Log This blog explores what happens behind the scenes when SQL Server deletes rows, tracing how ghost records are created, logged and eventually physically removed by the ghost cleanup process. Using AI for the Right Problems Mark Hill explores why effective enterprise AI is about choosing the right technology for the outcome, balancing performance with cost, governance and long-term maintainability. The Great Database Heatwave – Spotting Regressions Before They Boil Over Dharam Patel explains how automated Query Store regression monitoring can spot rising performance issues across SQL databases before they boil over into user-facing problems. SQL Server Backups – Reviewing Your Maintenance Jobs A successful SQL Server maintenance job is not always a healthy one, so regular reviews are essential to make sure backups and other tasks still run efficiently. Coeo Performance Reviews Featuring dbatools PowerShell Module and Glenn Berry’s Diagnostic Queries This blog explains how SQL Server teams can use dbatools and Glenn Berry’s Diagnostic Queries to run fast, consistent and repeatable performance reviews across multiple environments. Let the Ghosts Linger This blog explores what happens when SQL Server’s ghost cleanup process is temporarily disabled, showing how ghost records linger on data pages and why this should only be done with... Keeping Cool Under Pressure A look behind the scenes at how Coeo’s Managed Service team keeps data platforms supported through busy summer projects, annual leave and the occasional heatwave. Seeing the ghost clean-up process in action This blog walks through a practical SQL Server demo showing how ghost records are created, monitored with Extended Events, and eventually cleared by the ghost cleanup process. Ghosts! – Ghost Records and the Ghost Cleanup Process This blog explains how SQL Server uses ghost records to defer physical row deletion, helping delete and update operations run more efficiently before a background cleanup process removes the data... SQL Server Backups: Reviewing Your HA/DR and Backup Setup Your SQL Server backups may be running, but would they actually protect you in a real outage? Read our guide to find out what a strong HA/DR and backup setup... Import Mode vs DirectLake in Power BI This blog explains the differences between Import Mode and DirectLake in Power BI, when each should be used, and provides a step-by-step guide to migrating to DirectLake in Microsoft Fabric. Your Power BI Reports Can Now Talk to AI. Power BI’s new MCP servers let AI agents securely work with your data models, so people can ask questions in plain language or even optimise reports automatically, without needing deep... Posts pagination 1 2 … 9 >>
