Azure SQL
Azure SQL Database, SQL Managed Instance and SQL Server on Azure VMs.
Nothing in this view matches those filters.
-
Blog
How to Chunk Documents in Azure SQL Database for RAG
Quick answer Azure SQL Database can split text into fixed-size chunks using AI_GENERATE_CHUNKS, with the OVERLAP percentage controlling repeated text between chunks. Store embeddings generated through an external Azure OpenAI endpoint in VECTOR columns, then…
-
Release
go-sqlcmd v1.11.0
1.11.0 (2026-11-18) Features add ASCII table query output format (#609) (91fa9f7) add devcontainer for VS Code and GitHub Codespaces (#692) (bdc375d) implement -j raw-errors flag for ODBC sqlcmd compatibility (#759) (6879335) remove Azure SQL Edge support…
-
Release
vscode-mssql MSSQL v1.48.0
Version 1.48.0 Release date: November 17, 2026 Release status: GA What's new in 1.48.0 Released the Query Results Grid as generally available (GA), with filtering, column visibility, and frozen columns. The classic grid and the mssql.preview.betaResultsGrid…
-
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…
-
Preview
AI-powered application and database modernization with Modernize CLI
Modernize CLI brings application and database modernization together as one connected, agentic journey. It assesses application architecture, dependencies, and cloud readiness while discovering the databases the application relies on and invoking speciali…
-
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
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 .
-
Community
Load Testing Azure SQL Hyperscale
Reitse Eskens cranks up the speed: My previous post on load testing Azure SQL covered the Business Critical tier; let’s move to the one that…
-
Community
Digging into the Azure SQL Database Container
Anthony Nocentino takes a peek under the hood: Today at Ignite, Microsoft announced the public preview of the Azure SQL Database container. The line in…
-
Release
mssql-python 1.18.0
mssql-python 1.18.0 This release improves fetching and repeated-query performance, adds custom application names, and strengthens pooled connection and Arrow reader reliability. Release Highlights Faster Fetching and Repeated Queries (#847, #858, #852, #891…
-
Blog
Strengthening Ransomware Resilience with Immutable Backups in Azure SQL DB and Azure SQL MI
Ransomware attacks are becoming increasingly sophisticated. Attackers no longer focus only on encrypting or stealing production data. They also target backups, knowing that eliminating an organization's recovery options can turn a security incident into a…
-
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…
-
Blog
Build locally with Azure SQL Database container, now in public preview
Azure SQL Database container: build locally, test continuously, ship to Azure. Today at Microsoft Ignite, we’re announcing the public preview of Azure SQL Database container—bringing the Azure SQL Database engine into your local development workflow. Build…
-
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…
-
Preview
Azure SQL DB Hyperscale Cross Database Querying
Native cross-database queries in Azure SQL Database Hyperscale let applications access and join data across databases in the same Hyperscale elastic pool on a logical server, using familiar T-SQL three-part names such as `database.schema.object`. This ena…
-
Blog
Database Hub in Microsoft Fabric is generally available: your entire database estate in one place
As applications grow, so does the database estate behind them. Many organizations now run hundreds or thousands of databases across cloud, hybrid and multicloud environments. The signals are already there: inventory, health, performance, security, risk and…
-
Blog
MSSQL Extension for VS Code: Local Azure SQL Database Provisioning, Query Performance Dashboard, and more
A local database is a useful starting point, but deploying it and understanding how queries behave should fit into the same development workflow. The MSSQL extension for VS Code v1.48 brings three new public previews: Azure SQL Database local container…
-
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
Azure Managed Redis database integration guidance
Improved database integration guidance for Azure Managed Redis helps you add caching to applications built with Azure Database for PostgreSQL flexible server, Azure Cosmos DB, and Azure SQL. You can use practical guidance, reference architectures, and ste…
-
Preview
MSSQL extension for Visual Studio Code performance dashboard
The new query performance dashboard, now in public preview in the MSSQL extension for VS Code, leverages Query Store to surface performance insights, analyze trends, investigate execution plans, and optimize queries with GitHub Copilot.Learn more.
-
GA
Azure SQL Managed Instance updates for mid-November 2026
In mid-November 2026, the following updates and enhancements were made to Azure SQL Managed Instance: Boost transaction throughput in Next-gen General Purpose Azure SQL Managed Instance with increased log rates of up to 220 MiB/s and higher pe…
-
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
MSSQL extension for Visual Studio Code - local-to-cloud deployment wizard
The MSSQL extension now provides a guided local-to-cloud deployment experience for Azure SQL Database. You can move from a local Azure SQL Database container to the cloud directly from Visual Studio Code. The wizard supports schema-only or schema-and-data…
-
GA
Azure SQL updates for mid-November 2026
In mid-November 2026, the following updates and enhancements were made to Azure SQL: Fuzzy string matching enables you to compare strings based on similarity rather than relying only on exact matches. Using built-in functions, you can m…
-
Preview
MSSQL extension for Visual Studio Code- Azure SQL Database container provisioning
The MSSQL extension now supports the Azure SQL Database container, making it easy to create and manage a cloud-aligned local database environment directly in Visual Studio Code. With automatic runtime detection across Docker, WSL, Apple containers, Podman…
-
GA
Zone-redundant Next-gen GP tier in Azure SQL Managed Instance
Zone redundancy for the Next-gen General Purpose service tier helps improve the resiliency of Azure SQL Managed Instance by distributing critical service components across availability zones. This update helps you protect applications against zonal failur…
-
Preview
Build with Azure SQL Database container locally without an Azure subscription or credit card
You can now build and test applications using Azure SQL Database container, which runs the same Azure SQL Database engine locally that you run in the cloud. It’s free for local dev and CI, with no Azure subscription or credit card required. This cross-pl…
-
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,…
-
GA
Transparent data encryption (TDE) in Azure SQL Database AES keys
You can now use AES-256 keys stored in Azure Key Vault Premium or Managed HSM as TDE protectors, providing an alternative to RSA keys for protecting data at rest. While RSA may remain secure against today’s classical computing capabilities, advances in qu…
-
Blog
What's new in databases at Microsoft Ignite 2026: AI-ready data for apps and agents
By Shireesh Thota, Corporate Vice President, Azure Databases and Fabric Applications, Microsoft Organizations putting agents to work are learning quickly that an agent is only as good as the business context behind it. That context starts with trusted…
-
Blog
Take control of transparent data encryption scans: suspend and resume now in preview
Suspend and resume for transparent data encryption (TDE) scans in Azure SQL Database lets you temporarily halt an encryption scan during busy periods and continue it later from the exact point where it stopped, instead of starting over. Why we built it TDE…
-
Blog
Azure SQL Managed Instance gets a boost: New capabilities in Next-gen General Purpose
When we introduced Next-gen General Purpose for Azure SQL Managed Instance, our goal was a faster General Purpose tier: by moving the data and log storage layer to Azure Elastic SAN, it enables higher performance, greater scale, and more flexible resource…
-
Blog
Azure SQL Hyperscale Cross-database querying: now in limited preview
Today, we're announcing the limited preview of Azure SQL Database Hyperscale Cross Database querying. Use familiar [database].[schema].[object] names to query across databases in the same Hyperscale elastic pool from the same client connection. Keep your…
-
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
SqlPackage Deployment History and Fast Comparison Preview
Database deployments should be repeatable. A SQL database project describes the desired schema, its build produces a .dacpac, and SqlPackage compares that model with a target database to work out the changes to apply. But what happens when a pipeline…
-
Blog
What’s new across Microsoft SQL at Microsoft Ignite 2026
From Microsoft Ignite I’m here in San Francisco enjoying specialty lattes, fall-ish weather (I guess?), and all the excitement around Microsoft announcements at Ignite 2026. It’s a cool energy to be surrounded by so many people at organizations that are…
-
Preview
SQL performance monitoring for Azure SQL Managed Instance
The public preview of Microsoft-managed performance monitoring for Azure SQL Managed Instance is now available. Customers monitoring business-critical SQL Managed Instance workloads often rely on custom scripts and disconnected monitoring tools. This requ…
-
Blog
Ask your database estate a question: Copilot in Database Hub is now in public preview
Most database teams already collect a lot of monitoring data. What they don't have enough of is time to work out what it means. When something looks wrong, the first job is usually to open several portals, find the affected resources, and work out what…
-
Blog
Resources for the SQL AI Developer
I see three agentic stories shaping SQL’s future. Here’s how DP-800 connects the pieces and helps you build the skills to put SQL’s AI capabilities to work. The post Resources for the SQL AI Developer appeared first on Azure SQL Dev Corner.
-
Blog
What’s new across Microsoft SQL in 2026 so far: the PASS Summit West roundup
[almost] A year of building on Microsoft SQL – 2026 I’m back with a really long and exhaustive list of updates across Microsoft SQL in 2026. This time I’m tuning in from PASS Summit West, and I actually did this blog as a session with other members from the…
-
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
How do you run a query against data the database can’t read?
Under the Hood: The Research Behind Microsoft SQL, part 3 Encryption at rest solves one threat. It stops someone who walks off with the disk. It does nothing about someone with administrative access to the running server, because the database decrypts data…
- Video
-
Blog
New ransomware recovery guidance for Azure SQL Database and Azure SQL Managed Instance
Prepare before an attack, respond during one, and recover after. We've published new ransomware recovery guidance for Azure SQL Database and Azure SQL Managed Instance on Microsoft Learn. The new guidance provides an end-to-end recovery framework, from…
-
Release
mssql-python v1.17.0
mssql-python 1.17.0 This release makes bulk copy more reliable, improves connection-pool performance and recovery, corrects multi-result row counts, and restores PEP 249 Timestamp() compatibility. Release Highlights More Reliable Bulk Copy (#860, #875) What…
-
Blog
Database watcher for Azure SQL is retiring: simplify your monitoring with Database Hub
Today we're announcing the retirement of database watcher for Azure SQL Database and Azure SQL Managed Instance. This includes monitoring for databases in elastic pools. Database watcher won't move to general availability. Database Hub in Microsoft Fabric…
-
Blog
Managing security with Database Hub in Fabric: From signals to action
As organizations embrace AI, cloud modernization, and increasingly complex application architectures, the database estate continues to grow. What was once a handful of databases can quickly become hundreds or thousands of resources spread across…
-
Blog
Public Preview: Alerts for Azure SQL Database in Database Hub, powered by Fabric Activator
We're excited to announce the public preview of alerts for Azure SQL Database in Database Hub, powered by Fabric Activator. Last month, we brought performance monitoring for Azure SQL to Database Hub. That gave you one place to see how your databases are…
-
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
Modern Query Editor for Azure SQL Database is now generally available
We're pleased to announce the general availability of Query Editor for Azure SQL Database. The updated experience brings a multi-tab query workspace, easier database exploration, and more interactive query results directly to the Azure portal, with no desktop…
-
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…
-
Release
vscode-mssql MSSQL v1.47.0
Version 1.47.0 Release date: October 21, 2026 Release status: GA What's new in 1.47.0 Released the MSSQL Getting Started page as generally available (GA), with one-click Microsoft SQL Agent skills installation, dev container templates, walkthroughs, and…
-
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
Make Estate yours: Focus on the databases and issues you own in Database Hub
Database Hub in Microsoft Fabric is now in public preview. Estate experience brings every supported database you can access into one inventory, with the issues and suggestions found across them. In a large organization, that can mean thousands of resources…
-
Release
mssql-python v1.16.0
mssql-python 1.16.0 This release expands platform coverage with Python 3.15, first ever conda release, introduces a new opt-in mssql-odbc provider, improves row and fetch performance, strengthens native runtime packaging, and addresses connection, encoding…
-
Blog
Database Hub in Fabric: Now in Public Preview -Turn Database Signals into Guided Action
As applications grow, so does the database estate behind them. What starts with a handful of databases can become hundreds or thousands of resources spread across services, subscriptions, and environments. For the teams responsible for keeping them healthy…
-
Blog
Azure SQL Database is retiring Always Encrypted with Intel SGX enclaves
On October 31, 2027, Azure SQL Database will retire Intel Software Guard Extensions (SGX) enclave functionality for Always Encrypted. Workloads that still depend on Intel SGX enclaves after that date will no longer work as configured. The path forward is…
-
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
Public Preview: Auto-pause and auto-resume for Azure SQL Database Hyperscale Serverless
Auto-pause and auto-resume are now available in public preview for Azure SQL Database Hyperscale databases using the Serverless compute tier. With auto-pause enabled, a database can automatically pause during periods of inactivity and resume when activity…
-
Blog
Migrate to Azure SQL Database, including Hyperscale, straight from Azure Arc (public preview)
The challenge Most organisations do not run in one place. Estates stretch across on-premises datacentres, hybrid deployments and the cloud, and every migration decision must balance application dependencies, operational requirements and a modernization…
-
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…
-
Release
vscode-mssql MSSQL v1.46.0
Note This version of the MSSQL for VS Code extension is only compatible with SQL Database Projects v1.8.0 (and higher) and Data Workspace v0.7.0 (and higher). Please update all three extensions together to these minimum versions. Version 1.46.0 Release date…
-
Blog
Azure SQL DB HS Data Load Using Microsoft JDBC Driver Instead of Apache Spark Connector for SQL
Introduction Migration from heterogeneous database platforms such as Db2, Oracle, and Sybase to Microsoft SQL platforms has been a common modernization pattern for many years. For large-volume data migrations, customers commonly extract data from the source…
-
Release
DacFx Microsoft.Build.Sql 2.3.0
Build 2.3.0 Release date: September 16th, 2026 Release status: GA Release Notes: https://github.com/microsoft/DacFx/blob/main/release-notes/Microsoft.Build.Sql/2.3.0.md NuGet Package: https://www.nuget.org/packages/Microsoft.Build.Sql/2.3.0…
-
Release
mssql-python v1.15.0
Enhancements • Faster setinputsizes() Execution (#736) What changed: Routed setinputsizes() parameter handling through the native C++ execution pipeline. Who benefits: Applications with wide, batched, or frequently executed parameterized statements. Impact…
-
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…
-
Release
mssql-python v1.14.0
Enhancements • Faster Parameter Detection and Execution (#549) What changed: Parameter type detection and binding now run in a single native C++ pipeline, removing per-parameter Python and pybind11 overhead from the standard execute() path. Who benefits…
-
Release
go-sqlcmd v0.0.1001: deps: apply vulnerability remediation upgrades (#802)
Co-authored-by: Saurabh Singh (SQL Drivers) singhsaura@microsoft.com Co-authored-by: Copilot App 223556219+Copilot@users.noreply.github.com Copilot-Session: c64a996d-d9f1-41d2-89bb-a00dd0670207…
-
Blog
Power Azure SRE Agent with the tools it needs
Use Azure Connector Namespace to host MCP servers and give Azure SRE Agent access to the operational tools it needs without managing the server infrastructure yourself. The post Power Azure SRE Agent with the tools it needs appeared first on Azure SDK Blog.
-
Release
vscode-mssql MSSQL v1.45.1
Version 1.45.1 Release date: August 26, 2026 Release status: GA What's new in 1.45.1 Improved cell selection in the new Query Results Grid (Preview) to match the familiar classic grid experience, including support for multi-cell selection with Ctrl/Cmd+click…
-
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…
-
Release
mssql-python v1.13.0
Enhancements • ODBC Driver Now Ships Exclusively via mssql-python-odbc — Phase 2 Complete (#693) What changed: The bundled libs/ fallback introduced in v1.12.0 has been removed. mssql-python now hard-depends on mssql-python-odbc==18.6.2.1 (declared in…
-
Release
mssql-python v1.12.0
Enhancements • Standalone mssql-python-odbc Package for ODBC Driver Binaries (#663, #687) What changed: The ODBC driver binaries that mssql-python needs at runtime are now also published as a separate, pure-data companion package called mssql-python-odbc…
-
Blog
Redefining Database Maintenance after Migrating from Db2 on Mainframe to Azure SQL DB Hyperscale
Introduction Migrating from Db2 z/OS to Azure SQL Database Hyperscale is a major step toward modernizing your mainframe relational data infrastructure to Azure Data SQL managed relational database offering. But what happens to all those daily and periodic Db2…
-
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…
-
Release
mssql-python v1.11.0
Bug Fixes • SSH-tunnel / in-process forwarder deadlock (#604) What changed: The driver now releases the GIL around blocking ODBC network round-trips that previously held it — the teardown path (SQLFreeHandle / SQLFreeStmt(SQL_CLOSE) when closing a statement…
-
Release
mssql-python v1.10.0
Enhancements • Active Directory Service Principal support for Bulk Copy (#576) What changed: bulkcopy now supports Authentication=ActiveDirectoryServicePrincipal. Because the tenant ID is only discoverable from the STS URL the server returns mid-handshake…
-
Release
mssql-python v1.9.0
Enhancements • Accept Row objects in bulk copy (#615) What changed: bulkcopy now accepts Row objects and lists directly, converting each row to a tuple internally before passing data to the Rust backend, instead of requiring manually constructed tuples. Who…
-
Release
DacFx Microsoft.Build.Sql 2.2.0
Build 2.0.0 Release date: June 6th, 2026 Release status: GA Release Notes: https://github.com/microsoft/DacFx/blob/main/release-notes/Microsoft.Build.Sql/2.2.0.md NuGet Package: https://www.nuget.org/packages/Microsoft.Build.Sql/2.2.0…
-
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…
-
Release
go-sqlcmd v1.10.0: update go-mssqldb (#715)
Changes: affbc17 update go-mssqldb (#715) dadb2d8 LEGO: Pull request from juno/hb_d639428f-b4f7-44e1-9f59-4eea699b1621_20260211051845082 to main (#714) cc0cf95 deps(deps): bump golang.org/x/tools from 0.41.0 to 0.42.0 (#709) d5ae81b LEGO: Pull request from…
-
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
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…
- Video
-
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…
-
Release
DacFx Microsoft.Build.Sql 2.1.0
Build 2.0.0 Release date: February 10th, 2026 Release status: GA Release Notes: https://github.com/microsoft/DacFx/blob/main/release-notes/Microsoft.Build.Sql/2.1.0.md NuGet Package: https://www.nuget.org/packages/Microsoft.Build.Sql/2.1.0…
-
Blog
Azure SQL’s Native JSON Type: Optimized for Performance
Introduction JSON has become the de-facto format for modern applications from web APIs to microservices and event-driven systems. Azure SQL has supported JSON for years, but JSON was treated just like text (stored as nvarchar or varchar). That meant every…
-
Blog
Alternatives After the Deprecation of the Azure SQL Migration Extension in Azure Data Studio
The Azure SQL Migration extension for Azure Data Studio is being deprecated and will be retired by February 28, 2026. As part of our unified and streamlined migration strategy for Azure SQL, we are consolidating all migration experiences into a consistent…
-
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…
-
Release
fabric-cicd v0.1.34
✨ Enable dynamic replacement of SQL endpoint values from SQL Database items (#720) ✨ Support Fabric Notebook Authentication (#707) ✨ Onboard Spark Job Definition item type (#115) 📝 Add CONTRIBUTING.md file to repository (#723) 📝 Add comprehensive…
-
Blog
Zero downtime migration from Oracle to Azure SQL
Modernizing mission-critical Oracle applications often involves moving underlying Oracle databases into a fully managed cloud service with near zero downtime. For many organizations, Azure SQL provides the reliability, scale, and operational simplicity needed…
-
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
Implementing Oracle Autonomous Transactions in Azure SQL for Seamless Logging
In Oracle PL/SQL, the directive PRAGMA AUTONOMOUS_TRANSACTION allows a block of code such as a procedure, function, or trigger to run in its own independent transaction. This means: It can commit or rollback changes without affecting the main transaction. It…
- Video
-
Blog
Faster Data Copy between Source and target for partitioned table using Partition Switch in ADF
Introduction This blog post presents a comprehensive Azure Data Factory (ADF) solution for automating the migration of partitioned tables from IBM Db2 z/OS to Azure SQL Database. The solution consists of two main components: a Partition Discovery &…
-
Release
DacFx Microsoft.Build.Sql 2.0.0
Build 2.0.0 Release date: October 15th, 2025 Release status: GA Release Notes: https://github.com/microsoft/DacFx/blob/main/release-notes/Microsoft.Build.Sql/2.0.0.md NuGet Package: https://www.nuget.org/packages/Microsoft.Build.Sql/2.0.0…
- Video
-
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…
-
Release
go-sqlcmd v1.9.0
Changes: 310b400 Localized file check-in by OneLocBuild Task: Build definition ID 51965: Build ID 181243959 (#600) bd5a47d LEGO: Pull request from juno/hb_d639428f-b4f7-44e1-9f59-4eea699b1621_20250714205939751 to main (#599) 58af949 LEGO: Pull request from…