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...
Understanding the pg_hba conf file in PostgreSQL
Posted in PostgreSQL

Understanding the pg_hba conf file in PostgreSQL

Understanding the pg_hba conf file in PostgreSQL The pg_hba.conf file which stands for PostgreSQL Host-based Authentication configuration file, controls client/ipĀ …

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...
PostgreSQL backup tutorial & database backup types explained
Posted in PostgreSQL

PostgreSQL backup tutorial & database backup types explained

PostgreSQL backup tutorial & database backup types explained As in any production environment, backing up said environment is equally an…

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...
3 easy ways to create users in Postgresql database
Posted in PostgreSQL

3 easy ways to create users in Postgresql

Like many other databases, create a user in PostgreSQL is pretty easy. In this short tutorial, we will be looking…

Continue Reading...
5 free tips on how to keep SQL Server Database performing
Posted in SQL Server

5 free tips on how to keep SQL Server Database performing

Hi Guys, in this post, we will be discussing my top 5 tips on how to keep your SQL Database…

Continue Reading...
20 PostgreSQL basic administrative commands you need to know
Posted in PostgreSQL

20 PostgreSQL basic administrative commands you need to know

In this tutorial we will be looking at a list of 20 PostgreSQL basic administrative commands you need to know,…

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 make SQL Server Backups move faster
Posted in SQL Server

Quick and Easy way to make SQL Server Backups move faster

Introduction In this article we will be looking at a Quick and Easy way to make SQL Server Backups move…

Continue Reading...