Posts by Reynaldo S

Enable CloudWatch Contributor Insights of DynamoDB tables in AWS Console

Introduction Amazon CloudWatch Contributor Insights is a powerful tool that helps you understand the most active and impactful contributors to your DynamoDB workloads. Whether you’re managing a small application or…

Read More

Backup a DynamoDB Table Using AWS Management Console

Introduction Amazon DynamoDB is a popular database service used by many businesses to store important data. Just like you would save your work to avoid losing it, backing up your…

Read More

Enabling Query Store Using SSMS and Transact-SQL statements

Query Store The Query Storeis a feature in SQL Server that helps you monitor query performance by capturing a history of queries, plans, and runtime statistics, etc.   Benefits of using the Query…

Read More

Installation of Database Migration Assessment for Oracle Extension

Migrating databases from Oracle to Azure SQL can unlock significant benefits, including cost savings, enhanced performance, and access to the full suite of Azure cloud capabilities. However, migration journeys can…

Read More

Create a login using SSMS for SQL Server

To use SQL Server, you need a login. You can log in using a regular Windows account or a special SQL Server account.   SQL Server Supports two Authentication Modes:…

Read More

Manual Failover of Oracle Data Guard

A failover is performed only when the primary database becomes unavailable, and there is no possibility of recovering the primary database.   Steps involve in failover Connect to Physical Standby…

Read More

Diagnosing and Repairing Failures with Data Recovery Advisor

Data Recovery Advisor feature helps in diagnosing and repairing data failures. It will automatically diagnose the issue and provides the recommendation for the repair that helps to resolve the data…

Read More