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 delete ADFS Windows Internal Database without access credentials

16/05/202015/09/2023

Christian No Comments

How to delete ADFS Windows Internal Database without access credentials

Windows Internal Database (codenamed WYukon, sometimes referred to as SQL Server Embedded Edition) is a varient of Microsoft SQL Server Express 2005, and is included with Windows Server 2008 and Windows Server 2008 R2. It is also included in Windows Sharepoint 3.0 and Windows Server Update Services (WSUS) 3.0, where a full version of Microsoft SQL Server may…

Oracle/MSSQL/MySQL

How to uninstall Oracle Database 11G or 12c

08/04/202001/10/2023

Christian No Comments

How to uninstall Oracle Database 11G or 12c

As you all are aware, the process of uninstalling Oracle Database 11G or 12c on Windows is totally different from the traditional step used in uninstalling a program in Windows. The following steps are vital in order not to encounter an error when reinstalling oracle unto the Server. The uninstallation process is similar to uninstalling…

Oracle/MSSQL/MySQL

WordPress site on Azure: How to create a website hosted in Azure

09/01/202022/09/2023

Christian No Comments

WordPress site on Azure: How to create a website hosted in Azure

WordPress is a free and open-source content management system written in PHP and paired with a MySQL or MariaDB database. In this guide, I will be using one of the WordPress applications and this article was performed in a sandbox on the Microsoft learning platform as shown here. Microsoft Azure Web Sites is a cloud computing-based…

Oracle/MSSQL/MySQL

Editions of MSSQL Server: What are the differences between various Editions of Microsoft SQL Server

04/11/201925/09/2023

Christian No Comments

Editions of MSSQL Server: What are the differences between various Editions of Microsoft SQL Server

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…

Oracle/MSSQL/MySQL

Fix MSSQL Connection timeout and timeout period expired

14/08/201917/06/2025

Christian No Comments

This guide will discuss the “Fix MSSQL Connection timeout and timeout period expired”. MSSQL is a suite of database software published by Microsoft. It includes a relational database engine, which stores data in tables, columns, and rows. Please, see How to configure screen saver timeout in Windows, how to Fix EFI network timeout on VMware Workstation,…

Oracle/MSSQL/MySQL

How to use a dedicated MsSQL Db for Pleasant Password

14/08/201921/03/2024

Christian No Comments

In this article, we will discuss How to use a dedicated MsSQL Db for Pleasant Password. Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications. Pleasant Password Server…

Oracle/MSSQL/MySQL

Unable to connect to MSSQL Server after changing Server name

08/05/201902/10/2024

Christian No Comments

Unable to connect to MSSQL Server after changing Server name

Microsoft SQL Server is a relational database management system developed by Microsoft. The primary function of storing and retrieving data as requested by other software applications. In this article, we shall discuss how to fix ‘Unable to connect to MSSQL Server after changing Server name”. See this article for the differences between various Editions of MsSQL…

Oracle/MSSQL/MySQL

What to do after increasing the Memory of Oracle Database

18/12/201815/02/2025

Christian No Comments

This article discusses What to do after increasing the Memory of Oracle Database. After altering (increasing) the ‘memory max target’ and ‘memory target’ of an Oracle database, you will have to run these statements as sysdba to restart the database. By not doing so, you will not have the necessary permission to perform some necessary…

Oracle/MSSQL/MySQL

How to reset MySQL Root password

10/03/201816/08/2023

Christian No Comments

The MySQL root password allows the root user to have full access to the MySQL database. You must have (Linux) root or (Windows) Administrator access to the Cloud Server to reset the MySQL root password. In this article, you will learn How to reset MySQL Root password. Please see How to delete a MySQL User…

Oracle/MSSQL/MySQL

How to access MySQL Server from command Prompt

15/11/201714/08/2023

Christian No Comments

How to access MySQL Server from command Prompt

How to access MySQL Server is a crucial skill for streamlined database management. This guide enables efficient navigation, interaction, and execution of SQL commands, ensuring smooth data operations via the command line. However, Explore the art of command prompt access to unveil the full potential of your MySQL Server with this guide on How to…

Oracle/MSSQL/MySQL

How to import a MySQL Database via the command line

10/01/201725/03/2024

Christian No Comments

How to import a MySQL Database via the command line

MySQL Database (Db) is a fully-managed 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. In this article, you will learn how to import a MySQL Database via the command line. Please see How to install…

Oracle/MSSQL/MySQL