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

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

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

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

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

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

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 to clipboard for any query in the HTML report
- Provides overview findings/issues per section of the HTML report's main page
- Limits Statistics Info page to stats that require attention
- Includes other bug fixes and minor improvements

https://github.com/VladDBA/PSBlitz

#sqlserver #sqldba #powershell #microsoftsqlserver #mssql #powershell

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.
https://vladdba.com/2025/11/17/import-saved-connections-from-ssms-21-to-ssms-22/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms #PowerShell

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

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

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

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
https://vladdba.com/2025/11/02/replicating-sql-server-2025-pbkdf2-hashing-algorithm-using-t-sql/

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
https://vladdba.com/2025/10/16/sql-server-management-studio-22-preview-3-first-impressions/

The latest release of PSBlitz:
- Has been updated with the non-sp versions of sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, sp_BlitzLock, and sp_BlitzWho, from Brent Ozar's October release of the First Responder Kit
- Provides additional memory and instance state information
- Improves the HTML report's table layout
- Includes other bug fixes and minor improvements

https://github.com/VladDBA/PSBlitz

#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #dba #PSBlitz

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
https://vladdba.com/2023/07/10/securing-sql-server-linked-servers/

New blog post:
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 #security #sqli #sqlinjection

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
https://vladdba.com/2024/09/15/implicit-conversion-performance-query/

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
https://vladdba.com/2024/09/11/implicit-conversions-in-sql-server/

#ADOdb 5.22.10 has been released (#DatabaseAbstractionLayer / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #OracleDatabase / #SQLServer / #MicrosoftSQLServer / #DB2 / #IBMDB2) https://adodb.org/

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.
https://vladdba.com/2025/07/30/diagnosing-sql-server-with-psblitz-3-years-anniversary-post/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #powershell