Replication can be defined as the process via which Data and database objects are copied and distributed between databases, and then synchronized to ensure consistency. Transactional replication is typically used in scenarios requiring high server throughput, Reporting and data warehouses; improving scalability and availability; integrating data from disparate sources. Batch processing can be offloaded, heterogeneous data can be integrated, and multiple sites can be integrated.
The hope of this blog post is to help Oracle DBAs perform routine maintenance on RAC clusters with little impact on the running applications actively performing work.
Security has always been a pressing concern even for the most seasoned DBA. Regardless of versions and editions, SQL databases are under constant threat as they hold sensitive data, and that is what the malicious hackers want to access.
This blog describes how to set up the security in PostgreSQL and AWS Aurora and related best practices. The Database security refers to a set of procedures and policies that safeguard data. It becomes crucial to understand its significance.
MFA is where users are prompted /required to authenticate with additional verification using additional form of identity verification.
MFA is a way to secure your apps and data by requiring users to use another form of verification. Also, MFA gives additional security by introducing an additional form for verification and provide strong authentication by a range of simple-to-use validation methods.
This is in continuation of earlier blog on AWS DMS where we shall Configure Ongoing Replication from RDS to Redshift. Later we shall see some wonderful DMS features.
In this fast moving Tech world, everyone wants to use best technology with max performance and minimum cost. AWS Cloud was introduced with the same notion. In 2016, AWS introduced its tool DMS (Database Migration Service) to help customers migrate their Databases to AWS.
This blog discusses the various steps that can be taken to migrate data from an mdf file to an ndf file within the same file group.
I have been working on Oracle Cloud technologies since 2018 and based on my experience, the goal of the cloud vendor is to educate customers about the potential benefits of the cloud and their IT teams of its implementation and migrations.
In my earlier blog, I had discussed how to Initialize replication for a large database using the database backup. I will now be discussing how to add new articles and reinitialize the existing SQL Server transactional replication configured through backup.