Really hate that in SQL Server 2022 Microsoft added the ability to enforce strict encryption (TLS wrapped TDS) but failed to implement support for this in the SQL Agent and apparently other commonly used tools/functionality.

I mean, who needs the agent, logs shipping, or replication?

The following features or tools still use previous version of drivers that don't support TDS 8.0, and as such, might not work with the strict connection encryption:

Always On availability groups
Always On failover cluster instance (FCI)
SQL Server Replication
Log Shipping
SQL Server CEIP service
SQL Server Agent
Database Mail
Linked Servers
Polybase connector to SQL Server
SQL VSS Writer

Reference: https://learn.microsoft.com/en-us/sql/relational-databases/security/networking/tds-8?view=sql-server-ver16

#sqlserver #MicrosoftSQLServer

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/

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/

How to Create a Table in SQL Server Management Studio.

Como Crear Una Tabla en SQL Server Management Studio.

👉 https://blog.nubecolectiva.com/como-crear-una-tabla-en-sql-server-management-studio/

#programming #coding #programación #webdevelopment #devs #softwaredevelopment #microsoftsqlserver #ssms

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/

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
https://vladdba.com/2025/05/07/my-wish-list-for-ssms-21/

Recently updated blog post:
Which contains a script that I’ve written and used a few times when I’ve needed 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/

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
https://vladdba.com/2025/04/15/query-object-dependencies-sql-server/

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 #AzureSQLDB #Azure
https://vladdba.com/2025/04/13/query-connection-information-in-sql-server/

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
https://vladdba.com/2023/08/07/get-access-to-sql-server-when-you-dont-have-the-sa-password/

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
https://vladdba.com/2025/03/03/dangerous-set-options-stored-procedures/

Blog post from the past:
In which I demo creating and managing aliases via dbatools, cliconfig, SQL Server Configuration Manager, and registry keys.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #powershell
https://vladdba.com/2023/09/29/configuring-and-using-sql-server-client-aliases/

This is a brief post showing how to migrate the sa password to another SQL Server instance without knowing it.
https://vladdba.com/2025/02/15/migrate-sa-password-another-instance/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba

Blog post from the past:
I which I demo one of SQL Server’s lesser-known features, startup stored procedures, and use it to automate #sp_BlitzWho for capturing ongoing session activity as soon as the instance starts up.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
https://vladdba.com/2023/10/24/sql-server-startup-procedures-automate-sp_blitzwho/

Mein Highlight heute:

Microsoft SQL Server auf exklusiven Zugriff umgestellt und damit den Account der den Befehl gegeben hat ausgesperrt.

Exklusiver Zugriff: alle Verbindungen außer diesen einen User beenden.

Es ist total unlogisch, man würde ja erwarten das der ausführende Nutzer der einzige erlaubte wird. Oder das die Nutzer sich gegenseitig raus schmeißen können.

Der Nutzer ist inzwischen sogar Datenbank Owner

#AdminLeiden #MicrosoftSQLServer #datenbanken