Looking into SQL Server 2025's new PBKDF2 hashing algorithm In this post I explore the impact of SQL Server 2025's PBKDF2 hashing algorithm on password cracking and compare it with SQL Server 2022.

Blog post from the past:
In which I explore the impact of SQL Server 2025’s #PBKDF2 hashing algorithm on password cracking and compare it with SQL Server 2022
vladdba.com/2025/06/23/l...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba

Why Developers and DBAs love SQL’s Dynamic Data Masking (Series-Part 1) | Microsoft Community Hub Dynamic Data Masking (DDM) is one of those SQL features (available in SQL Server, Azure SQL DB, Azure SQL MI, SQL Database in Microsoft Fabric) that both...

Why Developers and DBAs love SQL’s Dynamic Data Masking (Series-Part 1)
techcommunity.microsoft.com/blog/azuresq...

#Microsoft #SQLServer #SqlDBA #MadeiraData

MSSQL Extension for VS Code: Query Profiler, ADS Migration Toolkit & More - Azure SQL Dev Corner Discover what's new in MSSQL Extension for VS Code v1.40: Query Profiler, ADS Migration Toolkit, Database Backup & Restore, Flat File Import, and more.

#MSSQL Extension for #VSCode: Query Profiler, ADS Migration Toolkit & More

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

#Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData

Federating Databases with Data API Builder Chaining - Azure SQL Dev Corner Using Data API builder and sp_invoke_external_rest_endpoint, you can compose and federate data across databases and engines in SQL without relying on linked servers.

Federating Databases with #Data #API Builder Chaining

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

#Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData

Dear Copilot, can you help me with SQL? - Azure SQL Devs’ Corner Using Copilot with Azure SQL to go from schema design to local development, REST APIs, and Azure deployment, all guided by workspace instructions and skills that keep SQL at the center.

Dear #Copilot, can you help me with #SQL?

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

#Microsoft #AI #SQLServer #AzureSQL #VSCode #SqlDBA #MadeiraData

Dangerous SET options stored procedure inherit from your session ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created

Blog post from the past:
In which I cover ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created.
vladdba.com/2025/03/03/d...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba

SSMS 22.3 Release SSMS 22.3 is now available and includes bug fixes, improvements, and support for database instructions for GitHub Copilot in SSMS.

SSMS 22.3 Release
techcommunity.microsoft.com/blog/sqlserv...

#Microsoft #SQLServer #AzureSQL #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.

Enable Soft Delete in #AzureSQL - #Azure SQL Devs’ Corner
devblogs.microsoft.com/azure-sql/so...

#Microsoft #SQLServer #SqlDba #MadeiraData

picture is a colorful flyer with a photo portrait of the speaker, Karunakar Kotha. The event will be on Feb 20 @ 17.00 central european time, for free.

@DataTgif Feb 20 @ 17:00 Central Europ Time: Beyond Lift‑and‑Shift: The Strategic Move from VM SQL to Azure SQL by Karunakar Kotha (MSFT) www.meetup.com/data-tgif/ev... #Meetup via @Meetup #Azure #AzureSQL #DataEngineering #sqlfamily #sqldba

Change the edition of a SQL Server on Linux instance In this post I cover the steps required to change (downgrade or upgrade) the edition of a SQL Server instance running on Linux.

New blog post:
Outlining the process of changing the edition of a SQL Server instance on Linux
vladdba.com/2026/02/03/c...
#linux #sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql

Getting started with SQL Server 2025 on Ubuntu 24.04 Previously I've set up an Ubuntu 24.04 VM, so I figured I'd cover the process of setting up SQL Server 2025 on Ubuntu 24.04.

New blog post:
In which I cover the process of setting up SQL Server 2025 on Ubuntu 24.04, connecting and restoring a sample database.
vladdba.com/2026/02/02/s...
#linux #ubuntu #virtualbox #sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql

T-SQL Tuesday #194 - learning from mistakes My first time participating in T-SQL Tuesday, and Louis Davidson's invitation "learning from mistakes" seemed like the perfect opportunity.

New blog post:
My first ever contribution to T-SQL Tuesday.
vladdba.com/2026/01/20/t...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #tsql2sday

Speeding up SELECT COUNT in SQL Server In this post I'll cover ways of speeding up SELECT COUNT as well as some myths about best practices when it comes to SELECT COUNT.

Blog post from the past:
In which I cover ways of speeding up SELECT COUNT in SQL Server as well as some myths about best practices when it comes to SELECT COUNT.
vladdba.com/2023/08/21/s...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba

2025 Year in Review: What’s new across SQL Server, Azure SQL and SQL database in Fabric | Microsoft Community Hub What a year 2025 has been for SQL! ICYMI and are looking for some hype, might I recommend you start with this blog from Priya Sathy, the product leader for...

