#MadeiraData
LightNews LightNews
eitanblumin.bsky.social
General Availability Announcement: #Regex Support in #SQLServer2025 & #AzureSQL

techcommunity.microsoft.com/blog/azuresq...

#Microsoft #SQLServer #Azure #Database #MadeiraData
General Availability Announcement: Regex Support in SQL Server 2025 & Azure SQL | Microsoft Community Hub
We’re excited to announce the General Availability (GA) of native Regex support in SQL Server 2025 and Azure SQL — a...
techcommunity.microsoft.com
November 12, 2025 at 11:01 AM
eitanblumin.bsky.social
Announcing the release of SQL Server Management Studio 22.1
techcommunity.microsoft.com/blog/sqlserv...

#Microsoft #SQLServer #AzureSQL #SqlDba #MadeiraData
SSMS 22.1 Release
SSMS 22.1 is now available and includes improvements and updates for GitHub Copilot in SSMS, and a set of fixes for SSMS.
techcommunity.microsoft.com
January 5, 2026 at 11:00 AM
eitanblumin.bsky.social
Announcing General Availability of the mssql-python Driver
techcommunity.microsoft.com/blog/sqlserv...

#Microsoft #SQLServer #AzureSQL #Python #MadeiraData
Announcing General Availability of the mssql-python Driver | Microsoft Community Hub
We’re thrilled to announce that the mssql-python driver is now Generally Available! 🎉 This milestone marks a major step forward in delivering a modern,...
techcommunity.microsoft.com
December 23, 2025 at 11:01 AM
eitanblumin.bsky.social
Breaking Changes & Migration Risks in #SQLServer2025 - by Rebecca Lewis
www.sqlfingers.com/2025/10/brea...

#Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData
Breaking Changes & Migration Risks in SQL Server 2025
Breaking Changes & Migration Risks in SQL Server 2025 Every new SQL Server release comes with shiny features — but SQL Server 2025...
www.sqlfingers.com
November 5, 2025 at 11:02 AM
eitanblumin.bsky.social
#MSSQL Extension for #VSCode: Introducing Schema Designer (Preview)

devblogs.microsoft.com/azure-sql/vs...

#Microsoft #SQLServer #AzureSQL #MadeiraData
MSSQL Extension for VS Code: Introducing Schema Designer (Preview) - Azure SQL Devs’ Corner
Overview Database design can often feel like navigating a maze of tables, relationships, and data types — especially when working directly with T-SQL scripts. But what if you could map out your…
devblogs.microsoft.com
June 5, 2025 at 10:02 AM
eitanblumin.bsky.social
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
July 13, 2026 at 10:03 AM
eitanblumin.bsky.social
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
July 12, 2026 at 10:01 AM
eitanblumin.bsky.social
More Power with Flexible Memory in #AzureSQL Managed Instance
Customize the memory-to-vCore ratio in your SQL Managed Instance, now in public preview.
techcommunity.microsoft.com/blog/azuresq...

#Microsoft #SQLServer #Azure #MadeiraData
Unlocking More Power with Flexible Memory in Azure SQL Managed Instance | Microsoft Community Hub
As data workloads grow in complexity and scale, so does the need for more adaptable and performant database infrastructure. That’s why we’re excited to...
techcommunity.microsoft.com
July 6, 2025 at 10:01 AM
eitanblumin.bsky.social
Recently released: Updates to #SQLprojects in #SSMS, #VSCode, and #SqlPackage
techcommunity.microsoft.com/blog/azuresq...

#Microsoft #SQLServer #DevOps #SqlDBA #MadeiraData
Recently released: Updates to SQL projects in SSMS, VS Code, and SqlPackage | Microsoft Community Hub
Your database should be part of the same development process as the rest of your application, with source control and automation for validation and...
techcommunity.microsoft.com
August 9, 2026 at 10:00 AM
eitanblumin.bsky.social
Create embeddings in #SQLServer2025 RC0 with a local #ONNX model on Windows
devblogs.microsoft.com/azure-sql/cr...

#Microsoft #SQLServer #OpenAI #AI #MadeiraData
Create embeddings in SQL Server 2025 RC0 with a local ONNX model on Windows - Azure SQL Devs’ Corner
Azure SQL Devs’ Corner - Azure SQL Create embeddings in SQL Server 2025 RC0 with a local ONNX model on Windows
devblogs.microsoft.com
September 2, 2025 at 10:01 AM
eitanblumin.bsky.social
Running Data Factory Pipelines in Logic Apps - By Andy B
andybrownsword.co.uk/2025/10/28/r...

#Azure #ADF #LogicApps #DataEngineering #ETL #Microsoft #MadeiraData
Running Data Factory Pipelines in Logic Apps
When building Azure Logic Apps we can use the Azure Data Factory connector to start a pipeline. However that action simply triggers a pipeline and doesn’t wait for it to finish. If …
andybrownsword.co.uk
November 4, 2025 at 11:02 AM
eitanblumin.bsky.social
OK I'm not sure I'm 100% on-board with this #AI based #TSQL Refactoring: an automatic intelligent code optimization with #Azure #OpenAI
devblogs.microsoft.com/azure-sql/ai...

#Microsoft #SQLServer #AzureSQL #Copilot #MadeiraData
AI-based T-SQL Refactoring: an automatic intelligent code optimization with Azure OpenAI - Azure SQL Devs’ Corner
This article presents an AI-powered approach to automating SQL Server code analysis and refactoring. The system intelligently identifies inefficiencies and common T-SQL anti-patterns, applying best…
devblogs.microsoft.com
September 29, 2025 at 10:01 AM
eitanblumin.bsky.social
Torn Page Detection in SQL Server: A Legacy Feature Worth Knowing for Data Integrity
www.madeiradata.com/post/torn-pa...

