PostgreSQL Permissions
Rudy The following scripts create some tables that store PostgreSQL permissions. The permissions come from the system tables pg_roles, pg_auth_members, and others. The scripts assume there is a database named DBA,…
Read Postgres Configuration File
Read and Display Postgres configuration information The following script reads the Postgresql configuration file and displays key settings. Results are sent to the console and an outfile. You can also…
Rename Files in PowerShell
Find and Replace parts of a File Name The following script will find and replace part of a file name with another string.
Read MongoDB Configuration File
Find and read the file using Python The following python script reads mongod.conf file and returns some settings.
Query Plans
Some Query Plan
Linux Configuration Script in Python
Verifying Linux Setting in Python The following Python script checks several Linux settings. Results of the check are written to the console. If the results are within the desired ranges…
Python – First of the Month Files
The following script uploads files from the first of the month via S3 With Notification Email The following version sends an email with the results There is no error handling…
Mid Year
Start of Year Reflecting on the first half of the year, it’s clear that I’ve navigated through some challenging waters. The year had an imperfect start, which pushed me far…
Database High Level Tasks
Database Design and Development: This entails designing databases based on organizational needs, developing and managing database structures, creating data models, and implementing new systems. Security Management: DBAs ensure the security…
Filter File Names in PowerShell
The following script filters out filenames in powershell. The filenames all have a known pattern of ServerName-DatabaseName-FilterName.sql