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