Vlad 2d ago
New blog post:
In which I go over three points that are vital in preventing SQL injection when working with dynamic T-SQL.
https://vladdba.com/2026/04/15/dynamic-t-sql-sql-injection-quotename-executesql/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
Using dynamic T-SQL? Parametrization alone can't prevent SQL injection

In this post I'll go over three points that are vital in preventing SQL injection when working with dynamic T-SQL.

VladDBA
Vlad 3d ago
New blog post:
My second contribution to T-SQL Tuesday, about a session that got me interested into the security side of things.
https://vladdba.com/2026/04/14/t-sql-tuesday-197-impactful-session-dba-career/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #tsql2sday
T-SQL Tuesday #197 - An impactful session changed my DBA career

My second time participating in T-SQL Tuesday, Steve Hughes‘s invitation about an impactful session from a conference brought back memories.

VladDBA
Vlad 4d ago
New blog post:
In which I provide some examples as to why FLOAT isn’t the best option for storing exact financial data in SQL Server.
https://vladdba.com/2026/04/11/stop-using-float-for-financial-data-sql-server/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
PSA: Stop using FLOAT to store financial data in SQL Server

In this post I provide some examples as to why FLOAT isn't the best option for storing exact financial data in SQL Server.

VladDBA
Vlad Apr 9
Blog post from the past:
In which I demo two PoCs for SQL injection vulnerabilities fixed in SQL Server 2022 CU20 GDR KB5063814
https://vladdba.com/2025/08/29/poc-sql-injection-sql-server-2022-cu20-gdr-kb5063814/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
PoCs for two SQL Injection vulnerabilities fixed in SQL Server 2022 GDR KB5063814

In this post I demo two PoCs for SQL injection vulnerabilities fixed in SQL Server 2022 CU20 GDR KB5063814

VladDBA
Vlad Apr 7

I've noticed today that Microsoft Bing Webmaster Tools has a new "AI Performance" tab.
Apparently, my SSMS 22 config blog post has been cited by "Microsoft Copilots and Partners" a total of 284.7K times since I've published it ~6 months ago. Pretty neat, although this doesn't really translate into visits.

Link to blog post: https://vladdba.com/2025/11/16/my-sql-server-management-studio-22-configuration/

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

Vlad Mar 20
New blog post:
In which I cover where to find the 4 new export formats in SSMS 22.4.1 and one gotcha you need to be mindful of.
https://vladdba.com/2026/03/20/ssms-export-result-excel-json-markdown-xml/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
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.

VladDBA
Vlad Mar 11
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
https://vladdba.com/2025/06/23/looking-into-sql-server-2025s-new-pbkdf2-hashing-algorithm/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
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.

VladDBA
Vlad Feb 23
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

VladDBA
Vlad Feb 10
New blog post:
Outlining the process of changing the edition of a SQL Server instance on Linux
https://vladdba.com/2026/02/03/change-edition-sql-server-linux/
#linux #sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
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.

VladDBA
Vlad Feb 3
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.
https://vladdba.com/2026/02/02/sql-server-2025-ubuntu-24-04/
#linux #ubuntu #virtualbox #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.

VladDBA