Sql Server Management Studio 2012 Tutorial

SQL Server Management Studio (SSMS)

MS SQL Server Management Studio is a workstation or a client tool which is used to connect to and manage your SQL Peladen

SQL Peladen Management Studio (SSMS) is a
windows software or a client tool
used to connect and work with our SQL Peladen from a
graphical interface
instead of using the command line. Microsoft SQL Server 2005 launched the management sanggar to work with SQL Server and Azure SQL databases.

It allows DBAs and database developers to
configure, manage, and
administer
all components within SQL Server. Its main functionality is to create databases and tables, execute SQL queries for inserting, updating, and deleting data, creating and managing stored procedures, triggers, views, and cursors. It also enables us to set privileges (securities) on databases and their objects.

SSMS also includes tools for deployment, database health monitoring, and reporting. It includes
SQL Profiler, which allows us to examine the performance of our SQL databases. It’s also possible to use it to schedule background work. If we want to connect to a remote SQL Server instance, we’ll need this GUI tool or similar software. It is used by Administrators, Developers, Testers, etc. The latest version of SQL Server Management Studio is
SSMS 18.8 RC. If we have installed a previous version, we just need to install
SSMS 18.8 upgrades.

SSMS System Requirements

The following are the requirements to install the current release of SSMS when used with the latest available service pack:

It will support the below Operating Systems:

  • Windows 10 (64-bit) version 1607 (10.0.14393) or later
  • Windows 8.1 (64-bit)
  • Windows Peladen 2022 (64-bit)
  • Windows Server 2022 (64-bit)
  • Windows Server 2022 R2 (64-bit)
  • Windows Server 2022 (64-bit)
  • Windows Server 2008 R2 (64-bit)

Before installing it on your system, we must have the following hardware:

  • 8 GHz or faster x86 processor. For better use, it is recommended to have Dual-core.
  • It requires a minimum of 2 GB RAM, but 4 GB is recommended (if it runs on a virtual machine, a minimum of 2.5 GB is required).
  • We must have a minimum of 2 GB up to 10 GB space on the hard disk.

How to Download and Install SQL Peladen Management Studio (SSMS)

We can use the following steps to download and install Microsoft SQL Server Management Studio (SSMS) in the Windows system:

Step 1:
Go to the official page by clicking on this link and click on Download SQL Server Management Studio 18.08. Immediately the SSMS setup starts downloading on your system.

SQL Server Management Studio

Step 2:
Once the file has been downloaded, it will be named “SSMS-Setup-ENU.exe.” Now, double-click on it to continue.

SQL Server Management Studio

If you see the prompt message “Do you want to allow the following to make a change this computer? Say
YES.

Step 3:
We will see a below window. Here, we can change the installation location and then click the
‘Install’
button for installing SQL Server Management Studio (SSMS) on your device.

SQL Server Management Studio

Step 4:
The installation process will start. We will see the progress of the packages and the overall progress on the below screen. Since it downloads the necessary packages from the internet, the installation can take some time.

SQL Server Management Studio

SQL Server Management Studio

Step 5:
When SSMS Setup is finished, it will show the screen below with the “Setup Completed” message. It’s possible that we may prompt us to restart our computer.

SQL Server Management Studio

How to access SQL Server Management Padepokan

We can use the following steps to access SQL Server Management Studio (SSMS):

Go to Start Menu>Programs>Microsoft SQL Server Tools 18> Microsoft SSMS 18.

SQL Server Management Studio

The
‘Connect to Server’
dialogue screen will appear in front of us when we start SSMS. Set the
Server name
and
Authentication type
of the SQL Peladen we want to connect to on this screen, then click the
Connect
button to be connected to
‘Data Management Studio’. Here the peladen name defaults to the name chosen during the installation of the MS SQL peladen.

SQL Server Management Studio

Let us understand each field of the above screen in detail:

