Cross platform SQL Server Management for Developers Using VS Code - p-patel/software-engineer-knowledge-base GitHub Wiki
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')