Full list of dba-ninja.com articles posted

04/28/2025 How to diagnose a connection with Test-NetConnection

03/13/2025 How to enable mysql_clear_password plugin?

01/17/2025 Notes on Multi-Region Consistency Global DynamoDB

12/12/2024 AWS Control Plane vs Data Plane

11/14/2024 PostgreSQL and ssl commands

11/08/2024 Cannot perform operation: an index build is currently running for collection

10/11/2024 RDS failover and DNS Caching

08/19/2024 How do I copy a file to a folder in cmd?

08/15/2024 How to delete a Global DynamoDB table

07/16/2024 Failed to unlink socket file: Operation not permitted

06/26/2024 Using S3 as a DMS Target

06/12/2024 Should I back up all DynamoDB tables across all Regions

06/11/2024 IAM Deny permissions for restores on RDS - DocumentDB - DynamoDB

06/03/2024 Using psycopg2 for PostgreSQL connections via Python on Lambda functions

05/01/2024 Task timed out after 3.02 seconds aws lambda

04/10/2024 The difference between Continuous backup and PITR in DynamoDB

04/03/2024 How to delete an Aurora Cluster

03/22/2024 How to create a CNAME record for a Route 53 Domain

03/12/2024 Switch role access with aws-cli

02/27/2024 DynamoDB on-demand backup expiry date

02/20/2024 Recover deleted DynamoDB table with Point-In-Time Recovery Enabled

02/06/2024 Convert Single-AZ AWS RDS to Multi-AZ

12/11/2023 How do I search logs in CloudTrail for a KMS key?

11/20/2023 How to view resource tags in AWS Backup using list-tags

10/31/2023 How to create a DynamoDB Global table from an existing table

10/17/2023 RDS modify Multi AZ to true

10/03/2023 MongoDB Groom expanding space

09/20/2023 GIT cheat sheet

09/14/2023 DeleteDBInstance - Cannot delete RDS Instance

09/04/2023 Get secret value from AWS Secrets Manager

08/30/2023 copy-source-tags-to-restored-resource for AWS DynamoDB

08/16/2023 Independent AWS Backup Encryption

08/07/2023 How to use Inline LOB for DMS to improve speed of an AWS DMS task

07/27/2023 Manage Cross Region RDS Read Replicas with AWS CLI

07/26/2023 How can I speed up my DMS migration ?

07/13/2023 Postgresql unique objects naming convention and converting from SQL Server

07/06/2023 Error 42P07 - Are index names unique in Postgres?

07/04/2023 How do I backup my DynamoDB table to another region with AWS Backup?

06/28/2023 Creating backup copies across AWS Regions

06/20/2023 RDS modify-db-instance : An error occurred (InvalidParameterValue) when calling the ModifyDBInstance operation

06/16/2023 Deep dive into Amazon RDS Proxy for scaling applications

06/02/2023 AWS DMS Context Logging

06/01/2023 Terraform explained

05/25/2023 Using security socket layer (SSL) on DMS Endpoints

05/15/2023 Migrating SQL Server User Defined Data types with DMS table error

05/12/2023 AWS DMS Premigration Assessment and unsupported data types

05/05/2023 How do I recover a deleted RDS database when the KMS key is deleted

04/24/2023 Troubleshoot SQL Server varbinary(max) to PostgreSQL bytea using AWS DMS

03/29/2023 How to auto generate id in postgresql on an existing column

03/15/2023 An error occurred (InvalidSubnet) when calling the RestoreDBInstanceFromDBSnapshot operation: No default subnet detected in VPC

03/09/2023 Is Terraform declarative or imperative and is it suitable for DB restore procedures ?

03/06/2023 How to drop all tables in a schema in PostgreSQL?

03/01/2023 What is option group and parameter group in RDS ?

02/02/2023 AWS Shared Account Model

02/02/2023 AWS SCT Global settings - Cannot add Windows Authentication Library

01/30/2023 Does DMS migrate PostgreSQL geospatial data types ?

01/24/2023 The default write concern may change when upgrading to 5.0

01/13/2023 RDS Client: DB Instance quota exceeded

12/28/2022 AWS Backup continuous backup - RDS, DynamoDB , Aurora

12/15/2022 Amazon DynamoDB Backup & Restore

12/14/2022 Amazon RDS DB Instance storage

