Azure SQL Database vs. SQL Database in Microsoft Fabric Comparisons Recently, Microsoft announced the Public Preview of SQL database in Microsoft Fabric. Many have asked what the key differences and similarities between Azure SQL Database and the SQL Database in Microsoft Fabric? For a detailed comparison, you can refer to…
Announcing Microsoft SQL Server 2025 and SSMS 21, bringing AI capabilities to your data for enhanced performance and security.
Introducing SQL database in Microsoft Fabric, now available in public preview. This new feature allows users to mirror their existing Azure SQL databases directly into Fabric’s OneLake. This integration aims to simplify data management by avoiding complex ETL processes and enabling near-real-time data replication. SQL database in Fabric is centered…
Introducing Database Watcher for Azure SQL, the ultimate monitoring tool for enhancing your Azure SQL database observability.
Upcoming changes for SQL Server Management Studio (SSMS). This is the first of three blog posts about the next releases of SQL Server Management Studio (SSMS), and the roadmap for 2024! Learn more: SSMS 20 connection changes (microsoft.com) Get started planning SQL Server 2014 end of support. Did you know that…
Explore MPP Architecture in Synapse SQL Pools to optimize data processing and enhance query performance across large datasets.
Accelerated Database Recovery (ADR) is one of the most impactful engine changes introduced with SQL Server 2019. The goal of ADR is to dramatically reduce database recovery and rollback time, even in the presence of long‑running transactions. What Is Database Recovery? In a previous post, I discussed the SQL Server Restore and Recovery…
John Deardurff passed the DP-200 and DP-201 exam for the Microsoft Certified: Azure Data Engineer certification.
Explore the importance of indexes that cover a query and how they can improve SQL Server performance and eliminate lookups.
Learn about Writing SARGable Expressions in T‑SQL to maximize SQL Server performance and efficiency with your queries.