Bijay 
In this PostgreSQL tutorial, we are diving into the realm of database management by demonstrating how to install PostgreSQL on a Windows operating system. Download and Install PostgreSQL on Windows To download and install PostgreSQL on Windows, follow the below steps. Step 1: Download PostgreSQL From the official PostgreSQL website, first download the Windows installer. … Read more >>
In this Oracle tutorial, we will learn how to add a column to a table in Oracle 19c and 21c. Moreover, we will also cover these topics. Oracle How To Add A Column To A Table While working on a database you received an email from the client to add a new column in the … Read more >>
In this SQL Server tutorial, we will learn how to resolve the “Error: 40 – could not open a connection to sql server” error. So, in this tutorial, we will discuss the root cause of this error and will also discuss how to solve this error. Error: 40 – could not open a connection to sql server … Read more >>
Last week, I worked on a stored procedure in SQL Server. I got an error while working on the query about adding the values in the table. The error came as “String or Binary Data would be Truncated in SQL Server”. String or Binary Data would be Truncated in SQL This is a common error … Read more >>
In this PostgreSQL tutorial, we will learn about “Postgresql generate_series” which helps in generating series of numbers, dates, months and row numbers, etc. Postgresql generate_series In Postgresql, we use the generate_series() function to generate series of numbers. Use the below command to generate series of numbers: Syntax: Postgresql generate_series function accepts three parameters: Note: The … Read more >>
In this PostgreSQL, we will discuss How to Create a Table In PostgreSQL [Terminal + pgAdmin], for terminal psql which is an interactive terminal for interacting with the PostgreSQL database. Also, use the pgAdmin for creating the table which is the central hub for database management tasks. How to Create a Table In PostgreSQL Let … Read more >>
You may have faced scenarios when you need to change the password of your Azure SQL database. In this article, we will explain various ways to achieve this. How To Reset Azure SQL Database Password Let us discuss all the approaches individually. Approach-1: Using Azure Portal To reset Azure SQL database password, follow the below … Read more >>
In this Azure SQL blog, I will share my incident when I got this error: “Cannot open server requested by the login. Client is not allowed to access the server“. Cannot open server requested by the login. Client is not allowed to access the server Recently, I was working with the Azure SQL database. I created … Read more >>
In this SQL Server tutorial, I will show you how to create a table in SQL Server Management Studio. As a database developer, you must know how to create a table to store the information in it. Tables are important objects in SQL. Server databases and their design are a base for both DBAs and … Read more >>
In this Oracle tutorial, we will learn how to check database size in Oracle. We are working on the latest version of Oracle, i.e. 21c, but the steps shared will also work on other versions. How To Check Database Size In Oracle Let us discuss all the approaches to check the database size of all … Read more >>
Download A 40 pages PDF And Learn Now.