What’s New Type BlogEvents & Workshops Partitioning – Maintenance vs Performance Explore when SQL Server partitioning can make maintenance easier and queries faster, and why good design matters if you want to get the benefits. What Managed Data & Insights is, and why flexibility matters Coeo Managed Data & Insights gives data teams flexible access to the specialist support and delivery capacity they need to keep platforms reliable. 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... Posts pagination 1 2 … 9 >>
