SQL Server Management Studio (SSMS) and Azure Data Studio
are two front-end tools for the Database Engine that are introduced in this
chapter. The two SSMS components, Registered Servers and Object Explorer, as
well as the numerous SSMS user interface panes, are first covered in this
chapter. The SSMS operations connected to the Database Engine are then covered.
Also discussed in relation to authoring activities in SSMS are the Query Editor
and Solution Explorer.
To assist DBAs and users who don't utilise Windows as the
platform for the Database Engine, Azure Data Studio has been created. You can
manage the instances of your database system and access data from pre-existing
databases using Azure Data Studio. There are fewer components available in this
component than in SSMS. At the conclusion of the chapter, a comparison of the
features of the two front-end tools is provided.
SQL Server Management Studio
For diverse tasks such system installation, configuration,
auditing, and performance tweaking, the Database Engine offers a variety of
tools. (This book's next chapters will explore each of these technologies.) SQL
Server Management Studio is the administrator's main tool for working with the
system on Windows systems. Among other things, SSMS can be used by both
administrators and end users to manage numerous servers, create databases, and
replicate data.
The SQL Server Management Studio installation process is
simple. Visit www.microsoft.com, click the magnifying glass symbol in the
top-right corner, type "SSMS" into the search bar, then press
"Enter." The Download SQL Server Management Studio (SSMS) link will
appear in the search results. Verify that your computer is running a supported
version of Windows on the page that appears, and then click the Download SQL
Server Management Studio link to access the most recent SSMS version (18.1 at
the time of writing). Once it has downloaded, run the associated.exe file,
click Install, and then wait for the installation to finish.
Simply click the matching icon to launch SQL Server Management
Studio, or click Start and enter Management Studio into Windows Desktop Search.
The total system is written, administered, and managed using a variety of
components that make up SQL Server Management Studio.
The following are the main components used for these tasks:
• Registered Servers
• Object Explorer
• Query Editor
• Solution Explorer
• Data Discovery and Classification
The first two components in the list are discussed in this
section. The latter three components are explained later in this chapter in
“Authoring Activities Using SQL Server Management Studio.”
To get to the main SQL Server Management Studio interface,
you first must connect to a server, as described next.
Connecting to a Server
The Connect to Server dialogue box, which is displayed when
SQL Server Management Studio is launched and allows you to enter the connection
information for a server, is displayed:
•
Server Type:- For purposes of this chapter, choose Database
Engine.
·
Server Name:- The server name you want to
use can be selected or typed. (In general, SQL Server Management Studio can be
linked to any installed products on a given server.)
·
Authentication:- Starting with SQL Server
Management Studio 17.2, the Connect to Server dialog box supports an extra
three authentication methods that are used to connect to Azure SQL Database and
Data Warehouse instances. The supported authentication methods are listed here:
·
Windows Authentication: - You connect to
the Database Engine using your Windows account. This option is recommended by
Microsoft.
·
SQL Server Authentication: - The Database
Engine uses its own authentication.
·
Active Directory – Universal with MFA support:
-This is an interactive authentication method that supports Azure Multi-Factor
Authentication, which provides strong authentication with a range of easy
verification options you can choose from.
·
Active Directory – Password and Active
Directory – Integrated:- These are non[1]interactive authentication methods supported by
Azure Active Directory Authentication and can be used in many applications such
as the ODBC and JDBC.
