Database Administration

Introduction: — In Oracle databases, data files can become fragmented and contain unused space over time due to data manipulation operations such as inserts, updates, and deletes. This unused space can consume valuable storage resources. …

When it comes to handling complex queries, one concept stands above the rest: composite indexing. By combining multiple columns into a single index, composite indexing unlocks the potential for faster data retrieval and optimized query execution. In this article, we delve into the power of composite indexes and explore why…

Migration of a Workload running in a Corporate Data Center to AWS using the Amazon EC2 and RDS service In project based in a real-world scenario, I acted as the Cloud Specialist responsible for migrating a workload running in a Corporate DataCenter to AWS. …

OBJECTIVE: If your organization utilizes multiple types of databases such as MSSQL, MySQL, Postgres, and more, managing the security, user creation, user tracking, monitoring user activity, and handling user modifications or deletions can become a complex and challenging task. …

Life is a continuous adventure, filled with unexpected twists and turns that demand our resilience and adaptability. Every once in a while, we encounter challenges that test our limits, pushing us to explore uncharted territories and expand our horizons. This is a tale of one such journey, where the protagonist's…

Introduction to Teradata Performance and NOT NULL Welcome to our latest Teradata performance blog post, a series designed to provide valuable insights into SQL queries. This article spotlights ‘NOT IN’, a powerful tool that allows you to selectively exclude data from your query outcomes, refining your data discovery process. To delve deeper into ‘NOT IN’, it is…

What does concurrency control mean? Database concurrency control is a technique used in database management systems (DBMS) to ensure the consistency and correctness of data when multiple transactions are executed concurrently. …

Introducing what the recovery manager is, the data structure of log files, and one of the most famous recovery algorithms: ARIES. Introduction In the world of Database Management Systems (DBMS), a recovery manager plays a vital role in ensuring the integrity, reliability, and recoverability of data. It is a crucial component…

Teradata Identity Columns and CREATE TABLE AS Facing hurdles with the Teradata Identity columns and Volatile Tables? Buckle up because we’re about to overcome this challenge. Despite the inherent limitation, a clever workaround lets you leverage the ‘CREATE TABLE AS’ statement to generate Volatile Tables, even with Identity columns. So, stick around as we unpack this ingenious…