agile dba,data privacy,data protection, management of information systems, relational, non-relational, structured, non-structured, semi-structured, on-premises, in the cloud

Full list of dba-ninja.com articles posted

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

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

01/05/2022 Discussing Converged database versus Specialized database engines

10/01/2021 How to do a MariaDB Restore

09/20/2021 Default Isolation Levels across database systems

09/08/2021 What is the Disk Capacity and Partition Amounts for GPT and MBR

09/02/2021 Top signs of an inexperienced DBA

08/25/2021 Chaos engineering and databases

08/24/2021 Building Secure and reliable systems

08/16/2021 How to MySQL restore files from a directory backup to their original location

07/22/2021 Explain the difference between one-way trust and two-way trust

07/19/2021 How to use Database Reliability Engineering to Increase Database availability

07/08/2021 How to automatically delete MongoDB documents after a certain time with TTL indexes

06/28/2021 How does a server select a Domain Controller

06/24/2021 How to review AWS Database Migration Service for successful DB migration

06/23/2021 How to get the Active Directory Site subnets

06/15/2021 How to use MongoDB queries to increase your DBA expertise

06/09/2021 How to fix Postgres error remaining connection slots are reserved for non-replication superuser connections

05/18/2021 How to display current user in MongoDB

05/17/2021 How to create an index on a MongoDB collection

05/12/2021 What is an immutable backup?

05/06/2021 How to rename a MongoDB database

04/26/2021 Learn about Containers

04/15/2021 How to move a MariaDB table to another database;

04/13/2021 What is the Apache Solr database

04/08/2021 Easy fix for ERROR 1449 (HY000): The user specified as a definer does not exist

04/06/2021 How to check an AD group is Unix-Enabled with Powershell

04/01/2021 How to use PostgreSQL pg_basebackup

03/24/2021 Describe Kerberos keytabs

03/16/2021 How to avoid displaying password with Mongo shell logon

03/12/2021 How to fix MariaDB Error 1045 - Access denied for user

03/07/2021 A Terraria Review: Is it Good? P.1

03/07/2021 Kingdoms Reborn- Is It Worth It? P.1

01/14/2021 How to identify if MongoDB Backup Snapshot Encryption is enabled

12/30/2020 The Amazing Babelfish for PostgreSQL by AWS

12/22/2020 How to execute a js file in MongoDB

12/02/2020 How to use MongoDB column alias in SQL Server SELECT

11/06/2020 How to restore a single MongoDB database from a Snapshot Backup

10/28/2020 How to stop and start MariaDB on Linux

09/22/2020 How to use mongodrdrl to extract a MongoDB collection schema

09/03/2020 How to fix Crontab -e - You are not allowed to use this program (crontab)

09/03/2020 How to easily install Podman on Red Hat Linux

09/01/2020 How to change PostgreSQL database data directory