Eitan Blumin ⚡
@eitanblumin.bsky.social
#Microsoft #Data Platform #MVP, Speaker, @SQLServerRadio #podcast co-host, CTO and Expert #SQLServer #DBA at Madeira Data Solutions. Follow me for news and insights!
A Programmatic Interface to the Query Hint Recommendation Tool techcommunity.microsoft.com/blog/sqlserv... #Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData
Programmatic Hint Identification using the Query Hint Recommendation Tool
Learn how to programmatically determine the optimal hint for a query using a PowerShell script and the Query Hint Recommendation Tool, available in SSMS 22.
techcommunity.microsoft.com
#SQLServer 2016 end of support is here: Plan your next steps www.microsoft.com/en-us/sql-se... #Microsoft #AzureSQL #SqlDBA #MadeiraData
SQL Server 2016 end of support is here: Plan your next steps - Microsoft SQL Server Blog
See what changes as SQL Server 2016 reaches end of support. Choose between cloud migration, upgrading SQL Server, and Extended Security Updates (ESU).
microsoft.com
Generally Available: SQL Migration to #SQLServer on #Azure Virtual Machines in Azure Architecture techcommunity.microsoft.com/blog/azuresq... #Microsoft #AzureSQL #SqlDBA #MadeiraData
Generally Available: SQL Migration to SQL Server on Azure Virtual Machines in Azure Architecture | Microsoft Community Hub
One Migration Experience, More Flexibility Modernizing SQL Server estates is rarely a single-step journey. Organizations often operate across on-premises,...
techcommunity.microsoft.com
#Claude in #Microsoft #Foundry is now generally available azure.microsoft.com/en-us/blog/c... #AI #MadeiraData
Claude in Microsoft Foundry is now generally available | Microsoft Azure Blog
Claude in Microsoft Foundry is now generally available, giving teams a faster path from agent experimentation to production.
azure.microsoft.com
Fundamentals of #Azure #DevOps with SQL projects devblogs.microsoft.com/azure-sql/fu... #Microsoft #SQLServer #SqlDBA #SSDT #MadeiraData
Fundamentals of Azure DevOps with SQL projects - Azure SQL Dev Corner
Building automated pipelines with your SQL database projects enables you to build a rich CI/CD ecosystem to ensure that your application is being deployed
devblogs.microsoft.com
Audit Frontier #AI Agents with SQL #MCP Server devblogs.microsoft.com/azure-sql/sq... #Microsoft #SQLServer #AzureSQL #MadeiraData
Audit Frontier AI Agents with SQL MCP Server - Azure SQL Dev Corner
Learn how SQL MCP Server uses OBO authentication to preserve user identity, enforce Data API builder permissions, and audit AI agent activity in Azure SQL.
devblogs.microsoft.com
What’s new across #Microsoft SQL in 2026 so far (#SQLServer, #AzureSQL, and SQL database in #Fabric) devblogs.microsoft.com/azure-sql/wh... #SqlDba #MadeiraData
What’s new across Microsoft SQL in 2026 so far (SQL Server, Azure SQL, and SQL database in Fabric) - Azure SQL Dev Corner
We’re halfway through 2026, and Microsoft SQL has not slowed down. Since SQLCon/FabCon in March (where we released a ton of things, and those updates can
devblogs.microsoft.com
3 Reasons Enterprise #SQLServer Migrations Slow Down - and How to Avoid Them techcommunity.microsoft.com/blog/azuresq... #Microsoft #SqlDBA #MadeiraData
3 Reasons Enterprise SQL Server Migrations Slow Down - and How to Avoid Them | Microsoft Community Hub
Summary Many of Enterprises around the globe have relied on SQL Server for over 3 decades to run their mission critical business applications. Their SQL...
techcommunity.microsoft.com
The performance dividend: Optimizing #PostgreSQL on #Azure directly in Visual Studio Code azure.microsoft.com/en-us/blog/t... #Microsoft #VisualStudio #VSCode #AzureSQL #MadeiraData #HorizonDB
mssql-python 1.10.0: Service Principal Bulk Copy, More Reliable Arrow Text, and a Core Timeout Fix techcommunity.microsoft.com/blog/sqlserv... #Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData #Python
mssql-python 1.10.0: Service Principal Bulk Copy, More Reliable Arrow Text, and a Core Timeout Fix | Microsoft Community Hub
We have released mssql-python 1.10.0 with improvements focused on authentication flexibility, cross-platform text reliability, and bulk load...
techcommunity.microsoft.com
#SQLServer 2016 reaches the end of extended support on July 14, 2026 techcommunity.microsoft.com/blog/sqlserv... #Microsoft #SqlDBA #MadeiraData
SQL Server 2016 Extended Security Updates: Stay Protected While You Modernize | Microsoft Community Hub
SQL Server 2016 reaches the end of extended support on July 14, 2026. After that date, instances that remain on SQL Server 2016 no longer receive regular...
techcommunity.microsoft.com
Generally Available: #Microsoft #Entra Server Principals and Server Roles for #AzureSQL #Database techcommunity.microsoft.com/blog/azuresq... #SQLServer #SqlDBA #MadeiraData
Generally Available: Microsoft Entra Server Principals and Server Roles for Azure SQL Database | Microsoft Community Hub
The problem we're solving Previously, Microsoft Entra identities in Azure SQL Database could only be created as contained database users - principals scoped...
techcommunity.microsoft.com
Introducing Execution Context for #GitHub #Copilot in #SSMS techcommunity.microsoft.com/blog/sqlserv... #Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData
Introducing execution context for GitHub Copilot in SSMS
Introducing execution context for GitHub Copilot in SSMS, which allows you to specify a database user or SQL login for the execution of queries.
techcommunity.microsoft.com
In case you missed it, #Microsoft announced the Release of #SSMS 22.7.0 techcommunity.microsoft.com/blog/sqlserv... #SQLServer #AzureSQL #SqlDBA #MadeiraData
Announcing the Release of SSMS 22.7.0 - and many previews! | Microsoft Community Hub
Today we shipped SQL Server Management Studio (SSMS) 22.7.0, and this is one of the bigger releases we've had in a while. The headline items are we’ve...
techcommunity.microsoft.com
Finally, a new #Blog post! It's been a while! 😅 Which title is better? One Regrow Back, Two Shrinks Forward? or Two Shrinks Forward, One Regrow Back? eitanblumin.com/2026/06/25/o... #Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData
One Regrow Back, Two Shrinks Forward - Eitan Blumin's blog
Ever ran DBCC SHRINKFILE, watched it finish without a single error… and then discovered that your file is exactly the… Read More »One Regrow Back, Two Shrinks Forward
eitanblumin.com
Transparent data encryption in #AzureSQL Database now supports #AES keys (Public Preview) techcommunity.microsoft.com/blog/azuresq... #Microsoft #SQLServer #TDE #MadeiraData
Transparent data encryption in Azure SQL Database now supports AES keys (Public Preview) | Microsoft Community Hub
For teams thinking about long-term cryptographic resilience, this preview is especially relevant. TDE with customer-managed keys has traditionally used...
techcommunity.microsoft.com
MSSQL Extension for #VSCode: #AzureSQL Database Provisioning and More devblogs.microsoft.com/azure-sql/vs... #Microsoft #SQLServer #MadeiraData
MSSQL Extension for VS Code: Azure SQL Database Provisioning and More - Azure SQL Dev Corner
The MSSQL extension for VS Code v1.43 expands what’s possible inside Visual Studio Code with the General Availability of Schema Designer with GitHub
devblogs.microsoft.com
mssql-python 1.8.0: friendlier Row access, Bulk Copy with MSI, and a refreshed #ODBC driver techcommunity.microsoft.com/blog/sqlserv... #Microsoft #SQLServer #Python #AzureSQL #MadeiraData
mssql-python 1.8.0: friendlier Row access, Bulk Copy with MSI, and a refreshed ODBC driver | Microsoft Community Hub
We just shipped mssql-python 1.8.0, the official Microsoft SQL Server driver for Python. This release focuses on day-to-day ergonomics, a long-requested...
techcommunity.microsoft.com
#SQL + #AI, hands-on: Join a free workshop near you devblogs.microsoft.com/azure-sql/sq... #Microsoft #SQLServer #AzureSQL #MadeiraData
SQL + AI, hands-on: Join a free workshop near you - Azure SQL Dev Corner
Unlock the potential of AI in your apps with SQL. Join our free workshops to enhance your existing projects effortlessly.
devblogs.microsoft.com
Regex support for LOB types in #TSQL—available in #AzureSQL & #SQLServer2025 devblogs.microsoft.com/azure-sql/re... #Microsoft #SQLServer #MadeiraData
Regex support for LOB types in T-SQL—available in Azure SQL & SQL Server 2025 - Azure SQL Dev Corner
At a glance — Native regular expression (regex) functions in T-SQL now accept varchar(max) and nvarchar(max) inputs of up to 2 MB across all seven regex functions, including the two table-valued…
devblogs.microsoft.com
#AzureSQL Managed Instance begins automated testing for loss of internal connectivity techcommunity.microsoft.com/blog/azuresq... #Microsoft #SQLServer #MadeiraData
techcommunity.microsoft.com
Generate Embeddings Function and External Model Object Support Are Now Generally Available in #AzureSQL devblogs.microsoft.com/azure-sql/ge... #Microsoft #SQLServer #AI #MadeiraData
Generate Embeddings Function and External Model Object Support Are Now Generally Available in Azure SQL - Azure SQL Dev Corner
We are excited to announce the General Availability (GA) of AI_GENERATE_EMBEDDINGS and CREATE EXTERNAL MODEL in Azure SQL Database and Azure SQL Managed Instance. These two T-SQL features — CREATE…
devblogs.microsoft.com
SQL #MCP Server as an App Service devblogs.microsoft.com/azure-sql/sq... #Microsoft #SQLServer #AzureSQL #AI #OpenAI #MadeiraData
SQL MCP Server as an App Service - Azure SQL Dev Corner
Host SQL MCP Server on Azure App Service without containers using Data API builder. Configure DAB, expose MCP, REST, and GraphQL, and deploy as code.
devblogs.microsoft.com
Some behind the scenes on the Automatic Query Tuning feature in #SQLServer techcommunity.microsoft.com/blog/sqlserv... #Microsoft #AzureSQL #Database #SqlDBA #MadeiraData
Query plan regressions got you down? Here's how can Automatic Plan Correction turns it around. | Microsoft Community Hub
Automatic Plan Correction (APC) is one of the features that I find myself talking about quite a bit with customers, support engineers, and the broader SQL...
techcommunity.microsoft.com
#Azure Data Studio is retired: Move your #AzureSQL workflow to #VSCode in 10 minutes devblogs.microsoft.com/azure-sql/az... #Microsoft #SQLServer #SqlDBA #MadeiraData
Azure Data Studio is retired: Move your Azure SQL workflow to VS Code in 10 minutes - Azure SQL Dev Corner
Azure Data Studio (ADS) retired on February 6, 2025, and support ended on February 28, 2026. The recommended path forward is Visual Studio Code with the MSSQL extension. If you used ADS daily, this…
devblogs.microsoft.com
Introducing #Azure Accelerate for #Databases: Modernize your data for #AI azure.microsoft.com/en-us/blog/i... #Microsoft #SQLServer #AzureSQL #SQLDBA #MadeiraData
Dynamic Data Masking – What it is, What it isn’t, and How to use it effectively techcommunity.microsoft.com/blog/azuresq... #Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData
Dynamic Data Masking – What it is, What it isn’t, and How to use it effectively | Microsoft Community Hub
In this post, we’ll explain the core purpose of Dynamic Data Masking (to ease application development), how it works, and its proper use cases – as well as...
techcommunity.microsoft.com
Announcing #SQLServer Management Studio 22.5 - with #SSDT integration! techcommunity.microsoft.com/blog/sqlserv... #Microsoft #AzureSQL #SSMS #SqlDBA #MadeiraData
SSMS 22.5 Release
SSMS 22.5 is now available and includes improvements for SQL projects, the Migration component, the connection dialog, and support for interactions with the...
techcommunity.microsoft.com
#Microsoft is introducing SQL #MCP Server - a feature of Data API builder devblogs.microsoft.com/azure-sql/in... #SQLServer #AI #OpenAI #Database #SqlDBA #MadeiraData
Introducing SQL MCP Server - Azure SQL Dev Corner
SQL MCP Server gives enterprises a secure, feature-rich way to enable agents to access data. This is accomplished without exposing the schema, risking consistency, or relying on fragile natural…
devblogs.microsoft.com
#AzureSQL Retiring The No Minimum TLS Option: TLS 1.2 will become the secure default minimum #TLS version for new #Azure SQL DB and MI configurations techcommunity.microsoft.com/blog/azuresq... #Microsoft #SQLServer #MadeiraData
Azure SQL Retiring The No Minimum TLS Option
As part of the retirement of lower TLS versions 1.0 and 1.1 and the enforcement of 1.2 as the new default minimum TLS version, Azure SQL will be removing the...
techcommunity.microsoft.com