sqlserver

A 1-post collection

Open source tools for SQL Server on Linux

I am a sucker for a great tool and even better if it's open source. Recently, I wrote up a post on why we should care about containers where I used SQL Server on Linux in a container and loaded some test data for an ASP.NET Core application in lieu of using a full database server. SQL Server on Linux has a built-in command line tool for connecting and executing commands against the database. However, each time you use it; it requires a login, password etc. /opt/mssql-tools/bin/sqlcmd -S localhost -d Names -U SA -P $SA_PASSWORD -I -Q "SELECT TOP 5 ID,FullName FROM Names;" mssql-cli Introducing the mssql-cli, a new interactive and cross-platform CLI tool....