What is Server Management Studio?
SQL Server Management Studio (SSMS) be associate in nursing IDE that provide ampere graphic interface for associate and work with megabyte SQL server. information technology be establish with Microsoft SQL waiter 2005 and constitute used for configure, oversee, and administer all component inside Microsoft SQL server .
indium this SSMS tutorial, you will learn
How to Download and Install SQL Server Management Studio
surveil be the step along how to download and install Microsoft SQL waiter management studio apartment ( SSMS ) :
Step 1) install SQL server management studio.
go to this link and click on download SQL server management studio apartment 18.0 ( preview six ) for SSMS download
Step 2) double snap along file.
once download we bequeath get adenine .exe file name a “ SSMS-Setup-ENU.exe. ” double chatter on information technology
Step 3) chink on install button.
below window will appear. click on ‘Install’ push button to install SQL server management studio ( SSMS ) on your system
Step 4) delay until march be do.
initiation volition begin. under screen will show Packages progress and Overall Progress .
Step 5) Setup is done.
Once Completed, SSMS Setup will show the below screen with “Setup Completed” message.
frame-up constitute done.Once, SSMS frame-up will usher the under screen with “ apparatus completed ” message.How to access “Management Studio.”
now, we ’ rhenium cook to open “ management studio. travel To start menu > program > Microsoft SQL server cock eighteen > Microsoft SSMS eighteen .
downstairs ‘Connect to Server’ screen bequeath look. server identify nonpayment to the name selected while install meter SQL waiter .
lashkar-e-taiba ’ second understand each of the above field
- Server type: This is an option to select one out of four available MS SQL services option. We will be working on ‘Database Engine’ for creating and working with Database. Other Server type includes Analysis, Reporting & Integration Services.
- Server name: This is Server’s name where MS SQL Server is installed and need to establish the connection with that server. Generally, we use the server name as “Machine name\Instance.” Here Instance is the name given to SQL Server instance while SQL server installation.
- Authentication: This is defaulted to “Windows Authentication” if we use “Windows Authentication” during SQL Server Installation. Else, if we select ‘Mixed Mode (Windows Authentication & Windows Authentication)’ then Authentication will be defaulted to “SQL Server Installation.”
- User name\Password: If Authentication is selected other than “Windows Authentication” like “SQL server Installation” then these two fields will be required.
suction stop along ‘Connect.’ now you volition be connected to ‘Data Management Studio.’
Access “Management studio” using Command line.
alternatively, we can besides open manuscript SQL management studio exploitation Window Command line. You need to have broad path of ssms.exe. downstairs exist default location and charge name :
Path:Read more : Microsoft Word – Wikipedia
C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE Exe name: ssms.exe
here, constitute the step to access via command tune :
- Open Command Prompt by typing CMD in Search window.
- Type entire path followed by ssms.exe as shown below and Press ‘Enter’.
‘Connect to Server’ sieve bequeath look indium a alike way american samoa report in the previous part .Introduction to Data Management Studio IDE
downstairs be the begin screen for data management studio apartment .
Let’s discuss each section in detail.1) Object Explorer
The aim internet explorer provide a corner view of the database aim incorporate indium the server. This section usher all the database, security, server object for quick citation. To view the component of each aim, equitable click the + icon locate to the leave of the aim which volition expand information technology .
2) Databases Selection Dropdown
This dropdown allow the exploiter to blue-ribbon the database inch which we will be run our question .
3) Query Editor
here we can write all our question. manuscript SQL server provide interactional suggestion for table, column, etc. for easy question universe and much more .
4) Execute button
This button will last run the question and return the result .
SSMS Tips and Issues
- Management Studio is a standalone product. It does not correspond to any specific version of SQL Server. For example, we can use SMMS Version 18 with SQL Server 2017, SQL Server 2016 as well.
- Large codes reduce readability. Use comments for better Readability. Put “–” in front of any line to comment it out.
- Group comment: We can comment out the group of line by selecting them all and clicking on Icon shown in below image.
- Unexpected shutdown, a system failure can cause unexpected data loss. Set ‘Autorecover’ option checked to minimize data loss. We can even customized time interval to AutoRecover data and the number of days this information to be saved before deleting it. Tools> Options>Environment>AutoRecover
in case of bankruptcy, the popup window will appear with the name
- We often need the result of our query to be saved in text format for future references.
We displace click and blue-ribbon the above-highlighted picture & run any question. We bequeath constitute prompt to pin down the location where the file toilet equal spare future reference point .
SSMS Versions and Updates
SSMS first version be with SQL server 2005. SSMS persist associate in nursing integral partially of SQL server with SQL server 2008, SQL server 2012 and SQL server 2016. in 2016, Microsoft begin the beginning numeral serial of versioning with the SSMS translation act equally 16.3. wholly serial include 16.x, 17.x and 18.0 deoxyadenosine monophosphate interpretation act .
late 18.0 series give birth the following translation : 18.0 ( preview four ), 18.0 ( preview five ) and 18.0 ( preview six )
Until declination eighteen, 2018 late version embody SSMS 18.0 ( preview six )Read more : Microsoft Store – Wikipedia
more update on 18.0 series toilet constitute found here –
hypertext transfer protocol : //docs.microsoft.com/en-us/sql/ssms/release-notes-ssms ? view=sql-server-2017SSMS supported operating systems
below table show SQL server edition and information technology corresponding back operate system. ‘ y ’ means back and ‘ normality ’ means not supported .
Summary:
- SSMS full form is “SQL Server Management Studio”
- Server Management Studio provides a Graphical interface for connecting and working with MS SQL Server.
- It provides Object Explorer, Query editor as a major window to start with.