It is interesting to note that SQL Server 2025 (17.x) builds on previous releases to grow SQL Server. This enables you to use your choices of development languages, data types, on-premises or cloud environments, and operating system. In this article, we shall discuss “SQL Server 2025 upgrade Requirements and Compatibility”. Please, see How to upgrade…
Read More “SQL Server 2025 Upgrade Requirements and Compatibility” »
In this article, we will discuss the steps on how to upgrade Microsoft SQL Server 2019 to 2022. Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. This upgrade process is the same as when upgrading from Microsoft SQL server 2017 to 2019 and so on. Please see how does DELL…
Read More “How to upgrade Microsoft SQL Server 2019 to 2022” »
In this article, we will discuss how to fix the Microsoft SQL Evaluation period has expired: How to upgrade SQL Server instance. SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. Please see some related MSSQL guides I have written. What are the differences…
Read More “Microsoft SQL Evaluation period has expired: How to upgrade SQL Server instance” »
In this article, we shall learn how to resolve “Windows could not start the SQL Server service on local computer 17051: A network-related or instance-specific error occurred while establishing a connection to SQL Server”. The SQL Server is a relational database management system from Microsoft. The system is designed and built is to manage and store…
In this article, we will learn how to alter a DATABASE compatibility level. Please see some related MSSQL guides I have written. What are the differences between various Editions of Microsoft SQL Server. How to install MSSQL Server 2019 Developer Edition and SSMS on Windows. Database Compatibility Level is a valuable tool to assist in…
In this article, we shall discuss “How to Download and install MSSQL 2019 Express Edition and SSMS on Windows Server”. SQL Server 2019 Express is a free edition of SQL Server, ideal for the development and production of desktop, web, and small server applications. Please see How to use Microsoft SQL Server Management Studio to…
Read More “Download and install MSSQL 2019 Express Edition and SSMS” »
SQL Server 2019 Developer is a full-featured free edition, licensed for use as a development and test database in a non-production environment. If you would like to try out the 180-day free trial of SQL Server 2019 on-premises which helps build intelligent, mission-critical applications using a scalable, hybrid data platform for demanding workloads. Because I…
Read More “Install MSSQL 2019 Developer Edition and SSMS on Windows” »
SQL Server Management Studio is a software application first launched with Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Microsoft SQL Server. It’s the successor to the Enterprise Manager in SQL 2000. See this guide on how to download and install Microsoft SQL Server 2019 Express edition and…
Read More “How to uninstall Microsoft SQL Server Management Studio” »
In this guide, I will be discussing how to uninstall Microsoft SQL Server on Windows completely and prepare the system so that you can reinstall SQL Server. Please refer to the following article on how to uninstall Oracle Database 11G or 12c. See this guide on how to download and install Microsoft SQL Server 2019 Express…
Read More “How to uninstall Microsoft SQL Server on Windows” »
When installing a new instance of MSSQL Server in a mixed-mode authentication, you are required to set the password for the SA (System Administrator) account. The SA account is used only for the management of SQL Server. See this guide on how to download and install Microsoft SQL Server 2019 Express edition and Microsoft SQL Server…
Read More “How to reset MSSQL Server SA Password on Ubuntu” »
It is worth noting that Microsoft SQL Server 2019 takes full advantage of OpenShift and Linux Containers etc. SQL Server 2019 has the same underlying database engine on all supported platforms, including Linux. Therefore, many existing features and capabilities operate the same way on Linux. For those who are still wondering about this integration and…
Read More “Install Microsoft SQL Server 2019 and MSSQL Command line tools on Ubuntu Linux” »
In this article, we shall discuss How to fix unable to install msodbcsql17 tool on Ubuntu. When you are unable to install msodbcsql17 on Ubuntu, the root cause is because the msodbcsql17 package has a different version of MsSql-tools, both should have the same version. On how to install Microsoft SQL Server 2019 and MsSQL…
Read More “How to fix unable to install msodbcsql17 tool on Ubuntu” »
When asked to run projects that utilize MSSQL as the database engine with the least cost, then you should be able to select from the various Editions of MSSQL that serves your need. This decision is based on your environment and what the project (task entails). See the following explanations below for the right Edition…
