Category: Oracle/MSSQL/MySQL

Oracle, MSSQL, and MySQL are powerful relational database management systems (RDBMS) widely used for managing, storing, and querying data in enterprise and web applications. Each offers unique features suited for different scales and environments

How to use Microsoft SQL Server Management Studio to Export and Import your MsSQL database from Azure to local computer

Posted on Temitope Odemo By Temitope Odemo No Comments on How to use Microsoft SQL Server Management Studio to Export and Import your MsSQL database from Azure to local computer
How to use Microsoft SQL Server Management Studio to Export and Import your MsSQL database from Azure to local computer

Microsoft SQL Server Management Studio (SSMS) is an integrated environment where you can manage your SQL infrastructure. SSMS can be used to access, configure, manage, administer, and develop all components of SQL Server and Azure SQL Database. Please see How to Quickly Fix Windows Search Bar Not Working, Windows Out Of Box Experience: OOBESETTINGSMULTIPLEPAGE error on…

Read More “How to use Microsoft SQL Server Management Studio to Export and Import your MsSQL database from Azure to local computer” »

AWS/Azure/OpenShift, Oracle/MSSQL/MySQL, Windows, Windows Server

How to install Microsoft SQL Server Management Studio

Posted on Christian By Christian No Comments on How to install Microsoft SQL Server Management Studio
How to install Microsoft SQL Server Management Studio

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. Furthermore, SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Please See how to reset MSSQL Server SA Password on Ubuntu via the command line and SQL Server Management…

Read More “How to install Microsoft SQL Server Management Studio” »

Oracle/MSSQL/MySQL

Fix “the server was not found or was not accessible: Verify that the instance name is correct and that SQL Server is configured to allow remote connections”

Posted on Christian By Christian No Comments on Fix “the server was not found or was not accessible: Verify that the instance name is correct and that SQL Server is configured to allow remote connections”
Fix “the server was not found or was not accessible: Verify that the instance name is correct and that SQL Server is configured to allow remote connections”

You may run into the following error “A network-related or instance-specific error occurred while establishing a connection to SQL Server. the server was not found or was not accessible: Verify that the instance name is correct and that SQL Server is configured to allow remote connections. Please see How to install Microsoft SQL Server Management…

Read More “Fix “the server was not found or was not accessible: Verify that the instance name is correct and that SQL Server is configured to allow remote connections”” »

Oracle/MSSQL/MySQL

How to manually check and update SQL Server Management Studio

Posted on Christian By Christian 6 Comments on How to manually check and update SQL Server Management Studio
How to manually check and update SQL Server Management Studio

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. Here are some guides on how to download and install Microsoft SQL Server 2019 Express Edition and Microsoft Management Studio…

Read More “How to manually check and update SQL Server Management Studio” »

Oracle/MSSQL/MySQL

How to alter a DATABASE compatibility level

Posted on Christian By Christian No Comments on How to alter a DATABASE compatibility level
How to alter a DATABASE compatibility level

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…

Read More “How to alter a DATABASE compatibility level” »

Oracle/MSSQL/MySQL

MySQL Workbench could not connect to MySQL server

Posted on Christian By Christian No Comments on MySQL Workbench could not connect to MySQL server
MySQL Workbench could not connect to MySQL server

MySQL Database (Db) is a database service that runs on a Local Server and on the Web. It is ideal for both small and large applications and it uses the standard SQL language. MySQL is free to download and use and has the most comprehensive set of advanced features, management tools, and technical support to…

Read More “MySQL Workbench could not connect to MySQL server” »

Oracle/MSSQL/MySQL

Download and install MSSQL 2019 Express Edition and SSMS

Posted on Christian By Christian No Comments on Download and install MSSQL 2019 Express Edition and SSMS
Download and install MSSQL 2019 Express Edition and SSMS

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” »

Oracle/MSSQL/MySQL

Install MSSQL 2019 Developer Edition and SSMS on Windows

Posted on Christian By Christian No Comments on Install MSSQL 2019 Developer Edition and SSMS on Windows
Install MSSQL 2019 Developer Edition and SSMS on Windows

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. You can…

Read More “Install MSSQL 2019 Developer Edition and SSMS on Windows” »

Oracle/MSSQL/MySQL

How to uninstall Microsoft SQL Server Management Studio

Posted on Christian By Christian No Comments on How to uninstall Microsoft SQL Server Management Studio
How to uninstall Microsoft SQL Server Management Studio

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” »

Oracle/MSSQL/MySQL

How to uninstall Microsoft SQL Server on Windows

Posted on Christian By Christian 2 Comments on How to uninstall Microsoft SQL Server on Windows
How to uninstall Microsoft SQL Server on Windows

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” »

Oracle/MSSQL/MySQL

How to reset MSSQL Server SA Password on Ubuntu

Posted on Christian By Christian 2 Comments on How to reset MSSQL Server SA Password on Ubuntu
How to reset MSSQL Server SA Password on Ubuntu

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” »

Oracle/MSSQL/MySQL

Install Microsoft SQL Server 2019 and MSSQL Command line tools on Ubuntu Linux

Posted on Christian By Christian 2 Comments on Install Microsoft SQL Server 2019 and MSSQL Command line tools on Ubuntu Linux
Install Microsoft SQL Server 2019 and MSSQL Command line tools on Ubuntu Linux

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. In this article, we shall discuss “Install Microsoft SQL Server 2019 and MSSQL Command line tools on Ubuntu Linux’. See the following…

Read More “Install Microsoft SQL Server 2019 and MSSQL Command line tools on Ubuntu Linux” »

Oracle/MSSQL/MySQL

How to fix unable to install msodbcsql17 tool on Ubuntu

Posted on Christian By Christian 2 Comments on How to fix unable to install msodbcsql17 tool on Ubuntu
How to fix unable to install msodbcsql17 tool on Ubuntu

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” »

Oracle/MSSQL/MySQL