SQL Server Management Studio: A latest version for SQL Server 2022

The most preferred tool to manage SQL Server 2022. A well integrated tool that has grown over the years for probing, developing and montoring SQL Server. 

This is the latest version of SQL Server Management Studio [build no:20.2.30.0, released July 9,2024]. Note: it is not an upgrade to SQL Server 19.x

• SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. 
• SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. 
• Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications and build queries and scripts.

You may download the executable from this link:

https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16

You will find the following (SSMS-ENU) in your download:

You can doble-click the application to start installing. It takes a very short time to install as shown in these screenshots:

Click Install and installation begins.

These are some new features of the SQL Server Management Studio (from the Microsoft documentation).

Connecting to an existing SQL Server 2022:

Kindly follow the links for installing the SQL Server 2022:

https://hodentekmsss.blogspot.com/2024/09/installing-sql-server-2022-on-laptop.html

https://hodentekmsss.blogspot.com/2024/09/customized-installing-sql-server-2022.html

If your SSMS 20.2 installation is successful you should be seeing in the Windows Control Panel  several additional components to ensure a smooth and comprehensive experience in using SQL Server Management Studio:

• Microsoft Visual Studio Tools for Applications 2019: This is necessary for certain features within SSMS that rely on Visual Studio's development environment.
• SSMS 20.2: The main application for managing SQL Server instances.
• Microsoft Help Viewer: Provides access to documentation and help files within SSMS.
• Microsoft OneDrive: This might have been included to facilitate cloud storage and synchronization of your files.

The SSMS20.2 installation also adds the launch program for the SSMS that you can find in the Search as shown here:

C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server Tools.

This folder has the following files: 

Shortcut to the SSMS 20.2 launch

Shortcut to Analysis Services Deployment Wizard 20

Performance tools folder

You can doble click to launch from this location or on the Search results:

The SSMS 20.2 above when clicked launches the application and the SSMS user interface is displayed as shown:

Although the program connects to the installed version of SQL Server it is looking for a trusted connection by way of a certificate. There is a check box below Encryption (that has three options) shown above.

If you do not check this box and try to connect you get the following exception:

If you do place a checm mark saying you trust and then connect you get the following display:

This connection is now OK and the SSMS is OPEN FOR BUSINESS!!!

If you are looking for working with databases, stay in and learn from over 15 years of blogging on databases here.  http://hodentekMSSS.blogspot.com

You may also have a look at my database related books:

 

 

Installing the latest version of SQL Server

 Download the latest version of SQL Server from here.

There are a couple of download options as you can see on this page from the above link.

If you are a developer, the best option is the Developer version which provides:

• Full featured free edition
• Licensed for use as a development and test database
• It is for non-production use

However, most purposes the SQL Server 2022 Express is adequate. It provides:

• Free edition of SQL Server
• Good fit for desktop development
• Best fit for small server applications.

The SQL Server editions may be installed on Windows, Linux and Docker Containers.

In this blog for purposes of demonstration and use, the Developer edition will be installed on a Surface Laptop 5 with the following features.

Windows 11 Pro, Version 23H2, OS build 22631.3593. It has 16GB installed RAM

Downloading the developer edition begins by clicking the Download button in the above screen. In response you download the executable, SQL2022-SSEI-Dev.exe (4191 KB)file. This file gets displayed as shown.

If you want a quick installation use the BASIC option. 

In blog the Custom option will be used. If you want to differ to another time, you may just download the installation files by choosing Download Media.

Read the details of the SQL Server 2022 Installation Center

Do you need SQLOISIM for SQL Server?

 SQLIOSIM is a tool for simulating SQL Server IO. SQLIOSIM performs reliability and integrity tests on the disk systems that SQL Server utilizes for data and log files. 

It simulates,

Read

Write

Checkpoint

Backup

Sort and 

Read-ahead activities of MS SQL Server.

Main objective of SQLIOSIM is to test the reliability of the underlying I/O subsystem even before installing SQL Server. This proactive tool helps preparing well for the installation. SQL Server installation is not needed for using it as it does not interact with the SQL Server. If an installation exists, using it may overwrite the files. It is not a tool for data security. It is an upgrade over the previous SQ7IOStress utility.

It is located in the Program Files/Microsoft SQL Server/MSSql16.<Named Instance>MSSQL/BINN folder of your installation.

In the installation described here, there are two SQLIOSIM related files in the BINN folder.

SQLIOSIM Application (SqLIOSIM.exe)----GUI

SQLIOSIM DOS file (SQLIOSIM.com)--DOS 

For using SQLIOSIM.com you need to configure the SQLIOSIM configuration file.

What if you cannot locate the file?

If the file is not found as in this installation, it can be found in GitHub. However, if it is not found on the GitHub and one may need to go to Microsoft or raise the issue. As we see later, there may be a way out using the GUI.

https://github.com/microsoft/mssql-support/blame/master/sqliosim/Readme.md

The SQLIOSIM gui can be launched using the SQLIOSIM.exe application in the BINN folder.

Double click the SQLIOSIM application in the BINN folder to launch the GUI.

Click SIMULATOR to open the Simulator. Simulator->Configure will open the Files and Configuration GUI as shown.

From here on it can be used to configure the .mdx and .ldx file locations, size  and max size and Increment parameters on the computer and test patterns for integrity testing can be carried out. Do not choose the existing .mdx and .ldx file locations as they will be overwritten during testing.