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

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.
https://vladdba.com/2025/07/27/sql-server-ctes-do-not-store-results/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql

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.
https://vladdba.com/2025/07/23/identity-columns-sql-server/

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.
https://vladdba.com/2025/07/20/reseed-out-of-sync-sequences-default-constraints-sql-server/
#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
https://vladdba.com/2025/07/18/query-store-plan-forcing-queries-recompile-hint/

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
https://vladdba.com/2023/12/13/script-to-search-for-a-string-in-an-entire-sql-server-database/

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.

https://vladdba.com/2025/01/06/explaining-sql-injection-powershell-and-sql-server/

Die Lawine rollt: Nächste Stadt in Europa schmeißt Microsoft Office raus

https://winfuture.de/news,151881.html

> So ist Lyon als die drittgrößte Stadt Frankreichs die nächste Kommune, die sich von Redmonder Software verabschiedet. Die Stadtverwaltung plant, statt Microsoft Office künftig die Open-Source-Alternative OnlyOffice einzusetzen. Auch die Microsoft-SQL-Datenbank soll durch PostgreSQL abgelöst werden.

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
https://vladdba.com/2025/06/23/looking-into-sql-server-2025s-new-pbkdf2-hashing-algorithm/

Recently updated:
This blog post outlines ways to fix the access denied error you might encounter when attaching a database via SSMS in certain conditions.
#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #dba
https://vladdba.com/2022/09/29/fix-access-denied-when-attaching-a-database-via-ssms/

SQL Server Management Studio 21.2.5 is out.

Fans of maintenance plans and SSIS will be happy to know the two features have been reinstated as part of this update.

Release notes: https://learn.microsoft.com/en-us/ssms/release-notes-21#21.2.5
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms

New blog post:
In which I cover a fairly common VM CPU configuration mistake that may end up hurting your SQL Server’s performance and wasting licensing money.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
https://vladdba.com/2025/06/08/vm-cpu-configuration-sql-server-performance-licensing/

T-SQL в .NET Core EF Core: Гибридный подход к производительности и гибкости (Переосмысление с учетом обсуждения)

Секретное оружие в .NET Core: Почему вы игнорируете мощь T-SQL? Ваши LINQ-запросы становятся громоздкими? Производительность упирается в потолок? Возможно, вы упускаете нечто важное. Эта статья — приглашение взглянуть на привычные инструменты под новым углом. Мы исследуем гибридный подход, который позволяет использовать весь потенциал Microsoft SQL Server, выходя за рамки стандартного взаимодействия через EF Core. Узнайте, как T-SQL может упростить сложные задачи, повысить производительность и сделать вашу архитектуру более гибкой. Это не просто технический трюк, а переосмысление роли СУБД в современном приложении. Готовы узнать, как использовать "скрытые" возможности MSSQL и почему это может быть именно то, что нужно вашему проекту? Читать об этом

https://habr.com/ru/articles/914378/

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
https://vladdba.com/2025/05/30/sql-server-2025-container/

New blog post:
Which covers a potentially breaking change that comes with the version of sqlcmd shipped with SQL Server 2025.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
https://vladdba.com/2025/05/25/breaking-change-sqlcmd-version-sql-server-2025/

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
https://vladdba.com/2025/05/25/system-object-changes-sql-server-2025-2022/

New blog post:
In which I demo 3 methods to get SQL Server system objects' definitions.

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
https://vladdba.com/2025/05/22/view-sql-server-system-objects-definitions/

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
https://vladdba.com/2025/05/22/sql-server-2025-preview-installation-first-impressions/

Are you looking for an #online #database #modeling #tool with #SQL generation?

With the latest updates (e.g. modeling of #association #classes), BESSER is your ideal tool to #design and #generate your databases in many different "flavours" :

#SQLLite

#PostgresQL

#MySQL

#MariaDB

#MSSQLServer

and even #SQLAlchemy

Ready to give it a try? No installation required! https://editor.besser-pearl.org/

Did I already mention is completely and #opensource?

The latest release of PSBlitz brings an improved look and feel of the HTML report along with other small enhancements and bug fixes.
https://github.com/VladDBA/PSBlitz
#sqlserver #sqldba #powershell #mssqlserver #mssql #sql