-
Ghost Records
When any record get deleted from DB, SQL Server does not delete the records physically from disk immediately. The deleted records which exists physically in…
//
-
Provisioning a First Azure SQL Database
In this section, we’ll learn: Provisioning Azure SQL database: Provisioning an Azure SQL database refer to creating a new and blank Azure SQL database. We’ll create new…
//
-
Moving A Table Data Into New Location Within Database
Problem I often getting low disk space alert from one of my data drive. Adding space on the disk was not possible because of hard…
//
-
Cloud Witness in Azure
Cloud Witness is a type of Fail-over Cluster quorum witness that uses Microsoft Azure to provide a vote on cluster quorum. There are significant benefits which…
//
-
Provisioning a SQL Managed Instance Using the Azure Portal
Azure SQL Managed Instance is intelligent, scalable cloud database service. SQL Managed Instance allows existing SQL Server customers to lift and shift their on-premises applications to…
//
-
Connect to SQL Managed Instance from an on-premises client computer by using a point-to-site connection
In this section, you will learn how to connect SQL managed instance from an on-premises client computer by using a “point-to-site” connection. Point-to-Site VPN connections are useful when…
//
-
DBCC (Database Console Command) Commands
It’s a common question of DBA interview. I already have faced millions of time. HaHa Ha. DBCC is a series of statements in Transact-SQL programming…
//
-
Export one table from one MySQL instance to other MySQL instance
Syntax Export one table: $ mysqldump -u root -p database_name table_name > dump.txt password ***** Import one table: $ mysqldump -u root -p database_name table_name…
//
-
InnoDB Architecture
Buffer Pool In MySQL, buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. The buffer pool permits…
//
-
PostgreSQL Backup
pg_basebackup is used to take base backups of a running PostgreSQL database cluster. We can take hot-backup and the backup can be used for… 1. point-in-time…
//
-
Streaming Replication Step by step notes
CREATE USER replicator WITH REPLICATION ENCRYPTED PASSWORD ‘******’; echo “host replication replicator 192.168.0.126/32 md5” >> pg_hba.conf \ /u01/app/postgres/bin/psql -c “select pg_reload_conf()” /u01/app/postgres/pgsql/bin/pg_basebackup -h 192.168.0.117 -U…
//