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...
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...
Accessing Sql Server 2019 when logins disappear after installation
Posted in SQL Server

Accessing Sql Server 2019 when logins disappear after installation

Problem On numerous occasions after completing a SQL Server installation (2016,to 2019) I’ve noticed that the SA user account and…

Continue Reading...
How to add a new named instance in SQL Server
Posted in SQL Server

How to add a new Named Instance in SQL Server

In this tutorial, we will be looking at how to add a new Named Instance in SQL Server. The version…

Continue Reading...
Resolving ORA-12705 Cannot Access NLS data files or invalid environment specified
Posted in Oracle

Resolving ORA-12705 Cannot Access NLS data files or invalid environment specified

ProblemĀ  While using SQL Developer you’ve encountered the error ORA-12705: Cannot Access NLS data files or invalid environment specified, but…

Continue Reading...
How to easily downgrade SQL Server from Enterprise to Developer/Standard Edition
Posted in SQL Server

How to easily downgrade SQL Server from Enterprise to Developer/Standard Edition

How to easily downgrade SQL Server from Enterprise to Developer/Standard Edition Problem This article shows how to easily downgrade SQL…

Continue Reading...
How to update oracle password with the same values
Posted in Oracle

How to update oracle password with the same values

Problem In this article, we will be looking at How to update oracle password with the same values. So as…

Continue Reading...