SQL Developer Tools | Microsoft (original) (raw)
SQL Server for Developers
Build modern applications with your favorite languages and frameworks.
Build apps that scale with managed and intelligent SQL database in the cloud with Azure SQL Database.
Get started quickly with these developer resources
The latest SQL Server tutorials, tools, quick starts, and code examples in the coding languages you love.
Development tools
Showing %{start}%{separator}%{end} of %{total} items
SQL Server Management Studio
SQL Server Management Studio (SSMS) is an integrated environment that provides developers and database administrators of all skill levels access to SQL Server.
Visual Studio Code
A powerful, lightweight free code editor with integrated tools to easily deploy your code to Azure.
Azure Data Studio
Azure Data Studio is a lightweight, cross-platform data management and development tool with connectivity to popular cloud and on-premises databases.
SQLCMD
A command-line utility for ad hoc, interactive execution of Transact-SQL (T-SQL) statements and scripts and for automating T-SQL scripting tasks.
Visual Studio
The 64-bit integrated development environment (IDE) designed for creating powerful and scalable applications for Azure.
End of Development tools section
Developing with SQL Server
Showing %{start}%{separator}%{end} of %{total} items
Skip Developing with SQL server null
.NET/C#
The Microsoft SqlClient Data Provider for SQL Server is a .NET Framework and .NET Core data provider.
Java
Microsoft provides a Java Database Connectivity (JDBC) driver for use with SQL Server, Azure SQL Database, and Azure SQL Managed Instance at no extra charge
Node.js
The tedious module is a JavaScript implementation of the TDS protocol, which is supported by all modern versions of SQL Server. The driver is an open-source project, available on GitHub.
Python
You can connect to a SQL Database using pyodbc, an open source Python module that makes accessing ODBC databases simple.
Go
Use the Golang programming language to connect to an Azure SQL Database or a database in Azure SQL Managed Instance with the go-mssqldb driver
PHP
The Microsoft Drivers for PHP for SQL Server enable integration with SQL Server for PHP applications.
End of Developing with SQL server section
Quickstarts and tutorials
Showing %{start}%{separator}%{end} of %{total} items
Skip Developing with SQL server null
Connect and query a SQL Server instance using SQL Server Management Studio (SSMS)
This quickstart shows how to use SQL Server Management Studio (SSMS) to connect to your SQL Server instance and run some Transact-SQL (T-SQL) commands.
Use Azure Data Studio to connect and query SQL Server
This quickstart shows how to use Azure Data Studio to connect to SQL Server, and then use Transact-SQL (T-SQL) statements to create the TutorialDB used in Azure Data Studio tutorials.
Import Flat File to SQL Wizard
This tutorial describes the reasons for using the Import Flat File Wizard, how to find this wizard, and a simple example to follow.
Tips and tricks for using SQL Server Management Studio (SSMS)
This article shows how to comment and uncomment code, indent text, filter objects, access error logs, and find SQL Server instance names with SQL Server Management Studio (SSMS).
End of Developing with SQL server section
Learning resources
Introduction to SQL Server 2022
Learn about new major capabilities of SQL Server 2022 from cloud connected features to core engine capabilities.
Back up and restore databases
Plan and implement policy for recovering data if user errors occur or the technology fails. Explore various options for how and where to back up and restore databases.
Design a data storage solution for relational data
Azure Architects design and recommend relational data storage solutions.
Introduction to Transact-SQL
This module introduces relational databases, the SQL language and Transact-SQL. You'll learn what kinds of statements make up the SQL language and look at the SELECT statement in detail.
GitHub SQL Samples
Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge.
The SQL Server 2022 Workshop
In this course you will learn how to solve modern data challenges with SQL Server 2022 using a hands-on lab approach.
GitHub Azure SQL Database Examples
Official Microsoft GitHub Repository containing code examples specifically for Azure SQL Database.
GitHub Azure Samples
Microsoft Azure code samples and examples in .NET, Java, Python, JavaScript, TypeScript, PHP and Ruby.
Join the community
SQL Server blog
Get the latest Microsoft SQL Server news, updates, and best practices from our Microsoft experts.
Azure SQL Dev blogs
Voices from the Azure SQL PM Team, focusing on development and developers.
Tech forums
Tech community for best practices and the latest news on SQL Server.
Microsoft Developer YouTube channel
Watch live events, tips and tutorials, product news, and more.
Additional resources
Documentation
Explore new features for SQL Server.
SQL Server Security
Best practices and guidelines that help establish security for SQL Server.
Migration resources
Azure cloud migration and modernization center.
Data sheet
SQL Server 2022 datasheet