#SqlDBA
LightNews LightNews
eitanblumin.bsky.social
Bacpac and Dacpac, the similarities and differences
devblogs.microsoft.com/azure-sql/ba...

#Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData
Bacpac and Dacpac, the similarities and differences - Azure SQL Dev Corner
When you need to move an entire database or move the objects in a database, bacpac and dacpac files often come up because of all of the tooling options to
devblogs.microsoft.com
September 10, 2026 at 10:02 AM
eitanblumin.bsky.social
#Microsoft is Introducing Simplified Regional Limits for #AzureSQL Managed Instance
techcommunity.microsoft.com/blog/azuresq...

#SQLServer #SqlDBA #Azure #MadeiraData
Introducing Simplified Regional Limits for Azure SQL Managed Instance | Microsoft Community Hub
We are pleased to announce improvements to regional subscription limits for Azure SQL Managed Instance. These changes simplify subnet management and provide...
techcommunity.microsoft.com
September 6, 2026 at 10:00 AM
eitanblumin.bsky.social
Outgrowing #SQLServer Express? Upgrade to #AzureSQL Database Free Tier in 3 Steps
devblogs.microsoft.com/azure-sql/up...

#Microsoft #Azure #SqlDBA #MadeiraData
Outgrowing SQL Server Express? Upgrade to Azure SQL Database Free Tier in 3 Steps - Azure SQL Dev Corner
Upgrade from SQL Server Express to Azure SQL Database. You can build locally for free with Azure SQL Developer (a free container image of the Azure SQL Database engine, in preview) or deploy directly…
devblogs.microsoft.com
September 3, 2026 at 10:01 AM
eitanblumin.bsky.social
MSSQL Extension for #VSCode: SQL Formatter, #AzureSQL Database Provisioning, and More
devblogs.microsoft.com/azure-sql/vs...

#Microsoft #SQLServer #DevOps #SSDT #SqlDBA #MadeiraData
MSSQL Extension for VS Code: SQL Formatter, Azure SQL Database Provisioning, and More - Azure SQL Dev Corner
Explore the MSSQL Extension for VS Code v1.45 | What's New with SQL Formatter and Azure SQL Database features.
devblogs.microsoft.com
September 2, 2026 at 10:01 AM
eitanblumin.bsky.social
Managing #SQLServer on #Linux #Azure VMs with the SQL IaaS Agent Extension
techcommunity.microsoft.com/blog/sqlserv...

#Microsoft #AzureSQL #SqlDBA #MadeiraData
Managing SQL Server on Linux Azure VMs with the SQL IaaS Agent Extension | Microsoft Community Hub
If you run SQL Server on a Linux virtual machine in Azure, the SQL Server IaaS Agent extension is the piece that connects your SQL Server instance to...
techcommunity.microsoft.com
September 1, 2026 at 10:01 AM
eitanblumin.bsky.social
The Two Hybrid Searches in #Microsoft #SQLServer
devblogs.microsoft.com/azure-sql/tw...

#AzureSQL #SqlDBA #MadeiraData
The Two Hybrid Searches in Microsoft SQL - Azure SQL Dev Corner
Hybrid search is usually described as combining keyword search with vector search. Microsoft SQL does that, for sure, but we do quite a bit more right out
devblogs.microsoft.com
August 31, 2026 at 10:00 AM
eitanblumin.bsky.social
Public Preview: Zone-Redundant Next-Gen General Purpose for #AzureSQL Managed Instance
techcommunity.microsoft.com/blog/azuresq...

#Microsoft #Azure #SQLServer #SqlDBA #MadeiraData
Azure SQL MI Next-Gen GP Zone Redundancy Now in Preview
Zone redundancy for Azure SQL Managed Instance Next-Gen GP is now in public preview, delivering a 99.995% availability SLA with Availability Zones.
techcommunity.microsoft.com
August 30, 2026 at 10:00 AM
eitanblumin.bsky.social
What’s next for SQL? Performance, scale, AI, and developer productivity at the European SQL Community Conference
www.microsoft.com/en-us/sql-se...

#Microsoft #SQLServer #SqlDBA #SqlFamily #AzureSQL #MadeiraData
SQL, AI, and scale: What to expect at SQLCon Europe 2026 - Microsoft SQL Server Blog
Join Microsoft Fabric and SQL Community Conference 2026 to explore SQL Server, Azure SQL, AI innovation, and modern data solutions.
www.microsoft.com
August 20, 2026 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
HostNameInCertificate changes in #AzureSQL Managed Instance affecting client connectivity
techcommunity.microsoft.com/blog/azuresq...

#Microsoft #SQLServer #SqlDBA #MadeiraData
HostNameInCertificate changes in Azure SQL Managed Instance affecting client connectivity | Microsoft Community Hub
Azure SQL Managed Instance is changing how TLS certificates are stored and handled in managed instances. One of those certificates was specifically tailored...
techcommunity.microsoft.com
August 18, 2026 at 10:01 AM
eitanblumin.bsky.social
Announcing Automatic Backup Immutability for #AzureSQL #Database and #Azure SQL Managed Instance
techcommunity.microsoft.com/blog/azuresq...

