What’s New Type BlogEvents & Workshops Fabric Data Agents – A New Way to Talk to Your Business Data Fabric Data Agents give users a simpler, conversational way to explore trusted business data, ask follow-up questions and get answers without needing to navigate reports or understand the underlying data... The ghostly case of index corruption A rare case of SQL Server index corruption pointed towards an unexpected suspect: the ghost cleanup process. Follow the investigation, the mitigation, and the mystery that was never quite proven. Managed Data & Insights in practice Managed Data & Insights can be shaped around different teams and priorities, from taking on BAU and extending support coverage to providing continuity and enhancement capacity after go-live. 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. Posts pagination 1 2 … 10 >>
