How to Install SQL Server 2019 Express and the Latest Version of SQL Server Management Studio (SSMS

Описание

Enroll to the Full course on Udemy with discount: https://www.sqlnethub.com/go/course-sql-server-fundamentals/

In this video, we will talk about SQL Server Express Edition, its characteristics and limitations, and how you can download it and install it on a new Windows environment, along with installing the latest version of SQL Server Management Studio (SSMS).

SQL Server Express Edition, is a special, free edition of SQL Server, which is ideal for development and production for desktop, web, and small server applications. However, even free, this edition of SQL Server, has certain limitations.

Some of the main limitations are:
- 1GB maximum RAM used by the SQL Server Database Engine
- Maximum size per relational database is 10 GB
- SQL Agent is not included
- Maximum buffer pool memory per instance, is limited to 1410 MB
- Maximum memory for Columnstore segment cache per instance of SQL - Server Database Engine is 352 MB
- Maximum memory-optimized data size per database in SQL Server Database Engine is 352 MB

Now, about the minimum requirements for installing SQL Server 2019 Express Edition, the main requirements are:
- Minimum 6 GB of available hard-disk space
- Minimum 512 MB RAM
- Minimum x64 Processor: 1.4 GHz
- OS:
-- Windows 10 TH1 1507 or greater
-- Windows Server 2016 or greater

For downloading SQL Server 2019 Express Edition, you can visit the SQL Server's official download web page at: https://www.microsoft.com/en-cy/sql-server/sql-server-downloads


About the minimum requirements for installing the latest version of SQL Server Management Studio (SSMS), these are:
- 1.8 GHz or faster x86 processor
- Minimum 2 GB of RAM
- Minimum of 2 GB up to 10 GB of available space
- OS
-- Windows 8.1 (64-bit) or Windows 10 (64-bit) version 1607 (10.0.14393) or later
-- Windows Server 2008 R2 (64-bit) or a later Windows Server version (64-bit)

For downloading the latest version of SSMS, as well as, for checking the full list of requirements, you can visit the tool's official website: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

You can learn more more about SQL Server via our online courses. Check the list of our online courses on our website at: https://www.sqlnethub.com/online-courses/

© SQLNetHub
All rights reserved.