Install the latest version of SQL Server Management Studio 20.2

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:

 

 

What is SQLAlchemy?

 SQLAlchemy a toolkit for Python programming language. You can build full blown database applications with it and use the full range of the SQL Language. It is also a Object Relational Mapper(ORM).

SQLAlchemy is what you need (libraries and other tools) for building data-centric apps using Python and using other libraries the possibilities are limitless including AI and Machine Learning.

SQLAlchemy and connecting to data:

The connectors are elements that connect your application to data but in the case of SQLAlchemy they are called 'database dialects'. There are database dialects for each kind of database. These are the most common kinds:

SQLite: A lightweight, disk-based database that doesn’t require a separate server process.

https://hodentekmsss.blogspot.com/2016/09/sqlite-using-visual-studio-community.html

PostgreSQL: A powerful, open-source object-relational database system.

https://hodentekmsss.blogspot.com/search?q=postgresql

MySQL: A widely used open-source relational database management system.

https://hodentekmsss.blogspot.com/2024/11/install-latest-mysql-and-improve.html

Oracle: A proprietary database management system by Oracle Corporation.

https://hodentekmsss.blogspot.com/2013/11/a-collection-of-sql-server-related.html

Microsoft SQL Server: A relational database management system by Microsoft.

https://hodentekmsss.blogspot.com/2024/11/sql-server-2025-ready-to-go.html

MariaDB: A community-developed fork of MySQL.

https://hodentekhelp.blogspot.com/2015/11/how-do-you-access-mariadb-in-xampp.html

These connectors make it easy to connect SQLAlchemy to various database systems, ensuring compatibility and flexibility in developing data-centric applications.

If you are looking for working with databases, stay in and learn from over 15 years of blogging on databases here.

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

You may