#dba Development Tutorials & Tips | Roast Dev

Storage Administrators Mastering Database Administration

Storage administrators are essential in managing enterprise data, ensuring it remains available, secure, and reliable. With the growing demand for skilled database administrators (DBAs), many storage ...

12.03.2025 0 Read More

ps --forest | for navigating Oracle PID's

{ Abhilash Kumar Bhattaram : Follow on LinkedIn } A primer about what is ps A ps (Process Status) Session involves analyzing active processes running on a Linux system using the ps c...

15.03.2025 0 Read More

# PostgreSQL Tutorial: 🚀 How to Improve PostgreSQL Database Performance: A Practical Guide

PostgreSQL is a powerful and feature-rich open-source relational database, but like any complex system, its performance depends heavily on how it's used. Whether you're managing a startup app or a lar...

04.05.2025 0 Read More

# OpenSearch : 🚀 How to Improve Index and Shard Performance in OpenSearch

OpenSearch, a powerful distributed search and analytics engine, offers high scalability and near real-time search capabilities. However, as data volume and query complexity grow, performance bottlenec...

04.05.2025 0 Read More

Simplifying PostgreSQL Upgrades with pgdump-each

Upgrading PostgreSQL to a new major version can be a daunting task, especially when ensuring data integrity and minimizing downtime. Traditional methods often involve complex procedures and significan...

29.03.2025 0 Read More

💡 How Datadog Helps Developers & Teams

Datadog is more than just a monitoring tool — it’s a full-stack observability platform that empowers developers, DevOps engineers, SREs, and even business teams to monitor, debug, optimize, and se...

16.04.2025 0 Read More

⚙️Integrate Datadog with a .NET Application

As mentioned in a previous post https://dev.to/kiranrongali/how-datadog-helps-developers-teams-kkg, we discussed how Datadog can benefit developers and teams. In this post, we'll focus on integrating ...

21.04.2025 0 Read More

Troubleshooting tempdb Growth: Identifying Idle Sessions Holding Temporary Resources in SQL Server

To find out how much tempdb disk space is occupied by each session that is connected and is idle in a SQL Server database, you can use the following query. This query leverages Dynamic Management View...

25.04.2025 0 Read More

# 📚 The Hidden Limits # PostgreSQL Tutorial: Inside PostgreSQL — And What Happens When You Hit Them

PostgreSQL is powerful, flexible, and impressively stable. But even Postgres has internal limits — some hard, some soft.Most of the time, you’ll never encounter them. But if you push the system ...

27.04.2025 0 Read More

Neo4j Tutorial: # 📚 Handling Neo4j Database Consistency Errors — With a Real-Life Example and Visuals

Neo4j is trusted for its strong ACID guarantees. Yet in real-world operations, unexpected issues like consistency errors can still happen — especially after unclean shutdowns, crashes, or disk failu...