I wasn’t really planning on writing a blog post today, but I got curios if there’s any way in which connections saved in SQL Server Management Studio 21 can be …
Workarounds
-
- SQL ServerWorkarounds
Breaking change in the sqlcmd version shipped with SQL Server 2025
by Vlad DrumeaThis short blog post covers a potentially breaking change that comes with the version of sqlcmd shipped with SQL Server 2025. Issue SQL Server 2025 provides ODBC sqlcmd version 17 …
-
In this blog post I cover the solution for a weird behavior that bcp has when trying to import files that contain Unix line endings. The weird behavior I’m referring …
-
This post covers a few ways to fix the SSL certificate error 1416F086 returned by sqlcmd on Linux when connecting to SQL Server. If you’re looking for ways to fix …
- SQL ServerWorkarounds
Fix “certificate chain was issued by an authority that is not trusted” in dbatools
by Vlad DrumeaThis is a brief post about fixing the “certificate chain was issued by an authority that is not trusted” when using dbatools in PowerShell. Example of the full error message: …
-
In this post I’ll go over the relationship between unique constraints and NULLs in SQL Server, and how you can have multiple NULLs in a unique constraint. What is a …