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.
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.
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.
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.
This blog covers steps on how to implement Multi Factor Authentication (MFA) for E-business suite, and Security Assertion Markup Language (SAML).
This Blog will show you, how to setup a Autonomous Database Monitoring in Oracle Management Cloud.
This blog demonstrates the detailed steps needed during the DR testing with reverse Log shipping method.
The transportable tablespace feature enables the user to move a set of applications from one Oracle database to another desired Oracle database.
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.
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.