#mssqldba
LightNews LightNews
vladdba.com
New blog post:
SSMS 22 Preview 3 comes with some promissing features and improvements.
And the startup speed has finally been noticeably improved
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
vladdba.com/2025/10/16/s...
SQL Server Management Studio 22 Preview 3 - first impressions
SQL Server Management Studio 22 Preview 3 was released 2 days ago, so I took it out for a spin and here are my first impressions so far.
vladdba.com
October 17, 2025 at 8:01 PM
vladdba.com
New blog post:
Covering system object changes in SQL Server 2025 versus 2022, as well as differences in the install kit.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
System object changes in SQL Server 2025 vs 2022
This post covers system object changes in SQL Server 2025 versus 2022 that I was able to find as well as differences in the install kit.
vladdba.com
May 25, 2025 at 6:52 PM
vladdba.com
Blog post from the past:
In which I address improper linked server configurations and their potential impact, as well as recommendations for securing SQL Server linked servers.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
vladdba.com/2023/07/10/s...
Securing SQL Server linked servers
In this post I address improper security configurations and their impact, as well as recommendations for securing SQL Server linked servers.
vladdba.com
September 11, 2025 at 6:42 PM
vladdba.com
In this post I cover what the ASYNC_NETWORK_IO wait type is, when it occurs, how applications cause it in SQL Server, I use #PowerShell to cause the wait, and walk through troubleshooting it.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
vladdba.com/2024/01/22/h...
How apps cause ASYNC_NETWORK_IO waits in SQL Server
In this post I cover what the ASYNC_NETWORK_IO wait type is, when it occurs, and applications cause ASYNC_NETWORK_IO waits in SQL Server.
vladdba.com
January 24, 2025 at 7:25 PM
vladdba.com
New blog post:
Which outlines a list of feedback items for SSMS 21 that I believe should be addressed before it goes GA.

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms
My wish list for SSMS 21
This post outlines a list of feedback items for SSMS 21 that I believe should be addressed before SSMS goes GA.
vladdba.com
May 7, 2025 at 4:54 PM
vladdba.com
New blog post:
Covering the install process of SQL Server 2025 Preview and some first impressions, especially on the new Standard Developer Edition
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
SQL Server 2025 Preview - installation and first impressions
SQL Server 2025 Preview was announced Monday during Microsoft's Build conference, here's the installation process and my first impressions
vladdba.com
May 22, 2025 at 4:41 PM
vladdba.com
To top off 2024, I've put together a list of my most popular blog posts in 2024.
Thanks for all the clicks, likes and shares!

