Truncate and delete operation auditing in MSSQL Server

This blog discusses the steps to determine the user responsible for truncating and removing data from tables on MSSQL server, and identify the entity responsible.

Read More

Oracle EBS R12.2 ADOP Issues Fixes and Workarounds

In this blog I have discussed fixes/workaround issues faced by our customers on ADOP.

Read More

Oracle 21c New Features

Oracle 21c database powers the Oracle database services in on-premises and cloud infrastructure including Autonomous database (ADB), Oracle Exadata service@customer and Oracle Exadata machine.

Read More

Install Oracle Demantra 12.2 & Configure Web Server and Analytical Engine on Linux

Oracle Demantra is a demand management and supply chain management tool provided by Oracle.

Read More

EC2 Auto Scaling Lifecycle hook? Not so fast…

Amazon EC2 Auto Scaling lifecycle hooks are powerful mechanisms providing the ability for your architecture to respond to Auto Scaling events. A common use case for lifecycle hooks is sending notifications to an Amazon EventBridge which in turn can invoke serverless functions. For more information, checkout this AWS tutorial located here. Event-driven functions are extremely flexible, but they are not always the optimal choice depending on the use case.

Read More

Oracle 19c New Feature : Hybrid Partitioning

In Oracle 12c Release 2 version, Oracle introduced a feature which provided us ability to create partitions on External Tables. In the Oracle 19c version, Oracle introduced a new feature called Hybrid Partitioning which allows us to create some partitions external to database i.e. flat files and some partitions in the tablespace i.e internal to database.

Read More

IBM DB2 Database Administration

IBM DB2 is a Relational Database developed and owned by IBM. DB2 database is available for multiple platforms including Linux, UNIX, and Windows (LUW). DB2 is available as database software with multiple models or editions.

Read More

Apache Iceberg: An Introduction to the New Open Table Format

Data-driven decision making is accelerating and defining the way organizations work. With this transformation, there has been a rapid adoption of data lakes across the industry.

To fuel this transformation, data lakes have evolved over the last decade making Apache Hive as the de-facto standard for data lakes. However, while Apache Hive can solve some of the issues with processing of data, it falls short at a few other objectives for next generation data processing.

Read More

TOTAL RECALL (FLASHBACK DATA ARCHIVE)

Flashback data archive provides the ability to automatically track and archive transactional data changes to specified database objects.

Read More

Take a self-guided tour of Cloudflare’s Zero Trust platform

Rackspace offers Cloudflare’s Zero Trust platform which consolidates many once distinct technology solutions — Zero Trust Network Access, Secure Web Gateway, DNS Filtering, Cloud Access Security Broker (CASB), and more — into a single, natively integrated platform.

Read More