What’s New Type BlogEvents & Workshops 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... How to Read Execution Plans Execution plans act as a roadmap showing how SQL Server runs a query, helping you understand the path, costs, and potential bottlenecks so you can identify and improve performance. “No, we’re not upgrading. What are we missing out on?” Still on SQL Server 2016? This blog highlights the performance, security, and innovation you’re missing out on, and why upgrading might be worth it. The Ramblings of a Seasoned Campaigner After years of watching data projects miss the mark, this blog shares some honest advice on what actually makes them work. Mirroring SAP data in Microsoft Fabric – now super easy! Microsoft Fabric now makes it much easier to bring SAP data into a unified analytics platform through low-cost, low-latency mirroring that keeps data in sync without complex pipelines. The Ghost in the Machine: How a Simple SELECT Paralyzed a 1TB SQL Server A lightweight stored procedure, executed hundreds of times per second, brought a high-spec SQL Server to a halt, until a subtle TempDB metadata change eliminated the issue. SQL Server Backups: RPO, RTO, and the Reality Check Your backups might look fine, but when things go wrong, would you actually know how much data you’ll lose or how long recovery will take? Bringing Fabric into Enterprise DevOps This blog shows a simple way to deploy Microsoft Fabric items through Azure DevOps and remove the last manual steps from your release process. Posts pagination 1 2 … 9 >>
