{"id":359,"date":"2024-07-30T08:00:00","date_gmt":"2024-07-30T13:00:00","guid":{"rendered":"https:\/\/www.sqltabletalk.com\/?p=359"},"modified":"2024-07-29T11:49:30","modified_gmt":"2024-07-29T16:49:30","slug":"introducing-go-sqlcmd","status":"publish","type":"post","link":"https:\/\/www.sqltabletalk.com\/?p=359","title":{"rendered":"GO for it with SQLCMD: Introducing the Modern SQLcmd"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>Today, we\u2019re covering a new enhancement to SQLCMD, now called Go-SQLcmd. This tool allows you to easily spin up SQL Server containers, providing a more efficient way to manage SQL Server environments.<\/p>\n<h3>Lightweight Development Environment<\/h3>\n<p>Previously, you might have installed SQL Server Developer Edition on your computer to test features, write queries, and create a sandbox environment. While effective, this approach can be cumbersome and time-consuming. Go-SQLcmd offers a more lightweight and quicker development setup using Docker containers. This means you can get started with SQL Server in a matter of seconds, without the overhead of a full installation.<\/p>\n<h3>Prerequisites<\/h3>\n<p>To follow this example, you\u2019ll need:<\/p>\n<ul>\n<li><strong>Docker Desktop<\/strong>: <a href=\"https:\/\/docs.docker.com\/desktop\/install\/windows-install\/\">Install Docker Desktop on Windows<\/a><\/li>\n<li><strong>WSL (Windows Subsystem for Linux)<\/strong>: Install with the command <code>wsl --install -d Ubuntu<\/code> <a href=\"https:\/\/docs.microsoft.com\/windows\/wsl\/install\">Install WSL<\/a><\/li>\n<li><strong>Winget<\/strong>: The Windows Package Manager<\/li>\n<\/ul>\n<h3>Capabilities of Go-SQLcmd<\/h3>\n<p>Go-SQLcmd allows you to query existing SQL Server and Azure SQL Database instances. It also introduces new features, such as:<\/p>\n<ul>\n<li>Creating containers with a single line of code<\/li>\n<li>Restoring databases from backup files when instances are created<\/li>\n<li>Opening Azure Data Studio for data exploration<\/li>\n<\/ul>\n<h3>Features of Go-SQLcmd<\/h3>\n<ul>\n<li><strong>Open Source<\/strong>: Available under the MIT license on <a href=\"https:\/\/github.com\/microsoft\/go-sqlcmd\">GitHub<\/a>.<\/li>\n<li><strong>Cross-Platform<\/strong>: Compatible with Windows, macOS, and Linux for both X64 and ARM64 architectures.<\/li>\n<li><strong>Authentication<\/strong>: Supports various Azure Active Directory authentication methods, including:\n<ul>\n<li>ActiveDirectoryDefault<\/li>\n<li>ActiveDirectoryIntegrated<\/li>\n<li>ActiveDirectoryPassword<\/li>\n<li>ActiveDirectoryInteractive<\/li>\n<li>ActiveDirectoryManagedIdentity<\/li>\n<li>ActiveDirectoryServicePrincipal<\/li>\n<\/ul>\n<\/li>\n<li><strong>Enhanced Functionality<\/strong>: Includes all SQLCMD features and improvements, such as vertical result formatting.<\/li>\n<\/ul>\n<h3>Installation<\/h3>\n<p>To install Go-SQLcmd, use Winget:<\/p>\n<pre><code>winget install sqlcmd<\/code><\/pre>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-361\" src=\"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10-300x66.png\" alt=\"\" width=\"686\" height=\"151\" srcset=\"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10-300x66.png 300w, https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10-768x169.png 768w, https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10-850x187.png 850w, https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10.png 975w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/h3>\n<h3>Usage<\/h3>\n<h4>Display Help<\/h4>\n<p>To see the help documentation for Go-SQLcmd, use the following command:<\/p>\n<pre><code>sqlcmd --help<\/code><\/pre>\n<h4>Show Context<\/h4>\n<p>To view the current configuration context, use:<\/p>\n<pre><code>sqlcmd config view<\/code><\/pre>\n<h3>Spinning Up a Container<\/h3>\n<p>To create a new SQL Server container, use the following command. This will spin up a container with SQL Server:<\/p>\n<pre><code>sqlcmd create mssql --accept-eula<\/code><\/pre>\n<p>To connect to the newly created container and query its version, use:<\/p>\n<pre><code>sqlcmd query \"SELECT @@version\"<\/code><\/pre>\n<p>To avoid having to accept the End User License Agreement (EULA) every time, set an environment variable:<\/p>\n<pre><code>[System.Environment]::SetEnvironmentVariable('SQLCMD_ACCEPT_EULA', 'YES', 'Machine')<\/code><\/pre>\n<h3>Additional Commands<\/h3>\n<h4>List Available Tags<\/h4>\n<p>To see all available SQL Server versions that can be created, use:<\/p>\n<pre><code>sqlcmd create mssql get-tags<\/code><\/pre>\n<h4>Open in Azure Data Studio<\/h4>\n<p>To open Azure Data Studio and connect it to the SQL Server container, use:<\/p>\n<pre><code>sqlcmd open ads<\/code><\/pre>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-363\" src=\"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-12-300x139.png\" alt=\"\" width=\"300\" height=\"139\" srcset=\"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-12-300x139.png 300w, https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-12.png 475w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/h3>\n<h3>Advanced Usage<\/h3>\n<h4>Pause the Container<\/h4>\n<p>If you need to pause the SQL Server container, use the following command:<\/p>\n<pre><code>sqlcmd stop<\/code><\/pre>\n<h4>Create a Container with a Specific Version and Restore Database<\/h4>\n<p>To create a SQL Server container with a specific version and restore a database from a backup file, use:<\/p>\n<pre><code>sqlcmd create mssql --accept-eula --tag 2019-latest --using AdventureWorksLT.bak<\/code><\/pre>\n<h4><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-362\" src=\"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-11-300x110.png\" alt=\"\" width=\"660\" height=\"242\" srcset=\"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-11-300x110.png 300w, https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-11-768x283.png 768w, https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-11-850x313.png 850w, https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-11.png 975w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><\/h4>\n<h4>Clean Up<\/h4>\n<p>To stop and delete a SQL Server container, use the following commands:<\/p>\n<pre><code>sqlcmd stop\nsqlcmd delete<\/code><\/pre>\n<h3>Example Scenarios<\/h3>\n<h4>Install Previous Version<\/h4>\n<p>To see all available SQL Server release tags and install a previous version, use:<\/p>\n<pre><code>sqlcmd create mssql get-tags\nsqlcmd create mssql --tag 2019-latest<\/code><\/pre>\n<h4>Create SQL Server with AdventureWorks Sample Database<\/h4>\n<p>To create a SQL Server container and attach the AdventureWorks sample database, use:<\/p>\n<pre><code>sqlcmd create mssql --using https:\/\/aka.ms\/AdventureWorksLT.bak<\/code><\/pre>\n<h4>Create SQL Server with Custom Database Name<\/h4>\n<p>To create a SQL Server container and attach the AdventureWorks sample database with a custom name, use:<\/p>\n<pre><code>sqlcmd create mssql --using https:\/\/aka.ms\/AdventureWorksLT.bak,adventureworks<\/code><\/pre>\n<h4>Create SQL Server with Empty User Database<\/h4>\n<p>To create a SQL Server container with an empty user database, use:<\/p>\n<pre><code>sqlcmd create mssql --user-database db1<\/code><\/pre>\n<h4>Install with Full Logging<\/h4>\n<p>To create a SQL Server container with full logging enabled, use:<\/p>\n<pre><code>sqlcmd create mssql --verbosity 4<\/code><\/pre>\n<h3>Conclusion<\/h3>\n<p>Go-SQLcmd offers a practical and efficient way to manage SQL Server environments. By using this tool, developers and database administrators can quickly spin up SQL Server instances in a lightweight manner. The ability to create containers, restore databases from backups, and integrate seamlessly with Azure Data Studio makes Go-SQLcmd a useful addition to your toolkit.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn how Go-SQLcmd enhances SQLCMD by providing a lightweight and efficient way to manage SQL Server environments using Docker containers. This guide covers the capabilities of Go-SQLcmd, including container creation and database restoration. Follow detailed installation steps and practical usage examples to streamline your SQL Server development and testing workflows. Ideal for developers and database administrators looking for cross-platform solutions.&#8221;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[22,84,21],"tags":[185,24,23,211,131,212,214,213],"class_list":["post-359","post","type-post","status-publish","format-standard","hentry","category-containers","category-sql-developer","category-tutorial","tag-azure-data-studio","tag-containers","tag-docker","tag-go-sqlcmd","tag-sql-server","tag-sqlcmd","tag-windows-subsystem-for-linux","tag-winget"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>GO for it with SQLCMD: Introducing the Modern SQLcmd - SQL Table Talk<\/title>\n<meta name=\"description\" content=\"Learn how Go-SQLcmd enhances SQLCMD by providing a lightweight and efficient way to manage SQL Server environments using Docker containers. This guide covers the capabilities of Go-SQLcmd, including container creation and database restoration. Follow detailed installation steps and practical usage examples to streamline your SQL Server development and testing workflows. Ideal for developers and database administrators looking for cross-platform solutions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqltabletalk.com\/?p=359\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GO for it with SQLCMD: Introducing the Modern SQLcmd - SQL Table Talk\" \/>\n<meta property=\"og:description\" content=\"Learn how Go-SQLcmd enhances SQLCMD by providing a lightweight and efficient way to manage SQL Server environments using Docker containers. This guide covers the capabilities of Go-SQLcmd, including container creation and database restoration. Follow detailed installation steps and practical usage examples to streamline your SQL Server development and testing workflows. Ideal for developers and database administrators looking for cross-platform solutions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqltabletalk.com\/?p=359\" \/>\n<meta property=\"og:site_name\" content=\"SQL Table Talk\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-30T13:00:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10-300x66.png\" \/>\n<meta name=\"author\" content=\"Yvonne Vanslageren\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yvonne Vanslageren\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=359#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=359\"},\"author\":{\"name\":\"Yvonne Vanslageren\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/68bb31b454bafe9e139183ed4f3e9082\"},\"headline\":\"GO for it with SQLCMD: Introducing the Modern SQLcmd\",\"datePublished\":\"2024-07-30T13:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=359\"},\"wordCount\":573,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"image\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=359#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10-300x66.png\",\"keywords\":[\"Azure Data Studio\",\"Containers\",\"Docker\",\"Go-SQLcmd\",\"SQL Server\",\"SQLCMD\",\"Windows Subsystem for Linux\",\"Winget\"],\"articleSection\":[\"Containers\",\"SQL Developer\",\"Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=359#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=359\",\"url\":\"https:\/\/www.sqltabletalk.com\/?p=359\",\"name\":\"GO for it with SQLCMD: Introducing the Modern SQLcmd - SQL Table Talk\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=359#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=359#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10-300x66.png\",\"datePublished\":\"2024-07-30T13:00:00+00:00\",\"description\":\"Learn how Go-SQLcmd enhances SQLCMD by providing a lightweight and efficient way to manage SQL Server environments using Docker containers. This guide covers the capabilities of Go-SQLcmd, including container creation and database restoration. Follow detailed installation steps and practical usage examples to streamline your SQL Server development and testing workflows. Ideal for developers and database administrators looking for cross-platform solutions.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=359#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqltabletalk.com\/?p=359\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=359#primaryimage\",\"url\":\"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10.png\",\"contentUrl\":\"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10.png\",\"width\":975,\"height\":215},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqltabletalk.com\/?p=359#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqltabletalk.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GO for it with SQLCMD: Introducing the Modern SQLcmd\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#website\",\"url\":\"https:\/\/www.sqltabletalk.com\/\",\"name\":\"SQL Table Talk\",\"description\":\"Breaking Down SQL Server, One Post at a Time.\",\"publisher\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqltabletalk.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0\",\"name\":\"Stephen Planck\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g\",\"caption\":\"Stephen Planck\"},\"logo\":{\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/dexterwiki.com\",\"https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI\",\"https:\/\/www.youtube.com\/linuxmate\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/68bb31b454bafe9e139183ed4f3e9082\",\"name\":\"Yvonne Vanslageren\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/22c274a7a354b81a0a8dc5b23e8e0be9bdd81a6bc0541474cfb6b954d6bb2089?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/22c274a7a354b81a0a8dc5b23e8e0be9bdd81a6bc0541474cfb6b954d6bb2089?s=96&d=mm&r=g\",\"caption\":\"Yvonne Vanslageren\"},\"url\":\"https:\/\/www.sqltabletalk.com\/?author=2\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"GO for it with SQLCMD: Introducing the Modern SQLcmd - SQL Table Talk","description":"Learn how Go-SQLcmd enhances SQLCMD by providing a lightweight and efficient way to manage SQL Server environments using Docker containers. This guide covers the capabilities of Go-SQLcmd, including container creation and database restoration. Follow detailed installation steps and practical usage examples to streamline your SQL Server development and testing workflows. Ideal for developers and database administrators looking for cross-platform solutions.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqltabletalk.com\/?p=359","og_locale":"en_US","og_type":"article","og_title":"GO for it with SQLCMD: Introducing the Modern SQLcmd - SQL Table Talk","og_description":"Learn how Go-SQLcmd enhances SQLCMD by providing a lightweight and efficient way to manage SQL Server environments using Docker containers. This guide covers the capabilities of Go-SQLcmd, including container creation and database restoration. Follow detailed installation steps and practical usage examples to streamline your SQL Server development and testing workflows. Ideal for developers and database administrators looking for cross-platform solutions.","og_url":"https:\/\/www.sqltabletalk.com\/?p=359","og_site_name":"SQL Table Talk","article_published_time":"2024-07-30T13:00:00+00:00","og_image":[{"url":"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10-300x66.png","type":"","width":"","height":""}],"author":"Yvonne Vanslageren","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yvonne Vanslageren","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqltabletalk.com\/?p=359#article","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/?p=359"},"author":{"name":"Yvonne Vanslageren","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/68bb31b454bafe9e139183ed4f3e9082"},"headline":"GO for it with SQLCMD: Introducing the Modern SQLcmd","datePublished":"2024-07-30T13:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqltabletalk.com\/?p=359"},"wordCount":573,"commentCount":0,"publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"image":{"@id":"https:\/\/www.sqltabletalk.com\/?p=359#primaryimage"},"thumbnailUrl":"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10-300x66.png","keywords":["Azure Data Studio","Containers","Docker","Go-SQLcmd","SQL Server","SQLCMD","Windows Subsystem for Linux","Winget"],"articleSection":["Containers","SQL Developer","Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqltabletalk.com\/?p=359#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqltabletalk.com\/?p=359","url":"https:\/\/www.sqltabletalk.com\/?p=359","name":"GO for it with SQLCMD: Introducing the Modern SQLcmd - SQL Table Talk","isPartOf":{"@id":"https:\/\/www.sqltabletalk.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqltabletalk.com\/?p=359#primaryimage"},"image":{"@id":"https:\/\/www.sqltabletalk.com\/?p=359#primaryimage"},"thumbnailUrl":"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10-300x66.png","datePublished":"2024-07-30T13:00:00+00:00","description":"Learn how Go-SQLcmd enhances SQLCMD by providing a lightweight and efficient way to manage SQL Server environments using Docker containers. This guide covers the capabilities of Go-SQLcmd, including container creation and database restoration. Follow detailed installation steps and practical usage examples to streamline your SQL Server development and testing workflows. Ideal for developers and database administrators looking for cross-platform solutions.","breadcrumb":{"@id":"https:\/\/www.sqltabletalk.com\/?p=359#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqltabletalk.com\/?p=359"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqltabletalk.com\/?p=359#primaryimage","url":"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10.png","contentUrl":"https:\/\/www.sqltabletalk.com\/wp-content\/uploads\/2024\/02\/image-10.png","width":975,"height":215},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqltabletalk.com\/?p=359#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqltabletalk.com\/"},{"@type":"ListItem","position":2,"name":"GO for it with SQLCMD: Introducing the Modern SQLcmd"}]},{"@type":"WebSite","@id":"https:\/\/www.sqltabletalk.com\/#website","url":"https:\/\/www.sqltabletalk.com\/","name":"SQL Table Talk","description":"Breaking Down SQL Server, One Post at a Time.","publisher":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqltabletalk.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/1947e42a9438bccd91691d8b791888e0","name":"Stephen Planck","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64181114edc3de3d99072c049bcec024f025c9536dc89fc8ff1bac58976ca81e?s=96&d=mm&r=g","caption":"Stephen Planck"},"logo":{"@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/dexterwiki.com","https:\/\/www.linkedin.com\/in\/stephen-planck-4611b692?trk=people-guest_people_search-card&challengeId=AQErf8gbBmcVMwAAAYsyIsxO-0UvU8z7cHrBpZoo_n3xt9qEKpRN5B_jd_LmAMu-OfeArkQ7GDjobJ2uRoQQV35EQdh_rR6kxA&submissionId=09de7067-c335-8e17-40b8-8dc32b60ed6c&challengeSource=AgEcUCw35zpPmAAAAYsyI4vAWhJTV7Nt4vZYKc3V1qiDBpCkKgUvtlOBgYXcE84&challegeType=AgE_wZiTT09IAQAAAYsyI4vDmNvbZIYe6XHju5V2bXVvM3IVxnJslgY&memberId=AgESFTkUShzs_gAAAYsyI4vGYk0Gic1uc5kB6cKOABA26Gw&recognizeDevice=AgHdSZyUSI5CEwAAAYsyI4vKd_koF9JgpsCJShT8QfbK1QMiv8SI","https:\/\/www.youtube.com\/linuxmate"]},{"@type":"Person","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/68bb31b454bafe9e139183ed4f3e9082","name":"Yvonne Vanslageren","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqltabletalk.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/22c274a7a354b81a0a8dc5b23e8e0be9bdd81a6bc0541474cfb6b954d6bb2089?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/22c274a7a354b81a0a8dc5b23e8e0be9bdd81a6bc0541474cfb6b954d6bb2089?s=96&d=mm&r=g","caption":"Yvonne Vanslageren"},"url":"https:\/\/www.sqltabletalk.com\/?author=2"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=359"}],"version-history":[{"count":10,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/359\/revisions"}],"predecessor-version":[{"id":688,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=\/wp\/v2\/posts\/359\/revisions\/688"}],"wp:attachment":[{"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqltabletalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}