Introduction to Change Data Capture (CDC)

What is Change Data Capture (CDC)?

Change data capture (CDC) uses SQL Server agent to capture DML activities like deleting, updating, and inserting on a table.

Read More

Shrinking of SQL Databases using Notruncate Command

This blog discusses the process of shrinking the data file of a SQL server database by using the option DBCC shrink file using the Notruncate option.

Read More

Backup Compression for TDE enabled DBs

The SQL Server 2008 and later versions provide many powerful features, and among those, Backup Compression and Transparent Data Encryption (TDE) are very useful to compress your backups and Enable the encryption at database level. However, if we use both these options on the same database then we have the limitation of leveraging both these features up to SQL 2016 version.

Read More

Database Auditing

Database auditing monitors the activities occurring in a database. Oracle has functions that allow us to audit actions in the database and against the database.

Read More

Implementation of DUO and SAML in E-business suite 12.2

This blog covers steps on how to implement Multi Factor Authentication (MFA) for E-business suite, and Security Assertion Markup Language (SAML).

Read More

Setup Autonomous DB Monitoring in OMC

This Blog will show you, how to setup a Autonomous Database Monitoring in Oracle Management Cloud.

Read More

DR Drill with Log shipping

This blog demonstrates the detailed steps needed during the DR testing with reverse Log shipping method.

Read More

Migrate database using cross-platform incremental backups with transportable tablespace

The transportable tablespace feature enables the user to move a set of applications from one Oracle database to another desired Oracle database.

Read More

Different types of OCI servers in the cloud

This post introduces types of servers available in the Oracle Cloud Infrastructure (OCI) cloud for different types of workloads. In a whitepaper, Oracle shares that OCI compute lets you provision and manage compute hosts, known as instances. After you launch an instance, you can access it securely from anywhere, restart or attach volumes and terminate when not needed. After it’s terminated, you loose the local drives and retain only the changes attached to volume.

Read More

Introduction to Redis Sentinel

Originally published on Apr 28, 2015, at ObjectRocket.com/blog

Redis™ Sentinel provides a simple and automatic high availability (HA) solution for Redis. If you’re familiar with how MongoDB® elections work, this isn’t too far off. To start, you have a given primary replicating to a certain number of replicas. From there, you have Sentinel daemons running, either on your application servers or the servers on which Redis is running. These keep track of the primary’s health.

Read More