Automatically Enable LTR and PITR Policy upon a Database creation on Azure SQL Managed Instance

Introduction
For any database created via Azure Portal, SSMS, ADS or via some automated scripting as a part of company’s business requirements, it is frequently seen in large enterprises that there is a need to have a custom LTR (Long-Term Retention) a… Continue reading Automatically Enable LTR and PITR Policy upon a Database creation on Azure SQL Managed Instance→

How to generate pgBadger report from Azure Database for PostgreSQL Flexible Server

PgBadger is one of the most comprehensive Postgres troubleshooting tools available. It allows users to have insight into a wide variety of events happening in the database including:
 

(Vacuums tab) Autovacuum actions – how many ANALYZE and VACUU… Continue reading How to generate pgBadger report from Azure Database for PostgreSQL Flexible Server→