Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Simple Talks Podcast | S2, Episode 6 - Redgate Advocates: Their Origin Stories

The Redgate Advocates (Kellyn Gorman, Ryan Booz, Steve Jones, and Grant Fritchey) sat down at the PASS Summit last year and spent some time telling how they went from working directly in tech, to helping others work with tech - both inside and outside of Redgate and their products. Connect with the hosts.

How to master the SGA and PGA in Oracle databases

If you have a car or a motorcycle, you frequently tune it to have top-notch performance. Similarly, while using Oracle Database, you need to manage memory effectively. When you get it right, everything runs smoothly; when you get it wrong, you face slow queries and frustrated users. As we are talking about Oracle databases here, you are probably aware of the system global area (SGA) and program global area (PGA) in Oracle, which play a crucial role in database memory management.

How does MongoDB work?

Data is essential for gaining a competitive advantage in business. It has the power to reveal new insights that offer opportunities for profit, efficiency, and operational scaling. This is why organizations of all sizes and industries are eager to leverage data for an edge in the marketplace. However, working with data can be challenging for many businesses due to various obstacles like database storage scalability, security, and compliance.

Why Do You Need a Redis Monitor in Place?

Redis Monitor is a simple yet powerful command-line tool that displays every command processed by a Redis server in real-time. It provides visibility into exactly what’s happening inside a Redis instance as it happens. Running a single command can uncover hidden performance issues: The output reveals thousands of unexpected HGETALL operations on a key that should be accessed infrequently. This exposes a Redis call inside a loop, causing unnecessary database strain.

Getting the most out of Flyway Code Analysis | The Tony and Tonie Show

Flyway will automatically check pending migration files for code smells using built-in and customizable rules. In this episode, Tony and Tonie discuss not one but two Phil Factor articles! One explains how to get started, and the other provides a starter pack of custom regex rules to help teams implement their own coding standards and describes how to maintain your rule library efficiently as it grows.

Top 100 SQL Interview Questions and Answers for Every Skill Level

Imagine spending weeks grinding through SQL tutorials, practicing syntax, and refining your queries in your spare time. But when the interviewer throws a complex JOIN + subquery at you, your brain suddenly hits a 404. It happens to the best of us. However, most candidates crash and burn—not because they lack knowledge, but because they prepare like students instead of engineers. They memorize syntax, pray for predictable questions, and freeze the moment they’re asked to think, not recite.

SQL Aggregate Functions: Syntax, Use Cases, And Examples

Without SQL aggregate functions, databases would be nothing more than glorified spreadsheets. These functions—SUM(), COUNT(), AVG(), MIN(), and MAX() —do the heavy lifting in analytics. They process massive datasets, transforming scattered records into clear, usable insights that drive decision-making. But while aggregation simplifies data, it can also slow things down.