This post covers creating SQL Server 2025 containers in Podman, Qnap Container Station, and sqlcmd, and restoring a sample database to test the new version. Prerequisites For Podman and go-sqlcmd, …
-
- 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 …
-
This post covers, in detail, system object changes in SQL Server 2025 versus 2022 that I was able to find, as well as differences in the install kit. I saw …
-
If you’ve ever been curios about ways to view SQL Server system objects’ definitions, to see what your favorite system objects do behind the scenes then this blog post is …
- Getting StartedSQL Server
SQL Server 2025 Preview – installation and first impressions
by Vlad DrumeaSQL Server 2025 Preview was announced Monday during Microsoft’s Build conference, so I figured I’d cover the installation process and first impressions in a blog post. If containers are your …
-
This post outlines a list of feedback items for SSMS 21 that I believe should be addressed before SSMS 21 goes GA. Note: If you see anything that you agree …
-
In this post I demo a script I put together to count NULLs in all columns of a given table in SQL Server and store the results in a table. …
-
This is a brief post containing a query that lists object dependencies in SQL Server for either a specific object or for the entire database. Intro Figuring out object dependencies …
-
In this post I demo a query to get connection information in SQL Server aggregated by database, host, client and login name. Intro I’ve spent some time this week working …
- SQL ServerTips And Tricks
Dangerous SET options stored procedure inherit from your session
by Vlad DrumeaIn this post I cover ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created. Intro You might have noticed when scripting out …