Tag: how to
1135
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…
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…
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…
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…
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…
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…
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…