How to mirror data from SQL Server to Microsoft Fabric: complete guide
Learn all about Microsoft Fabric mirroring for SQL Server: how it works, what's new in 2025, setup, limitations, and troubleshooting
2026-10-02
Articles
Database Animations: Stop Using Page Splits to Justify Lowering Fill Factor.
You're looking at page split numbers in a monitoring tool or Perfmon, and you've heard that page splits are bad, so you're lowering fill factor, expecting your page splits to go down.
2026-09-30
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
This article looks at how the parameter sniffing performance problem can be helped in SQL Server 2025 with PSPO.
2026-09-28
2,632 reads
Why SQL Server’s default trigger execution model is a security flaw – and what Microsoft should do about it
The situation raises a question I’ve been thinking for a while: why does SQL Server allow trigger code to inherit the privileges of whichever principal happens to fire it?
2026-09-28
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Diagnosing memory issues can be hard. This article shows how one administrator used custom tracking to determine whether SQL Server, SSAS, or SSRS was the issue.
2026-09-25
2,095 reads
Migrate SQL Server Databases to Different Active Directory Domain
We want to leverage Distributed Availability Groups to migrate our databases to a different Active Directory domain. How do we go about it?
2026-09-25
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Reproduce traditional row-lock accumulation and writer blocking, then see how SQL Server 2025 uses transaction ID locking and Lock After Qualification to improve concurrency—and where hints, isolation levels, and query shapes limit the benefit.
2026-09-23
2,838 reads
Database Animations: The Interview Question Everybody Gets Wrong
No no, I'm not just talking about the people answering the interview question. I'm talking about the people asking the question.
2026-09-23
Finding Gaps in Sequential Data Using SQL Server
Many systems expect a sequential range of numbers for invoices, ticket numbers, and more. Learn how you can identify where you have gaps in your sequences.
2026-09-21
3,693 reads
What is cloud database vendor lock-in? The 3 types explained (and how to audit yours)
Cloud database vendor lock-in is one of the most expensive surprises in enterprise infrastructure — not because the dependency is hidden, but because most teams never quantify it before committing to a platform.
2026-09-21
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers