Finding Unencrypted SQL Server Connections, and the Instances That Accept Them
Use sys.dm_exec_connections to list SQL Server sessions that aren’t encrypted, check Force Encryption, and see how driver defaults changed.
SQL Server 2025 sp_columns Omits JSON and Vector Columns
SQL Server 2025 filters json and vector columns from sp_columns and ODBC catalog output. I tested the alternatives.
The psqlODBC Driver Is Eating Your RAISE NOTICE Messages
I just spent two days debugging a problem where my PowerShell script was logging 900 lines of output instead of 150. The script worked fine for months. Then someone added more tables to the process,…