Friday, February 7, 2025

DBSAT Security Series – Part 2: Identifying Sensitive Data Using DBSAT Discover

Introduction

DBSAT Discover is a standalone, Java-based component of the Database Security Assessment Tool that identifies sensitive data within your database. Unlike the Collector and Reporter, Discover works independently and focuses on scanning tables and columns for patterns that match PII, financial, or other confidential information. Building on the foundation covered in Part 1 of this series, EnhancingQuery Performance: Leveraging In-Memory Optimized Dates in Oracle 23ai, where we explored configuring and using the main DBSAT tool, Discover, helps you take the next step by revealing exactly where sensitive data resides, so you can strengthen your overall security posture.

Thursday, February 6, 2025

DBSAT Security Series – Part 1: Configuration and Reporting with DBSAT


Oracle Database Security Assessment Tool (DBSAT) is a popular command-line tool that helps identify areas where your database configuration, operation, or implementation introduces risks and recommends changes and controls to mitigate those risks. This tool is essential for database administrators and security professionals who want to ensure their Oracle environments are protected against both internal and external threats.

Saturday, January 4, 2025

Configure Nagios to monitor Oracle database on a remote Linux Host Using CHECK_ORACLE_HEALTH

Monitoring Oracle Database with Nagios involves using plugins and configurations that allow Nagios to check the status and performance of the Oracle Database.

Saturday, August 3, 2024

Set up DELTA (DB Endpoint Latency Testing Ammeter) to test the latency from a Windows system using venv to an oracle database

 What is the DELTA?

DELTA (DB Endpoint Latency Testing Ammeter) is a tool or framework designed to measure the latency of database endpoints. It is used to assess the performance of database connections, helping developers and database administrators understand the time it takes for a database query to travel from the client to the database server and back.

Tuesday, July 16, 2024

Automating Archive Log Cleanup in DBCS Standby Databases: A Step-by-Step Guide


In Oracle Cloud Infrastructure (OCI) Database Cloud Service (DBCS), the ability to use crontab or similar utilities to schedule jobs for the oracle user is restricted by default due to security and operational best practices. Here's why this restriction exists and alternative approaches you can use:

Friday, June 7, 2024

Encrypt an existing MS SQL Server 2019 database in Always on environment using TDE.


Transparent Data Encryption (TDE

Transparent Data Encryption (TDE) in SQL Server protects data at rest by encrypting database data and log files on disk. It works transparently with existing applications, so they don’t need to be changed when TDE is enabled. TDE uses real-time encryption at the page levelIn SQL Server 2019, TDE is available as a Standard Edition feature, eliminating the need to upgrade to Enterprise Edition just for TDE.

Lock-Free Reservations in Oracle 26ai: Comparing Traditional Locking and High-Concurrency Transactions

  Introduction Handling concurrent updates has always been a challenge in high-volume transactional systems. Consider a banking application ...