12/05/2022 AWS DMS Schema Conversion announcement

11/30/2022 Top learnings from AWS re:Invent 2022

11/16/2022 AWS CLI -- output table format broken on Windows

11/14/2022 How do I create a security group in AWS command line?

11/07/2022 How do I restore my AWS RDS? aws backup start-restore-job example

10/11/2022 What is Serverless Architecture ?

10/10/2022 PostgreSQL doesn't support clustered indexes

09/27/2022 A simple guide to AWS SCT multiserver assessment

09/15/2022 AWS CLI Cheatsheet - RDS, AWS Backup , DMS, IAM, Security Token Service,KMS,EC2, DynamoDB,VPC,Aurora, Aurora Global,RESOURCEGROUPSTAGGINGAPI,DocumentDB,CloudTrail

09/01/2022 Migrate SQL Server to Aurora PostgreSQL using AWS DMS best practices

08/30/2022 How does format-preserving encryption work?

08/18/2022 How do I disconnect multiple connections on a server ?

08/03/2022 Babelfish Compass Tool - How to use

07/25/2022 AWS DMS rollback

07/22/2022 What is DynamoDB and how it works?

07/14/2022 Postgresql IAM authentication

07/13/2022 dblink in postgresql

07/12/2022 How do I enable SSL in PostgreSQL

07/08/2022 AWS Backup Service

07/07/2022 AWS PostgreSQL encryption

06/29/2022 How to find the MariaDB data directory

06/28/2022 Dive deep into database migration services AWS DMS and AWS SCT

06/27/2022 A simple guide to MySQL backup history

06/23/2022 Privacy Policy

06/17/2022 How to enable data validation for AWS DMS database migration task

06/16/2022 How to fix permission denied for schema in PostgreSQL

06/15/2022 Amazon RDS for PostgreSQL versus Amazon Aurora PostgreSQL - which should I choose ?

06/14/2022 How to create a PostgreSQL user for CRUD

06/10/2022 How to encrypt a column using PostgreSQL pgcrypto

05/27/2022 How to view a PostgreSQL connection SSL status

05/23/2022 Difference between PostgreSQL Unicode v ANSI drivers

05/17/2022 How to change PostgreSQL default schema

05/13/2022 How to list PostgreSQL table constraints

05/10/2022 How to fix python import requests not found

04/28/2022 How to kill a PostgreSQL user session connection

04/27/2022 How to copy a PostgreSQL table to another database using pgAdmin

04/20/2022 My favourite sci-fi novels

04/14/2022 Is mongodb+srv necessary for a MongoDB connection

04/11/2022 MSSQL to PostgreSQL Migration - upper versus lower case

04/07/2022 A simple guide to migrate MS Access to PostgreSQL

03/24/2022 Deep dive on Amazon Aurora

03/18/2022 Babelfish for Aurora PostgreSQL query cheatsheet

03/16/2022 Single-Mode Vs Multiple-Mode in Babelfish for Aurora PotgreSQL - which one should you use

03/04/2022 The best Wordle first word

02/21/2022 How to edit AWS Schema Conversion Tools drivers information via settings.xml

02/04/2022 Spotlight on Babelfish for Aurora PostgreSQL

01/26/2022 The truth about SQL Server to PostgreSQL migration

01/23/2022 How to print os environment variables with Python

01/15/2022 How to hide user input for password in Python

08/03/2019 Bad Blood - Secrets and Lies in a Silicon Valley Startup - Review

07/22/2019 Confluent Kafka and MongoDB connector

07/15/2019 MongoDB - WARNING: shell and server versions do not match

07/03/2019 How to get the Java Toolbox jt400 version through Command Line

05/29/2019 How to create a log trace and send to file in Kafka

05/02/2019 How to Rock Apache Kafka with a cheat-sheet

04/04/2019 Mission sub 3 marathon

03/07/2019 Running Highly available Postgres databases in Containers - Cattle and Pets

01/21/2019 Quick Access To Mongodb Commands Cheat Sheet

01/08/2019 How to use an external smtp server with Linux mail \ mailx

12/27/2018 How to list extensions in PostgreSQL

12/24/2018 Frequently Asked Questions - dba-ninja.com

12/24/2018 How To Contact

10/06/2018 PostgreSQL cheatsheet

05/01/2018 Open Source database links