Peladen type:
It is a dropdown menu that allows us to choose one of four MS SQL services options. Here we’ll be working on the
‘Database Engine’
that enables us to create and work with databases. Some of the examples of other server types are Analysis, Reporting, and Integration Services.

Peladen name:
It is the peladen’s name where MS SQL Peladen is installed, and we will need to connect with that server. In most cases, we refer to the server name as “Machine name/Instance.” Here we batas given the Instance name to the SQL Server instance during installation.

Authentication:
If we use “Windows Authentication” during SQL Server’s installation, this option is set to “Windows Authentication.” Authentication will be set to “SQL Server Installation” if we have chosen “Mixed Tren
(Windows Authentication & Windows Authentication).”

User name\Password:
These two fields will be needed when the Authentication is set to other than “Windows Authentication,” such as “SQL Peladen Installation.”

How to access SQL Server Management sanggar using Command line?

We can also use the Window Command Line tool to launch SQL Server Management Studio. We can do this by using the complete path to ssms.exe. The default location and file name are as follows:

The steps to access Management Bengkel seni through the command line are as follows:

  • Type CMD into the Search box to open Command Prompt.
  • Next, we need to type the complete path followed by ssms.exe and press Enter.

Immediately, we will see the ‘Connect to Server’ screen similar to the one we have described above.

SQL Server Management Studio

Introduction to Data Management Studio IDE

The Data Management Bengkel seni launch screen will look like below. We will discuss each section in detail.

SQL Server Management Studio

1. Query Editor

This section is used to write all of our queries. MS SQL Peladen offers interactive recommendations for tables, columns, and other items for easy queries creations and a variety of other features.

2. Object Explorer

The Object Explorer shows the database objects contained on the peladen in a tree dimensi. For quick reference, this section lists all of the Databases, Security, and Server Objects. We can see each object’s components by simply pressing the + icon to the left of the object to expand it.

3. Databases Selection Dropdown

It is a dropdown option that allows the user to choose the database to run our queries.

4. Execute button

It is an execution button that allows the user to execute the query and return the results.

5. Cancel Executing Query

It is a button that is used to stop the execution of the query.

6. Parse

It is a button used to validate the query’s syntax but doesn’t check the database objects.

7. Changing query result destination

This button group allows us to set the query result’s destination. There are three options available:

  • Results to Grid
  • Results to Text
  • Results to File

8. Comment/Uncomment out the Selected Lines

These buttons allow us to comment or uncomment the lines of code we have chosen. For example, to see the line numbers of the code in the query penyunting.

Important points to remember

The following points must be useful while using the SQL Peladen Management Studio:

  • SSMS is a standalone application that doesn’t refer to any particular SQL Server version.
    For example, we may use SMMS Version 18 with SQL Peladen 2022 and SQL Server 2022.
  • If we write the larger code, it reduces the readability. In that case, we need to make use of comments for better readability. We can comment out a line, just putting “–” in front of it.
  • A sudden shutdown or a device failure may result in data loss. We can minimize the data loss by setting the ‘AutoRecover‘ option checked. We can also configure the AutoRecover data time-period and the number of days this information is stored before being deleted. We can set the AutoRecover option as below:
    Tools> Options>Environment>AutoRecover

SQL Server Management Studio

SSMS Versions and Updates

The first version of SSMS was released with SQL Server 2005. With SQL Server 2008, SQL Server 2022, and SQL Peladen 2022, SSMS is an terintegrasi part of SQL Peladen. Microsoft began the first numerical versioning sequence in 2022, with the SSMS version number 16.3. Version numbers for all series include 16.x, 17.x, and 18.0.

The latest series, which is 18.0, have the following versions: 18.0 (Preview 4), 18.0 (Preview 5), and 18.0 (Preview 6). As of March 2022, the current version of SQL Server Management Sanggar is SSMS 18.8 RC.


Source: https://www.javatpoint.com/sql-server-management-studio