I just want to shout out @vladdba.com for being an awesome member of r/SQLServer always helpful and welcoming - sometimes the funny quips give me a good laugh too. Recent thread below. #SQLServer www.reddit.com/r/SQLServer/...

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

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

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

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

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

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

Sunspot Region 4299 ☀️ Two solar flares 1) M1.1 triggered 2) M8.1 - the core filament erupted - both produced a coronal mass ejection 1) slower, to NE 2) faster, earth-directed - possible arrival 8/9 December

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

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

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

SQL Server 2025 Is Out, and Standard Goes Up to 256GB RAM, 32 Cores! Today marks the official birthday of Microsoft SQL Server 2025. Here's where to download the evaluation version. Here are the top things you wanna consider as you talk to your managers, developers, and end users. The feature…

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

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

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

Get an additional 10% off of Brent's Black Friday sale prices - find out how: vladdba.com/discount-cod...

Imagine a 4TB unencrypted SQL Server database backup just sitting there for anyone to find. #azure #sqlserver #security #infosec www.neosecurity.nl/blog/ey-data...

Me, every time I get a new hyper-fixation and start dumping money into it:

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

The latest PSBlitz: - Updated with non-sp versions of sp_Blitz(Cache/First/Index/Lock/Who), from Brent Ozar's October First Responder Kit - Adds more memory & instance info - Improves HTML table layout #sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #dba #Azure

I'm reposting this blog post every time I have to troubleshoot a performance issue caused by this scenario where applications cause ASYNC_NETWORK_IO waits in SQL Server. vladdba.com/2024/01/22/h... #sqlserver #mssqldba #sql #dba #mssql #sqldba

The latest release of PSBlitz: - Fixes a bug in the HTML report that was breaking hyperlinks to articles (MS Learn, blog posts, etc.) - Addresses a data type overflow that occurred when retrieving instance information #sqlserver #sqldba #powershell #mssqlserver #mssql github.com/VladDBA/PSBl...

Ah, yes, the mythical SQL Server 2018 that only Copilot and probably Satya know about.😅

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

The latest release of PSBlitz: - Fixes some bugs related to the HTML report #sqlserver #sqldba #powershell #mssqlserver #mssql github.com/VladDBA/PSBl...

I’m working on a blog post on why people should attend in-person events. I can think of many reasons but I’d love the input of the broader community. If you have a few seconds to spare, please fill in this link. Thanks! #DataSaturday #SqlSaturday #Meetup forms.office.com/Pages/Respon...

Talking Ukraine war with Xi Me: "Any peace plan must require Zelensky to stop fighting" Xi: "What will happen if he doesn't?" Me: "Russia will lose" I remain a master strategist

New blog post: In which I demo two PoCs for SQL injection vulnerabilities fixed in SQL Server 2022 CU20 GDR KB5063814. vladdba.com/2025/08/29/p... #sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #security #sqli #sqlinjection

In some weird uno reverse type of way a company has offered to pay me in "exposure" on my own blog for reviewing their product. Thanks, vendor of [#database corruption recovery tool], but, as tempting as being paid with the opportunity to write a review for your product sounds, I'll have to pass.

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

100 years of July temperature anomalies over land areas through 2025... Data from NOAAGlobalTemp v6.0.0: www.ncei.noaa.gov/products/lan...

So, are people migrating from GitHub to Codeberg?

Preparing for summit with Donald.

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

Leopards, meet faces...

Upgrading from older versions? You'll need this ONE time: ``` Install-Module dbatools -Force -SkipPublisherCheck ``` After that initial transition, you won't need SkipPublisherCheck again since our cert keeps the same subject and root CA for version 2.5.5+ onward.

As someone who entered the job market right around the dot com bubble bursting, I believe the correct question is "Do you think every major CEO could be wrong *for a third time in my lifetime*?"

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

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

New blog post: In which I go over some useful information that you should be aware of when working with SQL Server’s IDENTITY columns. #sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql vladdba.com/2025/07/23/i...

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

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

Recently updated blog post: Containing a script that I’ve written a while ago and have used as recently as this week to search for a string in an entire SQL Server database. #sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba

Some awesome work right here to make your life easier when you want to document your database objects.

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

The latest PSBlitz: - has been updated with the non-stored procedure versions of sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, sp_BlitzLock, and sp_BlitzWho, from Brent Ozar's July release of the First Responder Kit - and brings some new options and improvements github.com/VladDBA/PSBl...

Peak logic

SSMS 21.3.6 introduces the ability to rename unsaved query editor tabs. Combined with the options to position tabs vertically, color code them based on RegEx patterns, and pinning important tabs (which was possible in previous versions too), makes juggling multiple opened tabs/files more manageable.