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/
Create a SQL Server 2025 container

This post covers creating SQL Server 2025 containers in Podman, Qnap, and sqlcmd, and restoring a sample database to test the new version.

VladDBA
After extensive analysis, it seems that sqlcmd doesn't manage buffers and transactions properly, and it lead to the error, when there's lot's of data. I wrote my own alternateive program for #SQLCMD using #Python, and now the import was successful. So it turns out that sqlcmd code is just bit bad, and someone had to write better alternative. To be honest, some of the individual insert statements were up to 8 megabytes per row. #SQL
I created #SQL #dump file using #SSMS. Yet interestingly when running it with #sqlcmd, it says that it hasn't been properly #escaped. - I'll investigate it closer, but it looks interesting. Why it wouldn't be properly escaped? That's really confusing. But I'll dig into it. The dump file just just a hundreds of gigabytes which makes it bit harder.
Little SQL Server Tricks: Export CSV With Sqlcmd - Improve & Repeat

Sqlcmd is a little tool that can help you with automating the exports from SQL Server. It works also on Linux and offers a lot of flexibility.

Improve & Repeat
Why does #Microsoft #SQLServerManagementStudio pretend to take a long time "creating a script" when requesting a view definition? The definition is stored in the information_schema. Using #sqlcmd we can request it, and it pops up instantly. What does #SSMS think its doing?
https://learn.microsoft.com/en-us/sql/tools/sqlcmd/go-sqlcmd-utility - #sqlcmd for #mssql, rewritten from the ground up to be cross-platform and fast. Now if only it came in a pre-built #Docker #container...
go-sqlcmd utility - SQL Server

The go-sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files using different modes.

Oh, cool! From MSFT: https://aka.ms/sqlcmd #sqlcmd

Got a container runtime (docker / podman etc.)? Get SQL Server running using the new sqlcmd:

winget install sqlcmd sqlcmd create mssql --using https://aka.ms/AdventureWorksLT.bak

Open it in Azure Data Studio sqlcmd open ads Install, Create, Open!

GitHub - microsoft/go-sqlcmd: The new sqlcmd, CLI for SQL Server and Azure SQL (winget install sqlcmd / sqlcmd create mssql / sqlcmd open ads)

The new sqlcmd, CLI for SQL Server and Azure SQL (winget install sqlcmd / sqlcmd create mssql / sqlcmd open ads) - GitHub - microsoft/go-sqlcmd: The new sqlcmd, CLI for SQL Server and Azure SQL (wi...

GitHub

#oss #sqlcmd tool written in #golang - very nice improvement over the old sqlcmd tool!

https://github.com/microsoft/go-sqlcmd

#sqlserver

GitHub - microsoft/go-sqlcmd: The new sqlcmd, CLI for SQL Server and Azure SQL (winget install sqlcmd / sqlcmd create mssql / sqlcmd open ads)

The new sqlcmd, CLI for SQL Server and Azure SQL (winget install sqlcmd / sqlcmd create mssql / sqlcmd open ads) - GitHub - microsoft/go-sqlcmd: The new sqlcmd, CLI for SQL Server and Azure SQL (wi...

GitHub