datablogs: Database Administration

Showing posts with label Database Administration. Show all posts

SQL Server Point in Time Recovery

Selva August 11, 2022 0 Comments

Oooooouch !!! I have deleted critical data in the ledger table !!! When we ran delete or drop Script on any database without double check ,...

Selva February 16, 2022 0 Comments

Microsoft gives HA features like a charm . Lower to higher deployment costs its giving many features as per business requirements . Replicat...

Selva February 02, 2022 2 Comments

Comparing Redis , AWS Elasticache giving multiple options to cache the data in cloud . Its enhanced with two ways of Access control opt...

Selva January 21, 2022 0 Comments

Its easy to refresh the schemas in Oracle RDS , We can do one time for Testing or Development Purpose But if its needs to run on daily basi...

Selva May 04, 2020 0 Comments

In this experimental scenario , gathering the table growth statistics using query exporter and loading the data into time series Prometheus...

Selva January 03, 2020 0 Comments

Error 'Table 'EMPLOYEES.POSITION' doesn't exist' on query. Default database: 'employees'. Query: 'ALTER TABL...

Selva December 23, 2019 0 Comments

Sounds interesting from Percona Backup tool for MongoDB !!! I just wants to try and explore the tool with docker on today !!! Docker is firs...

Selva November 26, 2019 0 Comments

Problem : We are running 5 node percona cluster on Ubuntu 16.04, and its configured with master-slave replication. Suddenly we got an alert...