#Microsoft #SQLServer #TSQL #MadeiraData
Torn Page Detection in SQL Server: A Legacy Feature Worth Knowing for Data Integrity
Discover Torn Page Detection in SQL Server—its legacy, role in data integrity, and why it’s still worth knowing in modern systems!
www.madeiradata.com
January 2, 2025 at 7:03 AM
eitanblumin.bsky.social
Running #SQLServer 2025 on #Linux Containers in #WSL
techcommunity.microsoft.com/blog/azuresq...

#Microsoft #AzureSQL #Docker #MadeiraData
Running SQL Server 2025 on Linux Containers in WSL | Microsoft Community Hub
Hey there! Ready to dive into the awesome world of SQL Server 2025? This latest release is packed with cool new features and enhancements that you won't want...
techcommunity.microsoft.com
June 9, 2025 at 10:02 AM
eitanblumin.bsky.social
Incremental Resumable Integrity Check for Large Databases

I developed a #TSQL script for performing incremental integrity checks. Check it out:
eitanblumin.com/2024/10/28/i...

#Microsoft #SQLServer #AzureSQL #MadeiraData
Incremental Integrity Check for Large Databases - Eitan Blumin's blog
Traditional database integrity checks in SQL Server can be time-consuming and resource-intensive, especially for large databases, even when using super… Read More »Incremental Integrity Check for Larg...
eitanblumin.com
November 19, 2024 at 8:37 AM
eitanblumin.bsky.social
#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
May 6, 2026 at 10:01 AM
eitanblumin.bsky.social
Stream data changes from #AzureSQL Managed Instance and #Azure #SQL #Database – private preview of CES
techcommunity.microsoft.com/blog/azuresq...

#Microsoft #SQLServer #MadeiraData
Stream data changes from Azure SQL Managed Instance and Azure SQL Database – private preview of CES | Microsoft Community Hub
We’re excited to share that Change Event Streaming (CES) - the capability to stream data changes directly from your SQL into Azure Event Hubs - is now also...
techcommunity.microsoft.com
May 5, 2025 at 10:02 AM
eitanblumin.bsky.social
Check out the Survey for #Copilot in #SSMS
techcommunity.microsoft.com/blog/sqlserv...

#Microsoft #SQLServer #AzureSQL #MadeiraData
Copilot in SSMS Survey
Complete a Copilot in SSMS survey to provide your feedback about functionality for the feature
techcommunity.microsoft.com
June 22, 2025 at 10:01 AM
eitanblumin.bsky.social
New #AI Features in #SQLServer 2025 (6 minute video)
devblogs.microsoft.com/azure-sql/ne...

#Microsoft #AzureSQL #MadeiraData
New AI Features in SQL Server 2025 - Azure SQL Devs’ Corner
New AI Features in SQL Server 2025
devblogs.microsoft.com
June 8, 2025 at 10:01 AM
eitanblumin.bsky.social
Getting started with #AI in #SQLServer 2025 on #Windows
devblogs.microsoft.com/azure-sql/ge...

#Microsoft #OpenAI #MadeiraData
Getting started with AI in SQL Server 2025 on Windows - Azure SQL Devs’ Corner
Azure SQL Devs’ Corner - SQL Server 2025
devblogs.microsoft.com
June 10, 2025 at 10:02 AM
eitanblumin.bsky.social
Are you still using System.Data.SqlClient in your .NET apps? If so, it’s time to move to Microsoft.Data.SqlClient — the official, modern #SQLServer driver designed for today’s platforms and tomorrow’s innovations.

techcommunity.microsoft.com/blog/sqlserv...

#Microsoft #AzureSQL #MadeiraData
May 4, 2025 at 10:01 AM
eitanblumin.bsky.social
Episode 171 - Clueless about SQL Server 2025

sqlserverradio.com/episode-171-...
#podcast #SQLServer #MadeiraData
SQL Server Radio: Episode 171 - Clueless about SQL Server 2025
Guy and Eitan talk about SQL Server 2025 (well, they try to, at least), and its various interesting upcoming features. Relevant links:
sqlserverradio.com
January 13, 2025 at 1:52 PM
eitanblumin.bsky.social
Coming Soon: More #SSMS 21 Updates and SSMS 22 Preview!
techcommunity.microsoft.com/blog/sqlserv...

#Microsoft #SQLServer #MadeiraData
Coming Soon: More SSMS 21 Updates and SSMS 22 Preview! | Microsoft Community Hub
Coming soon: an additional SSMS 21 release and the upcoming Preview of SSMS 22!
techcommunity.microsoft.com
September 9, 2025 at 10:01 AM
eitanblumin.bsky.social
Announcing SQL Server Management Studio (#SSMS) 22.9.0
techcommunity.microsoft.com/blog/sqlserv...

#Microsoft #SQLServer #AzureSQL #Copilot #GitHubCopilot #SqlDBA #MadeiraData
Announcing SQL Server Management Studio (SSMS) 22.9.0 | Microsoft Community Hub
Today we released SQL Server Management Studio (SSMS) 22.9.0, with updates to GitHub Copilot, the connection experience, Database DevOps, SQL formatting, and...
techcommunity.microsoft.com
August 19, 2026 at 10:01 AM
eitanblumin.bsky.social
Enable Soft Delete in #AzureSQL - #Azure SQL Devs’ Corner
devblogs.microsoft.com/azure-sql/so...

#Microsoft #SQLServer #SqlDba #MadeiraData
Enable Soft Delete in Azure SQL - Azure SQL Devs’ Corner
Learn how to enforce soft delete at the database layer in Azure SQL using Row Level Security so applications cannot accidentally expose deleted data.
devblogs.microsoft.com
February 18, 2026 at 11:01 AM