Cross platform SQL Server Management for Developers Using VS Code

https://app.pluralsight.com/courses/e3a44860-74ad-4888-88ed-ff9e358b2382/table-of-contents

Course Overview

Course Overview

• mssql extension - access any sql server db from VS Code

Introduction and Installing VS Code and the mssql Extension

Module and Course Overview

• Intro to VS Code (install on Windows, macOS)
• Installing mssql extension
• DBs on Windows, SQL Azure and SQL Server for Linux
• Connections, commands and queries

Introducing VS Code and the mssql Extension

• VS Code is open source and built on top of Electron library for building cross-platform desktop apps using JS, HTML and CSS
• Features: in-built debugging for JS, TypeScript and Node.js; language support by extensions; git commands support
• Coding Helpers: e.g. linters, key mappers, snippets
• Monthly VS Code update releases, over 3000 extensions

...

Connecting to the Various SQL Servers from Various Platforms

mssql's Commands and Execution Engine

• switch to relevant execution engine for a text file (bottom-right corner or `mssql new query')

Connecting to LocalDB While Learning More About mssql Connections