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

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

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/