Database client

SQL Server Management Studio

SSMS is the application used to connect to and manage SQL Server databases.

What it is for

Write SQL in its Query Window and inspect results. The database engine stores and processes the data; SSMS is the client you interact with.

Install SSMS using Microsoft’s official installation page. Install or obtain access to a separate SQL Server instance to execute queries.

Open Start → SQL Server Management Studio.
Connect to your local learning instance using its configured server name and authentication. Select New Query after connecting.

Where · SSMS

In SQL Server Management Studio, the database client application. Tool guide

Open Help → About.

What you should see: The SSMS product version appears. This does not prove that SQL Server is installed or running.

Where · SSMS Query Window

Connect to your local learning server → New Query. Check the database selector before Execute. Tool guide

In New Query, check the connected server and select master in the database selector. Paste the query, select it and click Execute.

SELECT 1 AS Ready;

What you should see: A Results tab shows Ready = 1. SQL belongs here, not in PowerShell or Program.cs.

No Results tab: check the Messages tab for an error and confirm you pressed Execute.
Cannot connect: the engine, instance name or authentication may be wrong; SSMS itself can still be correctly installed.
Multiple queries in the window: select only the statement you intend to execute.

Some use it only for optional local practice. Each lesson explains what you actually need.

No published lesson requires this tool yet. This guide is ready for future follow-along tutorials.

Guide reviewed 2026-09-09. Menu labels can differ between versions.