Category: PostgreSQL
-
Methods to change windows authentication to mixed mode (windows and SQL server authentication)
Hey guys, In this blog I am going to explain you about different methods to Enable Mixed Mode authentication Ø Enable Mixed mode authentication using Management studio Ø Enable Mixed mode authentication using Registry editor 1. Enable Mixed mode Authentication using MANAGEMENT STUDIO- STEP-1: Open a server in Management studio. Go to server -> right click -> instance ->properties…
-
Point-in-time recovery in SQL Server
Hey guys, In this blog we will discussed about point-in-time recovery in SQL Server and how to perform it and also we discussed on full, differential and transaction log backup. 1. Full backup – A Full backup is a complete backup of a database. The full backup contains all the data in a database and…
-
View in SQL Server
Hello guys, In this blog, I am going to explain you about a view and how to create a view inside the database. View– A VIEW in SQL Server is like a virtual table that contains data from one or multiple tables. It does not hold any data and does not exist physically in the…
-
Pages and Extent in SQL Server
Hey guys, In this blog I am going to explain you about Pages and Extent in SQL Server and also different types of pages in SQL Server Pages – A page is a unit of data storage in SQL. The size of a page is 8Kb. The data rows are put on the page serially after…
-
ACID Properties of RDBMS
Hii guys, I hope you are doing great, Today here I am going to explain you about the ACID properties of RDBMS and its types. Transaction- Any operation that reads from or writes to a database is referred to as a transaction in relational databases. A transaction is a logical unit of work that can…
-
SQL Server Network Configuration
Hey guys, hope you are doing great. In this blog I am going to explain you about SQL Server Network Configuration and enabling/disabling different protocols. SQL Server Network Configuration – SQL Server Network Configuration involves enabling the protocols that manage the connection to the SQL Server and configuring the available options for these network protocols. It…
-
Database Maintenance Plan
Hii guys, I hope you are doing great, today here I am going to explain you about the Database Maintenance Plan. Database Maintenance Plan- A database maintenance plan is a set of specific, proactive tasks that need to be performed regularly on databases to ensure their adequate performance and availability. Uses of Maintenance plan– The…
-
New features of SQL Server 2022
Hello guys, hope you are doing well. In this blog I’m going to discuss about the “New features of SQL Server 2022” The release of the SQL Server 2022 is much anticipated by the audience since the announcement of it being in the works on November 2nd, 2021. Although the complete details of this brand-new version will…
-
PostgreSQL Basic Commands
Basic Command Description psql -d database -U user -W Connects to a database under a specific user psql -h host -d database -U user -W Connect to a database that resides on another host psql -U user -h host “dbname=db sslmode=require” Use SSL mode for the connection \c dbname Switch connection to a new database…