#Microsoft #SQLServer #SqlDBA #MadeiraData
Announcing Automatic Backup Immutability for Azure SQL Database and Azure SQL Managed Instance | Microsoft Community Hub
Built-in protection for your most recent backups - enabled automatically Today, we're excited to announce General Availability of automatic backup...
techcommunity.microsoft.com
August 17, 2026 at 10:01 AM
eitanblumin.bsky.social
You can now Refactor your database with SQL projects in #VSCode
devblogs.microsoft.com/azure-sql/re...

#Microsoft #SQLServer #AzureSQL #DevOps #SSDT #SqlDBA #MadeiraData
Refactor your database with SQL projects in VS Code - Azure SQL Dev Corner
SQL database projects are a fundamental tool for keeping your database in source control, tracking changes and collaborating on quickly evolving database
devblogs.microsoft.com
August 16, 2026 at 10:00 AM
eitanblumin.bsky.social
Regex-based dynamic data masking in #AzureSQL Database (preview)
techcommunity.microsoft.com/blog/azuresq...

#Microsoft #SQLServer #Azure #SqlDBA #MadeiraData
Regex-based dynamic data masking in Azure SQL Database (preview) | Microsoft Community Hub
Azure SQL Database introduces Regex-based dynamic data masking, a new capability that enables flexible, pattern-driven masking for string-based columns using...
techcommunity.microsoft.com
August 13, 2026 at 10:01 AM
eitanblumin.bsky.social
Build locally, ship to #Azure: meet Azure SQL Developer
devblogs.microsoft.com/azure-sql/az...

#Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData
Build locally, ship to Azure: meet Azure SQL Developer - Azure SQL Dev Corner
Explore Azure SQL Developer, now in private preview, for seamless development using the Azure SQL Database engine locally.
devblogs.microsoft.com
August 12, 2026 at 10:01 AM
eitanblumin.bsky.social
Two additional controls with Automatic Plan Correction enabled
techcommunity.microsoft.com/blog/sqlserv...

#Microsoft #SQLServer #AzureSQL #Powershell #SqlDBA #MadeiraData
Using the sp_configure_automatic_tuning stored procedure
The sp_configure_automatic_tuning stored procedure gives you the option exclude queries, or add an additional check, when using Automatic Plan Correction.
techcommunity.microsoft.com
August 11, 2026 at 10:01 AM
eitanblumin.bsky.social
T-SQL Hygiene: Introducing the Covering Index
devblogs.microsoft.com/azure-sql/ts...

#Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData
T-SQL Hygiene: Introducing the Covering Index - Azure SQL Dev Corner
Learn what a covering index is, how predicates and projections shape it, and when to use one to speed up important SQL Server queries.
devblogs.microsoft.com
August 10, 2026 at 10:01 AM
vladdba.com
The latest release of PSBlitz:
- Adds more security checks related to xp_cmdshell, sp_invoke_external_rest_endpoint, and additional high privilege roles and permissions
github.com/VladDBA/PSBl...

#sqlserver #sqldba #powershell #mssqlserver #mssql #mssqldba #PSBlitz #Azure #AzureSQLDB #AzureSQLMI
GitHub - VladDBA/PSBlitz: a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and...
a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files. - VladDBA/...
github.com
August 9, 2026 at 9:49 PM
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
vladdba.com
Recently updated blog post:
Documenting my SQL Server Management Studio configuration.
vladdba.com/2025/11/16/m...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #mvpbuzz
My SQL Server Management Studio 22 configuration
SQL Server Management Studio 22 just went GA this week, so I figured I'd document my new configuration in a blog post.
vladdba.com
August 6, 2026 at 4:31 PM
eitanblumin.bsky.social
MSSQL Extension for #VSCode: Shortcuts Configuration, Enhanced Results Grid Experience, and More
devblogs.microsoft.com/azure-sql/vs...

#Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData
MSSQL Extension for VS Code: Shortcuts Configuration, Enhanced Results Grid Experience, and More - Azure SQL Dev Corner
Explore the MSSQL Extension VS Code v1.44 with new features like Shortcuts Configuration and an enhanced Results Grid.
devblogs.microsoft.com
August 6, 2026 at 10:01 AM
eitanblumin.bsky.social
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
August 5, 2026 at 10:00 AM
vladdba.com
New blog post:
In which I cover the process of spinning up an Azure SQL Database container using #QNAP Container Station.
vladdba.com/2026/08/02/a...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #mvpbuzz
Setting up an Azure SQL DB container in QNAP Container Station
In this post I cover the process of setting up, connecting to and interacting with an Azure SQL DB container in QNAP's Container Station.
vladdba.com
August 4, 2026 at 3:30 PM
eitanblumin.bsky.social
#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).
www.microsoft.com
August 4, 2026 at 10:00 AM
vladdba.com
New blog post:
In which I cover the process of spinning up an Azure SQL Database container in Podman.
vladdba.com/2026/08/02/a...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #mvpbuzz
Setting up an Azure SQL DB container in Podman
In this post I cover the process of setting up, connecting to and interacting with an Azure SQL DB container in Podman.
vladdba.com
August 3, 2026 at 7:03 PM
eitanblumin.bsky.social
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
August 3, 2026 at 10:00 AM