SSMS 22.4.1 exports results to Excel, JSON, Markdown, and XML
The latest update to SQL Server Management Studio (SSMS) 22 adds 4 new results export formats: Excel, JSON, Markdown, and XML.
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 cover ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created.
https://vladdba.com/2025/03/03/dangerous-set-options-stored-procedures/#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
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
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.
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.
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.
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.
https://vladdba.com/2023/08/21/speeding-up-select-count-in-sql-server/#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
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.
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.
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.
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.
Vlad 