vladdba.com/2024/12/31/m...

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
Most popular blog posts in 2024
Since 2024 is coming to an end, I figured I should make a round-up, similar to Brent Ozar's, outlining the most popular blog posts this year
vladdba.com
December 31, 2024 at 3:01 PM
vladdba.com
New blog post:
In which I address a weird misconception floating around LinkedIn and reddit that SQL Server CTEs somehow store results in either memory or tempdb.

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
vladdba.com/2025/07/27/s...
No, SQL Server CTEs do not store results
There's this weird misconception floating around LinkedIn and reddit that SQL Server CTEs somehow store results in either memory or tempdb.
vladdba.com
July 28, 2025 at 5:14 PM
vladdba.com
Blog post from the past:
In which I show a few examples of implicit conversions in SQL Server and the impact they can have on query performance
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
vladdba.com/2024/09/11/i...
What are implicit conversions in SQL Server?
In this post I show a few examples of implicit conversions in SQL Server and the impact they can have on query performance.
vladdba.com
August 15, 2025 at 11:48 AM
vladdba.com
New blog post:
Containing a script that I wrote to help me next time I might need to bulk reseed out-of-sync SQL Server sequences tied to default constraints.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
Script to reseed out-of-sync sequences used for default constraints
This is a script that I wrote to help me next time I might need to bulk reseed out-of-sync SQL Server sequences tied to default constraints.
vladdba.com
July 21, 2025 at 3:55 PM
vladdba.com
Recently updated blog post:
In this post I cover a script I’ve put together for measuring storage write speeds in SQL Server, namely against database data files.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
vladdba.com/2024/03/02/m...
Script to measure write speeds in SQL Server
In this post I cover a script that I've put together for measuring storage write speeds in SQL Server, namely against database data files.
vladdba.com
January 8, 2025 at 6:01 PM
vladdba.com
Blog post from the past:
In which I demo a few variations of basic SQL injection using PowerShell and SQL Server, while also showing how to address it.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #security #infosec
vladdba.com/2025/01/06/e...
Explaining SQL injection using PowerShell and SQL Server
In this post I demo and explain a few variations of basic SQL injection using PowerShell and SQL Server, while also showing how to address it.
vladdba.com
July 9, 2025 at 6:21 PM
vladdba.com
New blog post:
In which I demo a query that lists object dependencies in SQL Server for either a specific object or for the entire database.

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
Find object dependencies in SQL Server
This is a brief post containing a query that lists object dependencies in SQL Server for a specific object or for the entire database.
vladdba.com
April 15, 2025 at 4:49 PM
vladdba.com
Blog post from the past:
In which I cover how to fix performance problems caused by implicit conversion when the query cannot be modified.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
vladdba.com/2024/09/15/i...
Fix implicit conversion when you can't change the query
In this post I cover ways to fix implicit conversion related performance problems when the query cannot be modified.
vladdba.com
August 21, 2025 at 7:23 PM
vladdba.com
New blog post:
In which I demo a query to get connection information in SQL Server aggregated by database, host, client and login name.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
Query connection information in SQL Server
In this post I demo a query to get connection information in SQL Server aggregated by database, host, client and login name.
vladdba.com
April 14, 2025 at 4:48 PM
vladdba.com
New blog post:
Which covers creating SQL Server 2025 containers in #Podman, #Qnap Container Station, #sqlcmd, and restoring a sample database to test the new version.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #container #docker #podman #qnap
Create a SQL Server 2025 container
This post covers creating SQL Server 2025 containers in Podman, Qnap, and sqlcmd, and restoring a sample database to test the new version.
vladdba.com
May 30, 2025 at 1:43 PM
vladdba.com
New blog post:
In which I explore the impact of SQL Server 2025’s PBKDF2 hashing algorithm on password cracking and compare it with SQL Server 2022.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #security #pbkdf2
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.com
June 23, 2025 at 5:29 PM
vladdba.com
In this post I cover ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
vladdba.com/2025/03/03/d...
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.com
March 3, 2025 at 5:07 PM
vladdba.com
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
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
vladdba.com
November 3, 2025 at 4:37 PM
vladdba.com
Blog post from the past:
In which I discuss the risks of improperly configured SQL Server linked server connections and provide recommendations for securing them.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #security #sql #dba
vladdba.com/2023/07/10/s...
Securing SQL Server linked servers
In this post I address improper security configurations and their impact, as well as recommendations for securing SQL Server linked servers.
vladdba.com
January 6, 2025 at 3:05 PM
vladdba.com
New blog post:
In which I test if Query Store plan forcing works on queries that use the RECOMPILE hint and run into an interesting scenario with plan forcing and new indexes.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #querystore
Does Query Store plan forcing work on queries using the RECOMPILE hint?
It's 2AM and I'm curious if Query Store plan forcing works on queries that use the RECOMPILE hint (aka OPTION(RECOMPILE) ).
vladdba.com
July 18, 2025 at 3:49 PM
vladdba.com
Blog post from the past:
In which I cover two ways of properly securing xp_cmdshell in SQL Server to avoid unrestricted access to the underlying #Windows OS
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #security
vladdba.com/2023/06/29/s...
Securing xp_cmdshell in SQL Server
In this post I cover two ways of properly securing xp_cmdshell in SQL Server to avoid unrestricted access to the underlying Windows OS.
vladdba.com
January 31, 2025 at 7:08 PM
vladdba.com
New blog post:
An overview of PSBlitz, how I use it to diagnose SQL Server issues, and the notable changes it went through over the past 3 years.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #powershell
vladdba.com/2025/07/30/d...
Diagnosing SQL Server with PSBlitz - 3-year anniversary post
This post is an overview of PSBlitz, how I use it in diagnosing SQL Server issues, and the notable changes it went through.
vladdba.com
July 30, 2025 at 5:12 PM
vladdba.com
Blog post from the past:
In which I cover how to gain sysadmin access to SQL Server when you don't have the sa login's password.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
vladdba.com/2023/08/07/g...
Get access to SQL Server when you don't have the SA password
In this post I'll cover a quick way to get access to SQL Server when you don't have a login and don't know the password for the SA account.
vladdba.com
March 12, 2025 at 9:06 PM
vladdba.com
Blog post from the past:
I which I demo creating and managing aliases via @dbatools.io, cliconfig, SQL Server Configuration Manager, and registry keys.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #powershell
vladdba.com/2023/09/29/c...
Configuring and using SQL Server client aliases
In this post I cover SQL Server client aliases, what they are and when they're useful, as well as how to configure, update, and use them.
vladdba.com
February 24, 2025 at 8:59 PM