Tag: how to

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 In this PostgreSQL tutorial, we will be looking at the step-by-step guide on how to set…

In this short SQL Server DBA tutorial we will be looking at how to view the percentage (progress) of a…

In this short tutorial, we will be looking at changing the collation for various versions of SQL Server Databases after…

Problem From time to time as DBAs, we might lose access to our database instance, whether it be forgetting our…

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

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

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

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

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