SQL Server Central

When the evidence names the database, it says so. When it doesn’t, it stops. Three databases have no recorded full backup. One backup job failed. Many tools would link the two and call it solved. This one linked the job … Continue reading ?

I’ve covered the values in a number of previous posts on the Book of Redgate. Those values came from our founders, Simon Galbraith and Neil Davidson. I am lucky enough, and honored to have known these gentlemen for many years and had the chance to sit and chat with them throughout my time at Redgate. Simon and I still get together periodically even today after 25 years. In the Book of Redgate, there’s a section about prehistory. In it, there’s this picture and text.

Mirroring in Microsoft Fabric is useful when you need to make SQL Server data available in Fabric. Perhaps in , for example, if you need to use the data for reporting, analytics, notebooks, or another Fabric workload. However, it’s not suitable for everything, as I’ll explain in this complete guide to mirroring data from SQL Server to Microsoft Fabric. Before we get started, a note about compatibility.

Introduction SQL Server 2025 and Azure (Azure SQL Database, Azure SQL Managed Instance, and SQL database in Microsoft Fabric) now include optimized locking. This new feature reduces the memory used by locks, lock escalation, and blocking, which improves concurrency and performance. In this article, we will learn the following: First, we will explain the concept of optimized locking. Secondly, we will learn how to enable and disable this feature.

Making Data AI-Ready, Part 3 (This is the final article in a three-part series on making data AI-ready. Part 1 covered what AI-ready data means, Part 2 looked at the Microsoft tools that support it, and this article focuses on how Prep data for AI and Fabric Data Agent instructions work together.) You have connected a Power BI semantic model to a Fabric Data Agent, and now you want to explain that People means Customers and Revenue means Net Sales Amount.

I use ConEmu for my terminal interface. I’m still on Windows 10 at home, and for consistency’s sake, I run this on my Win11 laptop and the home machine. I love it, and it keeps my windows together, so that I can run multiple command prompts. However. Sometimes I find myself in this situation. I have a bunch of prompts open, and I’m not sure what is what. I know the current one is one of my Flyway projects, but what about the other 4?

Performance Tuning By Brent Ozar · September 22, 2026 · 12 comments 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. You’re monitoring the wrong number.

Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built content in them takes a lot longer. Moving content to another workspace usually means redeploying or recreating it, and anything bound to the old item IDs has to be rebound: reports connected to a semantic model, a notebook’s default lakehouse, pipeline activities, and shortcuts. Item-level shares, app content, and links people saved don’t carry over either.

It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the object history for different schema changes, so as you are evaluating how your changes might fit in with others, or you are trying to determine where something broke, you can see a list of historical changes. This post looks at checking history quickly in FWD. I’ve been working with Flyway and Flyway Desktop and helping customers improve their database development. This series looks at some tips I’ve gotten along the way.