Upgrading SQL Server from 2016 to 2019
Posted in SQL Server

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

Continue Reading...
Upgrading and Patching Oracle RAC Step-By-Step Guide
Posted in Oracle

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…

Continue Reading...
Resolving Remaining connection slots are reserved for non-replication superuser connections in PostgreSQL
Posted in PostgreSQL

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,…

Continue Reading...
How to resolve: ORA-01033 - ORACLE initialization or shutdown in progress
Posted in Oracle

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…

Continue Reading...
PostgreSQL 12 Streaming replication on Ubuntu easy step-by-step guide
Posted in PostgreSQL

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…

Continue Reading...
SqlServerOnLatest rhel8 featuredimage
Posted in SQL Server

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…

Continue Reading...
install postgresql on ubuntu
Posted in PostgreSQL

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

Continue Reading...
How To: SQL Server job progress check
Posted in SQL Server

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…

Continue Reading...
Code to change SQL Server instance collation
Posted in SQL Server

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…

Continue Reading...
How to add path to environment variable in windows
Posted in SQL Server

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…

Continue Reading...