SQL Server Management Studio

WHAT IS THE SERVER MANAGEMENT STUDIO?

DOWNLOAD AND INSTALL SQL SERVER MANAGEMENT STUDIO

HOW TO GET ACCESS TO THE “MANAGEMENT STUDIO”.

  • Server type: this option allows you to select one of the four available MS SQL service options. We will work on the Database Engine component to create and work with the database. The other type of server includes analysis, reporting, and integration services.
  • Server name: this is the name of the server on which MS SQL Server is installed and for which a connection to this server must be established. Usually, we use the server name as “Computer name \ Instance”. Here Instance is the name given to the SQL Server instance during the SQL Server installation.
  • Authentication: by default “Windows Authentication” is used if we use “Windows Authentication” during the SQL Server installation. Otherwise, if we select “Mixed Mode (Windows Authentication and Windows Authentication)”, then “SQL Server Installation” is set by default for Authentication.
  • Username \ Password: if you select Authentication other than “Windows Authentication”, e.g. “SQL Server Installation”, then these two fields will be required.
  • Click on “Connect”. You will now be connected to “Data Management Studio”.

INTRODUCTION TO DATA MANAGEMENT STUDIO IDE

OBJECT VIEWER

TIPS AND TROUBLES OF SSMS

  • Management Studio is a standalone product. It does not match any particular version of SQL Server. For example, we can use SMMS Version 18 with SQL Server 2017 as well as with SQL Server 2016.
  • Larger codes reduce the readability of. Use comments for better readability. Put a “-” before any line to comment on.
  • Group comment: we can comment on a group of rows by selecting them all and clicking on the icon shown in the image below.
  • We often need the result of our query to be saved in text format for future links.

VERSIONS AND SSMS UPDATES

SSMS SUPPORTED OPERATING SYSTEMS

ABSTRACT:

  • Server Management Studio provides a graphical interface for connecting and working with MS SQL Server.
  • It provides Object Explorer, a query editor, as the main window to start with.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Akademily

Akademily

We conduct reviews, guides and comparative tests of gaming laptops, monitors, graphics cards, keyboards, mouses, headsets and chairs to help you buy the best ga