Overview

SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is designed to handle large volumes of data and is widely used in enterprise applications. SQL Server provides a range of features and capabilities, including support for complex queries, indexing, and geospatial data.

Supported Authentiction Methods

DBCode supports the following authentication methods for SQL Server:

  • SQL Based Username and password
  • Microsoft Entra ID (via Azure SQL)
  • Windows Integrated Authentication

In addition to the above authentication, DBCode also supports connecting to named instances of SQL Server.

Connecting

To connect to SQL Server, follow these general steps:

  1. Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
  2. Add a New Connection: Click on the “Add Connection” icon.
  3. Complete new connection form: Choose SQL Server as the type, and enter the required information.
  4. Connect: Click save to connect to your SQL Server database.
  5. Start Managing Your Databases: Once connected, you can start managing your databases directly from Visual Studio Code.

For detailed instructions on connecting to SQL Server, refer to the Connect article.

Connect Multiple Databases

A number of cloud providers offer SQL Server as a service. To connect to a cloud provider and access multiple databases, follow these general steps:

  1. Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
  2. Add a New Connection: Click on the “Add Connection” icon.
  3. Select Your Provider: Choose the cloud provider from the list on the right.
  4. Authenticate: Follow the authentication process specific to the provider.
  5. Start Managing Your Databases: Once connected, you can start managing your databases directly from Visual Studio Code.

For detailed instructions on connecting to SQL Server, refer to the Connect a Cloud Provider article.

By using SQL Server with DBCode, you can connect to your SQL Server databases, query and manage your data, and visualize your results, all directly from Visual Studio Code.

For more information about SQL Server, check out SQL Server.