MS SQL Server Management Studio

SQL Server Management Studio is a Workstation Component\Client Tool which is installed if we select the Workstation Component in the installation step. This allows you to connect and manage SQL Server from a graphical interface without having to use the command line.

In order to connect to a remote instance of SQL Server, you will need this or similar software. It is used by administrators, developers, testers, etc.

The following method is used to open SQL Server Management Studio.

Start → All Programs → MS SQL Server 2012 → SQL Server Management Studio

Go to Run and type SQLWB (for 2005 versions) SSMS (for 2008 and later). Then hit enter.

SQL Server Management Studio will open in either of the above methods, as shown in the snapshot below.

MS SQL Server - Overview

MS SQL Server - Edition

MS SQL Server - Installation

MS SQL Server - Schema

MS SQL Server Management Studio

MS SQL Server - login database

MS SQL Server - create database

MS SQL Server - select database

MS SQL Server - delete database

MS SQL Server - Create Backup

MS SQL Server - restore database

MS SQL Server - Create User

MS SQL Server - Assign Permissions

MS SQL Server - Monitoring Database

MS SQL Server - Services

MS SQL Server – HA Technology

MS SQL Server - Reporting Services

MS SQL Server - Execution Plan

MS SQL Server - Integration Services

MS SQL Server - Analysis Services

All  Microsoft SQL Server are available for free in pdf version.