SQL Server
The SQL Server engine, SSMS, SSIS and friends.
Nothing in this view matches those filters.
-
Community
What Was New for SQL Developers in 2012
Jeff Taylor starts a retrospective: In my session, “What’s New in SQL Server for the Developer”, I always start with a show of hands, and…
-
Community
Thoughts on Open-Sourcing SQL Server
Brent Ozar has some thoughts: At the PASS Summit last week in Seattle, I was having a discussion with a few people who’d moved on…
-
Community
Group by Schema in SSMS
Jess Pomfret finds an option: Folks, how have I missed this? I was at FabCon & SQLCon in Barcelona a few weeks ago, when I…
-
Community
Finding NTLM Connections to SQL Server
Andreas Wolter shares advice and a script: In short: I recommend finding out now which connections to your SQL Servers still use NTLM, and fixing…
-
Blog
Microsoft Drivers for PHP for SQL Server 5.14.0 - Now with PHP 8.6 Support
Today we released Microsoft Drivers for PHP for SQL Server 5.14.0. This release adds PHP 8.6 support within hours of PHP 8.6 GA, continues support for PHP 8.4 and 8.5, and removes support for PHP 8.3 and earlier. Starting with 5.14.0, new releases are…
-
Blog
Announcing mssql-python 1.18.0: Faster fetch paths, smarter reuse, stronger reliability
We’re excited to announce mssql-python 1.18.0, focused on one thing you'll feel immediately: better runtime efficiency without breaking expected behavior. This release improves repeated-query execution, single-row and batch fetch paths, row-to-dictionary…
-
Release
vscode-mssql Data Workspace v0.8.1
Version 0.8.1 Note All Data Workspaces functionality and contributions have moved into the main SQL Server (mssql) extension. The Data Workspaces extension may be uninstalled without impact. If you must have it installed, use this version, as it is now an…
-
Release
vscode-mssql SQL Database Projects v1.9.1
Version 1.9.1 Note All SQL Database Projects functionality and contributions have moved into the main SQL Server (mssql) extension. The SQL Database Projects extension may be uninstalled without impact. If you must have it installed, use this version, as it…
-
Blog
Modernize applications and databases together with the Modernize CLI
An application might need a framework upgrade, dependency updates, or a move to Azure. But behind that application is often a database that needs its own modernization decisions: Is the SQL Server workload ready to move? Which Azure SQL target is the best…
-
Blog
Announcing SQL Server 2025 Preview Support on Ubuntu 26.04 LTS
We are excited to announce preview support for SQL Server 2025 on Ubuntu 26.04 LTS, starting with SQL Server 2025 CU11. This brings SQL Server 2025 to Canonical's latest long-term support release, giving developers and organizations an opportunity to evaluate…
-
Blog
MI link support for multiple databases in an Always On availability group is now generally available
We are excited to announce the general availability of multi-database mode for MI link, which enables you to replicate multiple databases in an Always On availability group between SQL Server and Azure SQL Managed Instance through a single MI link. Managed…
-
Blog
Modernize your apps with Azure SQL Database Hyperscale
Learn how Azure SQL Database Hyperscale brings scale, competitive economics, and AI to the apps you already run, and the ones you build next. The post Modernize your apps with Azure SQL Database Hyperscale appeared first on Microsoft SQL Server Blog .
-
Blog
New Create and Apply wizards in SSMS (Preview)
Need to save a database schema, move schema and data to another environment, or deploy a DACPAC to an existing database but find the existing options confusing? SQL Server Management Studio (SSMS) has new preview wizards that streamlines those tasks: Create…
-
GA
Database Hub real-time performance dashboards
Database Hub in Microsoft Fabric gives you built-in, real-time performance dashboards for Microsoft SQL, Azure Database for PostgreSQL flexible server, and Azure Cosmos DB in one place. From the Performance page, you can track CPU, memory, storage, IO, co…
-
Blog
Announcing SQL Server Management Studio 22.12.1
Today at Microsoft Ignite, we're releasing SQL Server Management Studio (SSMS) 22.12.1. Our teams have been working hard to bring you lots of new and exciting capabilities! This release introduces local Azure SQL Database container creation and management…
-
Blog
Microsoft Options to Migrate SQL Server Databases
Overview This blog supplements the Migrate to Azure SQL documentation and summarizes the Microsoft first party ways to copy or migrate SQL Server databases from on‑premises environments to SQL Server running in Azure. Azure SQL Hyperscale is our recommended…
-
Blog
Fuzzy string matching is now generally available across Microsoft SQL
Four native T-SQL functions that tell you how close two strings are, not just whether they’re equal. MICROSFT isn’t MICROSOFT. MARHTA isn’t MARTHA. INV-1O08 isn’t INV-1008. To an equality check, each pair is simply different. To your business, each is a near…
-
Preview
Azure SQL Database container provisioning in SQL Server Management Studio
Now in public preview, you can provision an Azure SQL Database development environment in seconds directly from SQL Server Management Studio (SSMS), with no Azure subscription, credit card, or existing database required.Azure SQL Database container brings…
-
Preview
Azure SQL updates for mid-November 2026
In mid-November 2026, the following updates and enhancements were made to Azure SQL: In SSMS, the new Create and Apply wizards make it simpler to create and use .dacpac and .bacpac files. The new feature consolidates and replaces the var…
-
GA
Database Hub in Microsoft Fabric
Database Hub in Microsoft Fabric is a unified experience for discovering, managing, monitoring, and optimizing databases across SQL Server, Azure SQL, PostgreSQL, Azure Cosmos DB, and Fabric SQL. By bringing AI-powered insights and agents into a single co…
-
GA
Fuzzy string match is available across Microsoft SQL offerings
Fuzzy string match is now generally available across Microsoft SQL offerings, including Azure SQL Database, Azure SQL Managed Instanced, SQL database in Microsoft Fabric, and SQL Server 2025. You can compare strings based on how similar or different they…
-
Preview
SQL Server 2025 support on Ubuntu 26.04 LTS
Announcing Public Preview support for SQL Server 2025 on Ubuntu 26.04 LTS, allowing you to evaluate, test, and deploy SQL Server on Canonical's latest long-term supported platform. Learn more.
-
GA
Azure SQL Managed Instance link support for availability groups with multiple databases
You can now use a single Azure SQL Managed Instance link to extend a SQL Server Always On Availability Group with multiple databases to Azure SQL Managed Instance. You can extend an existing availability group or create a new one with multiple databases,…
-
Blog
Strengthen SQL Server security on Azure Local with confidential VMs (In Preview)
SQL Server holds some of the most sensitive data an organization runs, including the business data that local AI applications and agents query. Azure Local provides a Microsoft-managed, distributed infrastructure platform for running SQL Server in virtual…
-
News
Azure SQL expands modernization, resiliency and local development options
Azure SQL updates will help organizations modernize SQL Server workloads and build cloud and AI applications. They expand resiliency and resource flexibility, simplify migration and disaster recovery, and bring Azure SQL Database development to local…
-
Blog
Cumulative Update #11 for SQL Server 2025 RTM
The 11th cumulative update release for SQL Server 2025 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing model…
-
Blog
Cumulative Update #28 for SQL Server 2022 RTM
The 28th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing model…
-
Blog
Your day-by-day guide to Microsoft SQL at Ignite 2026
Microsoft Ignite returns to San Francisco November 17–20, bringing together developers, data professionals, and technology leaders. Whether you’re modernizing an existing SQL estate or building your next AI application, our sessions offer a practical path…
-
Blog
Microsoft.Data.SqlClient 7.1.2, 7.0.4, and 6.1.8 are now available
We shipped servicing releases for all three supported SqlClient lines: 7.1.2, 7.0.4 and 6.1.8. They pick up a dependency security fix, tighten certificate validation, and fix several bugs. Check your HostNameInCertificate values HostNameInCertificate tells…
-
Blog
Security Update for SQL Server 2025 RTM CU10
The Security Update for SQL Server 2025 RTM CU10 is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2025 RTM CUs, plus it includes…
-
Blog
Security Update for SQL Server 2025 RTM
The Security Update for SQL Server 2025 RTM GDR is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2025 RTM, plus it includes the new…
-
Blog
Security Update for SQL Server 2022 RTM CU27
The Security Update for SQL Server 2022 RTM CU27 is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2022 RTM CUs, plus it includes…
-
Blog
Security Update for SQL Server 2022 RTM
The Security Update for SQL Server 2022 RTM GDR is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2022 RTM, plus it includes the new…
-
Blog
Security Update for SQL Server 2019 RTM CU32
The Security Update for SQL Server 2019 RTM CU32 is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2019 RTM CUs, plus it includes…
-
Blog
Security Update for SQL Server 2019 RTM
The Security Update for SQL Server 2019 RTM GDR is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2019 RTM, plus it includes the new…
-
Blog
Security Update for SQL Server 2017 RTM CU31
The Security Update for SQL Server 2017 RTM CU31 is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2017 RTM CUs, plus it includes…
-
Blog
Security Update for SQL Server 2017 RTM
The Security Update for SQL Server 2017 RTM GDR is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2017 RTM, plus it includes the new…
-
Blog
Closing a monitoring blind spot: version store read metrics
When we asked two popular LLMs to "rank top RDBMS on the breadth and depth of the engine monitoring data they provide", the SQL Server database engine was ranked first by one and second by the other. With hundreds of DMVs and catalog views, thousands of…
-
Blog
Migrate Arc-registered SQL Server instances to Azure without deploying the Arc agent
Many organizations want to modernize their SQL Server estate with Azure Arc but can't install an agent on their database servers. Security reviews, compliance policies, change-control windows, or locked-down production hosts often rule it out. Until now, that…
-
Blog
mssql-python 1.17.0: more reliable bulk copy, faster pool recovery, and DB-API fixes
mssql-python 1.17.0 is now available. This release is mostly about reliability. Bulk copy works better after upgrades, connection pools recover from dead connections, multi-statement batches report the right row counts, and Timestamp() works the way PEP 249…
-
Blog
Cumulative Update #10 for SQL Server 2025 RTM
The 10th cumulative update release for SQL Server 2025 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing model…
-
Release
vscode-mssql Data Workspace v0.8.0
Note All Data Workspaces functionality and contributions have moved into the main SQL Server (mssql) extension. The Data Workspaces extension may be uninstalled without impact. If you must have it installed, use this version, as it is now an empty shell for…
-
Release
vscode-mssql SQL Database Projects v1.9.0
Note All SQL Database Projects functionality and contributions have moved into the main SQL Server (mssql) extension. The SQL Database Projects extension may be uninstalled without impact. If you must have it installed, use this version, as it is now an empty…
-
Blog
Managed Instance link with failover groups (limited preview)
Before we kick off the preview, we’d like to hear from customers interested in trying it. The new capability will let you replicate data from SQL Server to a managed instance that’s part of a failover group, combining hybrid replication with geo-redundancy in…
-
Blog
Microsoft at PASS Data Community Summit 2026:
Microsoft is excited to be back as Sapphire Sponsor and bring that spirit to life through a mix of technical deep dives, community-led conversations, and opportunities to engage directly with Microsoft product leaders and experts. This year, we’ll go deep…
-
Blog
SQL Server on Azure VMs makes history with the first audited SQL Server TPC-H result in the cloud!
I am thrilled to share that SQL Server 2025 running on an Azure F64amds_v7 virtual machine, an AMD EPYC-based offering, has achieved an audited TPC-H result of 1,667,428 QphH@1000GB1. This is the first official, audited TPC-H result for SQL Server on cloud…
-
Blog
Security Update for SQL Server 2025 RTM CU9
The Security Update for SQL Server 2025 RTM CU9 is now available for download at the Microsoft Download Center and Microsoft Update Catalog sites. This package cumulatively includes all previous security fixes for SQL Server 2025 RTM CUs, plus it includes the…
-
Blog
Know Before You Migrate: Bringing Readiness, Sizing, and Pricing Together in SSMS
Migrating SQL Server to Azure starts with a simple question: Where should I move my databases, and what will it cost? Compatibility is an important part of that decision, but it is only one part. Users also need to understand whether their current SQL Server…
-
Blog
SQL Server Migration, Reimagined with AI-Powered Skills
Before moving a database, organizations need to understand their environment, determine whether they have enough information to assess it, identify compatibility issues and migration risks, select the right Azure destination, determine appropriate sizing…
-
Blog
SQLCon Barcelona 2026: Advancing SQL with greater control, scale, and intelligence
We're bringing the Azure control plane and management to wherever you are, providing a consistent SQL and Azure experience. The post SQLCon Barcelona 2026: Advancing SQL with greater control, scale, and intelligence appeared first on Microsoft SQL Server Blog.
-
Blog
SQL Server on Azure Local is now generally available
With SQL Server on Azure Local, customers can modernize where their data resides while maintaining control over infrastructure, connectivity, and data placement. The post SQL Server on Azure Local is now generally available appeared first on Microsoft SQL…
-
Release
vscode-mssql Data Workspace v0.7.0
Note This version of the Data Workspace extension is only compatible with MSSQL for VS Code v1.46.0 (and higher) and SQL Database Projects v1.8.0 (and higher). Please update all three extensions together to these minimum versions. Version 0.7.0 Release date…
-
Release
vscode-mssql SQL Database Projects v1.8.0
Note This version of the SQL Database Projects extension is only compatible with MSSQL for VS Code v1.46.0 (and higher) and Data Workspace v0.7.0 (and higher). Please update all three extensions together to these minimum versions. Version 1.8.0 Release date…
-
Community
Your Path from SQL Server to PostgreSQL at PASS Summit West 2026
If you’ve spent years on SQL Server and you’re now looking at PostgreSQL, you’re not... The post Your Path from SQL Server to PostgreSQL at PASS Summit West 2026 appeared first on PASS Data Community Summit.
-
Blog
Migration: SQL Server to Azure SQL Managed Instance using DMS
Moving SQL Server to Azure SQL Managed Instance sounds challenging on day one. It doesn't have to be. If your backup files already sit in an Azure Blob Storage container, Azure Database Migration Service (DMS) handles the rest. I am going to sharing the quick…
-
Blog
Release Announcement of SQL Server Migration Assistant (SSMA) v10.6
We're pleased to announce the release of SQL Server Migration Assistant (SSMA) v10.6, taking two key AI-assisted modernization capabilities to general availability and refreshing the model choices available for customers who bring their own Azure OpenAI…
-
Blog
What’s next for SQL? Performance, scale, AI, and developer productivity at the European SQL Community Conference
Join Microsoft Fabric and SQL Community Conference 2026 in Barcelona to explore SQL Server 2025, Azure SQL Database Hyperscale, developer productivity tools, and the future of AI-powered data platforms. The post What’s next for SQL? Performance, scale, AI…
-
Blog
SQL Server 2016 end of support is here: Plan your next steps
See what changes as SQL Server 2016 reaches end of support. Choose between cloud migration, upgrading SQL Server, and Extended Security Updates (ESU). The post SQL Server 2016 end of support is here: Plan your next steps appeared first on Microsoft SQL Server…
-
Blog
Generally Available: SQL Migration to SQL Server on Azure Virtual Machines in Azure Architecture
One Migration Experience, More Flexibility Modernizing SQL Server estates is rarely a single-step journey. Organizations often operate across on-premises, hybrid, and cloud environments while balancing application dependencies, operational requirements, and…
- Video
-
GA
Snapshot backup for SQL Server in Azure VMs
Azure Backup now supports snapshot-based backup for SQL Server running on Azure Virtual Machines. This new capability uses Azure disk snapshots combined with native SQL transaction log backups to deliver near-instant, low-impact full backups for large SQL…
-
Community
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes? first appeared on Data Savvy.
- Video
-
Blog
Azure SQL Migration Starts in SSMS—All in One Flow
Migrate SQL Server Using SQL Server Management Studio (SSMS) Migrating SQL Server workloads to Azure doesn’t have to be complex or fragmented. SQL Server Management Studio (SSMS) provides a guided, end-to-end migration experience that works seamlessly for…
-
Community
New England SQL Server User Group
View Event: SQL Server 2025: The Future of Data Starts Here SQL Server 2025 isn’t just an upgrade—it’s a leap into the future. With powerful AI-ready capabilities and a suite of modern development tools, this release introduces innovations that enhance…
-
Blog
Expanding Azure Arc SQL Migration with a New Target: SQL Server on Azure Virtual Machines
Modernizing a SQL Server estate is rarely a single-step effort. It typically involves multiple phases, from discovery and assessment to migration and optimization, often spanning on-premises, hybrid, and cloud environments. SQL Server enabled by Azure Arc…
-
Blog
SQL Server Integration Services Projects 2022+ GA
We're pleased to announce the General Availability release of SQL Server Integration Services (SSIS) Projects 2022+, bringing full support for SQL Server 2025 and Visual Studio 2026. With this release, SSIS Projects now supports target server versions from…
-
Blog
Invoke SSIS Package Activity in Microsoft Fabric (Preview)
SQL Server Integration Services (SSIS) has been a cornerstone of enterprise data integration for decades, powering mission-critical ETL workloads across thousands of organizations worldwide. Now Invoke SSIS Package activity (Preview) in Data Factory in…
-
Community
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL Server 2025. The latest version of mirroring that uses the SQL Server Change Feed is reading from the database transaction logs and pushing the data to a landing zone…
-
Blog
FabCon and SQLCon 2026: Unifying databases and Fabric on a single data platform
Welcome to the third annual FabCon and our first ever SQLCon here in Atlanta, Georgia. With nearly 300 workshops and sessions, this joint event will highlight how they are bringing the power of Microsoft SQL and Microsoft Fabric together to create a single…
-
Blog
Advancing agentic AI with Microsoft databases across a unified data estate
Built on a consistent Microsoft SQL foundation from on premises to the cloud, Azure SQL brings AI capabilities directly into your database experience. The post Advancing agentic AI with Microsoft databases across a unified data estate appeared first on…
-
Community
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture (CDC). That is still what is used to mirror SQL Server 2016 – 2022. SQL Server 2025 has a much better solution: the change feed. The post How Fabric Mirroring Transformed…
-
Blog
Release Announcement of SQL Server Migration Assistant (SSMA) v10.5
We’re pleased to announce the release of SQL Server Migration Assistant (SSMA) v10.5, delivering meaningful improvements across multiple flavours of SSMA to further simplify and de‑risk database modernization to Azure SQL and SQL Server. This release focuses…
-
Blog
SSMA Copilot for SAP ASE (Sybase)
Introduction SAP ASE (formerly Sybase) continues to power mission‑critical workloads across financial services, telecom, and large-scale enterprise applications. However, as modernization accelerates, more customers are actively seeking reliable and automated…
-
Blog
Zero downtime migration from SQL Server to Azure SQL Database
For many enterprises, moving SQL Server workloads to Azure SQL Database is a critical step in their journey to cloud modernization. Yet, migrating mission-critical databases without disrupting operations can be challenging. Downtime, data drift, and…
-
Blog
Deep dive into the SSMA Code Conversion Copilot Architecture
The Problem We Set Out to Solve Migrating from Oracle PL/SQL to SQL Server T‑SQL is notoriously complex. While SSMA’s rule engine covers hundreds of conversion rules, edge cases, custom logic, and nuanced syntax but it often slips through. Developers end up…
-
Blog
Handling Sybase BIGTIME Data Type During Migration to Azure SQL
Introduction Migrating databases from Sybase to SQL Server or Azure SQL is a common modernization scenario. However, not all Sybase data types have direct equivalents in SQL Server, and one such challenge is the BIGTIME data type. The BIGTIME data type in…
-
Blog
Data Migration Strategies for Large-Scale Sybase to SQL Migrations Using SSMA, SSIS and ADF- Part 1
Introduction In today’s data-driven landscape, the migration of databases is a crucial task that requires meticulous planning and execution. Our recent project for migrating data from Sybase ASE to MSSQL set out to illuminate this process, using tools like…
-
Blog
Data Migration Strategies for Large-Scale Sybase to SQL Migrations Using SSMA, SSIS and ADF- Part 2
Introduction In today’s data-driven landscape, the migration of databases is a crucial task that requires meticulous planning and execution. Our recent project for migrating data from Sybase ASE to MSSQL set out to illuminate this process, using tools like…
-
Blog
How the Microsoft SQL team is investing in SQL tools and experiences
Microsoft is modernizing SQL tools with AI, SSMS, Visual Studio Code, and DevOps features to boost productivity and future-proof development. The post How the Microsoft SQL team is investing in SQL tools and experiences appeared first on Microsoft SQL Server…
-
Blog
SQL Server Integration Services 2025 General Availability
Alongside with the general availability of SQL Server 2025, SQL Server Integration Services is now generally available. Enterprise security Microsoft SqlClient Data Provider Support Microsoft.Data.SqlClient offers a modern, secure, and future-ready data…