Category: PostgreSQL
-
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…
//
-
Azure Azure SQL Database Azure SQL Database High Availability L1 DBA Monitoring pg_ High Availability PostgreSQL SQL Server
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…
//
-
Tablespace in PostgreSQL
Tablespace In PostgreSQL, tablespaces enable administrators to specify places in the file system where files representing database objects can be kept. When generating database objects, a tablespace can be referred to by name once it has been created. By using tablespaces, an administrator can control the disk layout of a PostgreSQL installation. This is useful in at…
//
-
Enabled DAC to connect remotely
Hello there, everyone! I hope everything is going well for you. Today, I’ll show you how to use the DAC and how to enable it for remote connections. DAC- The dedicated admin connection (DAC) can assist you in getting out of a bind. This was created to assist you in connecting to SQL Server and…
//
-
Page Life Expectancy (PLE) in SQL Server
Hey guys, In this blog I am going to explain you about Page Life Expectancy and How to monitor it. Page Life Expectancy (PLE)- Page Life Expectancy (PLE) is an age of a data page in seconds in the buffer cache or buffer memory after querying the tables with the loading data page into the buffer memory.…
//
-
Detach and Attach in SQL Server
Hello there, everyone! I hope everything is going well for you. Today, I’ll show you about Detach and Attach Detach SQL Server Database- A SQL Server database is made up of at least two files: a data file (mdf) and a log file (ldf), though there may be additional data files in some circumstances. Since…
//
-
SQL Interview Questions
You can benefit from this article’s popular SQL Server DBA interview questions and answers. To learn more about SQL interview questions, I would advise you to read this post as well as the SQL Server Interview questions and answers. I made an effort to be very specific in my responses to each question in this…
//
-
PostgreSQL Index and Types
Hey guys, In this blog I am going to explain you about PostgreSQL Index and Types. PostgreSQL Index- The database search engine can use indexes, which are specialized lookup tables, to speed up data retrieval. An index is simply a pointer to information in a table. An index in a database resembles a book’s back…
//
-
PG Basic Commands
PG Basic Commands ============================================================================================================== Create a User postgres=# create user user_name with encrypted password ‘mypassword’; CREATE USER s2user WITH PASSWORD ‘***************’; CREATE USER s2user WITH PASSWORD ‘***************’ VALID UNTIL 2040-12-01;CREATE USER s2user SUPERUSER LOGIN PASSWORD ‘12345’;CREATE USER s2user SUPERUSER LOGIN PASSWORD ‘12345’; postgres=# grant all privileges on database sample_db to user_name; ============================================================================================================== Insert a huge Data…
//
-
PostgreSQL Architecture and Back-end Process
Hey guys, in this blog I am going to explain to you about PostgreSQL Architecture and Back-end Process. PostgreSQL- PostgreSQL is an open-source general-purpose object-relational database management system that is one of the most advanced. Because it is open-source software, its source code is available under the PostgreSQL license, which is a broad open-source license.…
//
-
Table Partitioning in PostgreSQL
Hello Guys, In this blog, I am going to explain you about table partitioning in PostgreSQL Table Partitioning in PostgreSQL Partitioning – Partitioning involves splitting large tables into smaller ones according to some attribute (like time ranges, regions, or even user ID groups) but can still be treated as one table from the application. This is a…
//