Decision Guide for Selecting an Analytical Data Store in Microsoft Fabric Microsoft Fabric is a comprehensive analytics platform that integrates various data stores, including SQL Databases, Data Warehouses, Lakehouses, and Eventhouses. Each data store is designed to handle specific types of analytical workloads, making it essential to understand their unique…
New Features: Optimized Locking I hope everyone has a great holiday season. I am excited to share some insights from a recent article on the Microsoft Tech Community blog about a feature in Azure SQL Database that will also be introduced in SQL Server 2025: Optimized Locking. Optimized locking is…
SQL Server Management Studio (SSMS) 21 Preview 2 released Highlights SSMS 21 Preview 2 was released yesterday, December 10th! Preview 2 can be downloaded from https://aka.ms/ssms/21/preview/vs_ssms.exe What’s in Preview 2 Added support for multi-tenant scenario in authentication control Completed dark theme support for SQL results tabs and results grid header Initial…
Key Features Comparison: Azure SQL Database vs. SQL Database in Microsoft Fabric 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…
Announcing Microsoft SQL Server 2025 and SSMS 21. Microsoft SQL Server 2025, now in preview, is an enterprise AI-ready database from ground to cloud that tackles these challenges by bringing AI to customers’ data. This release continues SQL Server’s three decades of innovation in performance and security, adding new AI capabilities….
Announcing SQL database in Microsoft Fabric Public Preview 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…
SQL Server Security Updates Newsletter October/November November 2024 Security Update of SQL Server 2022 RTM CU16 KB Article: KB5048033 Security Update of SQL Server 2022 RTM GDR KB Article: KB5046861 Security Update of SQL Server 2019 RTM CU KB Article: KB5046860 Security Update of SQL Server 2019 RTM GDR KB Article: KB5046859 Security…
A year ago, Microsoft launched the Secure Future Initiative (SFI) to prepare for the increasing scale and high stakes of cyberattacks. SFI brings together every part of Microsoft to advance cybersecurity protection across our company and products. This initiative represents a significant step forward in safeguarding your digital assets and…
Introducing Database Watcher for Azure SQL (Public Preview) Introducing Database Watcher for Azure SQL, Microsoft’s latest public preview monitoring tool that elevates observability for Azure SQL Databases, Elastic Pools, and Managed Instances to new heights. Database Watcher is a powerful managed database monitoring solution designed to enhance the reliability and…
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…