• Automatic Table Partitioning (Date Range) in Oracle Database using Bash shell script.

    Linux Bash shell script to Automatically create new date range partitions for a table every month and delete older partitions.

    Author: aashutosh, Updated: Feb. 17, 2023, 8:42 p.m. Tags: #Linux #Database #Bash #Scripting #Automation #Oracle #SQL

  • SolarWinds & Jira & Integration for Infrastructure Monitoring using Python, SQL, REST API

    SolarWinds, a monitoring application, collects monitoring parameters from target objects, a Python Script reads new alerts from SolarWinds Database, and create and assign a Jira ticket

    Author: aashutosh, Updated: Feb. 17, 2023, 11:51 a.m. Tags: #Python #Database #Scripting #REST #API #Automation #SQL #Jira

  • Opensource Infrastructure Monitoring Tool with REST API for Servers, Databases

    Open source Data Center Infrastructure Monitoring tool for Linux & Windows Servers, Databases (Oracle, SQL Server, MySQL, PostgreSQL Sybase), Storage & Networks etc.

    Author: aashutosh, Updated: Feb. 15, 2023, 11:29 p.m. Tags: #Python #Django #Linux #Database #Bash #Scripting #REST #API #Automation #SQL

  • PostgreSQL Database : Index-Only Scans

    Index only scan, makes query execution faster, by accessing table row entry from index only, without accessing the actual table.

    Author: aashutosh, Updated: Feb. 15, 2023, 10:48 p.m. Tags: #Database #Postgres