go-sqlcmd is a powerful open-source, cross-platform, command-line tool with no ODBC dependency. It maintains all the features of the traditional SQLCMD utility while introducing enhancements. For example, it allows you to create a local SQL Server instance with a sample database with one line of code.

The Go package (go-mssqldb driver) is designed to seamlessly interact with Microsoft SQL Server, Azure SQL Database, and Azure Synapse. It lets users enter Transact-SQL statements, system procedures, and script files at the command prompt. Whether you’re a seasoned database administrator or a developer, go-sqlcmd streamlines your SQL-related tasks, making it an essential addition to your toolkit.

Join me in this lightning talk to discover essential features and how go-sqlcmd simplifies SQL interactions and empowers your database workflows!

Prerequisite: None

Goals:
1. Learn about the essential functions of go-sqlcmd
2. How to install and query SQL instance using go-sqlcmd
3. How to manage context