2025 Year in Review: What’s new across #SQLServer, #AzureSQL and SQL database in #Fabric
techcommunity.microsoft.com/blog/azuresq...

#Microsoft #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.

Announcing the release of SQL Server Management Studio 22.1
techcommunity.microsoft.com/blog/sqlserv...

#Microsoft #SQLServer #AzureSQL #SqlDba #MadeiraData

The hidden costs of heaps in SQL Server In this post I cover some unpleasant side-effects of using heaps in SQL Server for anything else than staging tables.

New blog post:
In which I cover some unpleasant side-effects of using heaps in SQL Server for anything else than staging tables.
vladdba.com/2025/12/30/t...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql

Most popular blog posts in 2025 It's time for my annual roundup of the most popular blog posts in 2025 by views, likes, and comments.

New blog post:
My most popular blog posts in 2025 by views, likes, and comments.
vladdba.com/2025/12/27/m...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql

Import and query HTML table data in SQL Server In this post I cover a way to import and query HTML table data in SQL Server using only T-SQL and no external tools.

Blog post from the past:
In which I demo how to import and query HTML table data in SQL Server using only T-SQL.
vladdba.com/2023/11/03/i...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba

Page compression on heaps implies some extra work I recently ran into SQL Server's page compression being applied to a heap, and I figured I'd cover why that won't work how some folks expect.

New blog post:
In which I cover a sometimes overlooked gotcha when using page compression on heaps.
vladdba.com/2025/12/09/p...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql

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/...

The latest PSBlitz:
- Updated with the non-sp versions of sp_Blitz* from Brent Ozar's Nov. release of the First Responder Kit
- Adds buttons to copy query text from the HTML report
- Overview of findings/issues in HTML report's main page
#sqlserver #sqldba #powershell #mssqlserver #mssql #powershell

Import saved connections from SSMS 21 to SSMS 22 This blog post is a guide for migrating saved connection details from SQL Server Management Studio 21 to SSMS 22

Updated blog post:
Added information about limitations and a workaround for transferring SSMS 21 connection history data to SSMS 22 when using the classic Connection Dialog.
vladdba.com/2025/11/17/i...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms #PowerShell

PowerShell script to extract SSMS 21 and 22 saved connection data In this post I demo a PowerShell script I wrote to extract and decrypt SSMS 21 and 22 saved connection information.

New blog post:
In which I demo a PowerShell script I wrote to extract and decrypt SSMS 21 and 22 saved connection information.
vladdba.com/2025/11/22/p...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms #PowerShell

Import saved connections from SSMS 21 to SSMS 22 This blog post is a guide for migrating saved connection details from SQL Server Management Studio 21 to SSMS 22

New blog post:
In which I show you how to easily migrate saved connection details from SQL Server Management Studio 21 to SSMS 22.
vladdba.com/2025/11/17/i...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms #PowerShell

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.

New blog post:
In which I share my SQL Server Management Studio 22 configuration.
vladdba.com/2025/11/16/m...
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms

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...

Breaking Changes & Migration Risks in #SQLServer2025 - by Rebecca Lewis
www.sqlfingers.com/2025/10/brea...

#Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData

Replicating SQL Server 2025's PBKDF2 hashing algorithm using T-SQL In this post I talk some more about SQL Server 2025's new PBKDF2 and demo a method to replicate it using T-SQL

New blog post:
In which I demo a pure T-SQL implementation of SQL Server 2025's new PBKDF2 hashing algorithm

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #security

Announcing the Release of SSMS 22 Preview 4 | Microsoft Community Hub Happy Monday! The SSMS team is excited to announce the release of SQL Server Management Studio (SSMS) Preview 4. Building on feedback from our community and...

Announcing the Release of #SSMS 22 Preview 4

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

#Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData

Improved Connectivity Types in Azure SQL Managed Instance | Microsoft Community Hub Azure SQL Managed Instance improves and promotes "Redirect" to become the default connection type. Redirect now only requires port 1433 and can handle older...

Improved Connectivity Types in #Azure SQL Managed Instance

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

#Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData

Multiple geo-replicas for Azure SQL Hyperscale is now in public preview | Microsoft Community Hub Active geo-replication for Azure SQL is a business continuity solution that lets you perform quick disaster recovery of individual databases if there is a...

Multiple geo-replicas for #Azure SQL #Hyperscale is now in public preview

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

#Microsoft #SQLServer #AzureSQL #SqlDBA #MadeiraData

Announcing the Release of SQL Server Management Studio 22 Preview 3 | Microsoft Community Hub The SSMS team is delighted to announce the release of SQL Server Management Studio (SSMS) 22 Preview 3. This latest preview is chock full of exiting new...

Announcing the Release of #SQLServer Management Studio 22 Preview 3
techcommunity.microsoft.com/blog/sqlserv...

#Microsoft #SSMS #AzureSQL #SqlDBA #MadeiraData