Author: Jerad Jarrett
Upgrading SQL Server from 2016 to 2019 easy Step-By-Step Guide
In this tutorial, we will be looking at upgrading SQL Server from 2016 to 2019 in a few easy steps….
Upgrading & Patching Oracle RAC easy Step-By-Step Guide (2020)
In this practice,” Upgrading and Patching Oracle RAC” you will apply patch 20108098 to the Oracle RAC database homes on…
Resolving: Remaining connection slots are reserved for non-replication superuser connections in PostgreSQL
The error: remaining connection slots are reserved for non-replication superuser connections, can be resolved in many ways. In this post,…
How to resolve: ORA-01033 – ORACLE initialization or shutdown in progress
In this short tutorial we will be looking at how to resolve ORA-01033 ORACLE initialization or shutdown in progress. An…
PostgreSQL 12 Streaming replication on Ubuntu easy step-by-step guide
PostgreSQL 12 Streaming Replication In this PostgreSQL tutorial, we will be looking at the step-by-step guide on how to set…
Step-by-Step Guide: How to install SQL Server 2019 on RHEL 8
In this tutorial, we will be looking at how to install SQL server 2019 on RHEL 8. Before we can…
Step by step guide on how To Install PostgreSQL 12 on Ubuntu 16.04/18.04/20.04 (2020)
Introduction This tutorial will give you a step by step guide on how to install PostgreSQL 12 on Ubuntu 16.04/18.04/20.04….
How To: SQL Server job progress check
In this short SQL Server DBA tutorial we will be looking at how to view the percentage (progress) of a…
Changing SQL Server 201X Instance Collation after installation
In this short tutorial, we will be looking at changing the collation for various versions of SQL Server Databases after…
How to easily access SQL Server 2019 if locked out
Problem From time to time as DBAs, we might lose access to our database instance, whether it be forgetting our…