Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
You can use SQL Server Management Studio (SSMS) to connect to and query Synapse SQL in Azure Synapse Analytics through either serverless SQL pool or dedicated SQL pool resources.
Azure Data Studio is fully supported starting from version 1.18.0. SSMS is partially supported starting from version 18.5, you can use it to connect and query only.
Before you begin, make sure you have the following prerequisites:
To connect to Synapse SQL using dedicated SQL pool, follow these steps:
Open SQL Server Management Studio (SSMS).
In the Connect to Server dialog box, fill in the fields, and then select Connect:
Expand your Azure SQL Server in Object Explorer. You can view the databases associated with the server, such as the sample AdventureWorksDW database. You can expand the database to see the tables:
To connect to Synapse SQL using serverless SQL pool, follow these steps:
Open SQL Server Management Studio (SSMS).
In the Connect to Server dialog box, fill in the fields, and then select Connect:
To explore, expand your Azure SQL server. You can view the databases associated with the server. Expand demo to see the content in your sample database.
Now that a database connection has been established, you can query the data.
Right-click your database in SQL Server Object Explorer.
Select New Query. A new query window opens.
Copy the following T-SQL query into the query window:
SELECT COUNT(*) FROM dbo.FactInternetSales;
Run the query by selecting Execute
or use the following shortcut: F5
.
Look at the query results. In the following example, the FactInternetSales table has 60398 rows.
Now that you've established a database connection, you can query the data.
Right-click your database in SQL Server Object Explorer.
Select New Query. A new query window opens.
Copy the following T-SQL query into the query window:
SELECT COUNT(*) FROM demo.dbo.usPopulationView
Run the query by selecting Execute
or use the following shortcut: F5
.
Look at the query results. In this example, the usPopulationView view has 3664512 rows.
Now that you can connect and query, try visualizing the data with Power BI.
To configure your environment for Microsoft Entra authentication, see Authenticate to Synapse SQL.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayTraining
Module
Use Azure Synapse serverless SQL pool to query files in a data lake - Training
Use Azure Synapse serverless SQL pool to query files in a data lake
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.