%term

The latest News and Information on Databases and related technologies.

New in Redgate Monitor: Oracle Data Guard support

Sep 2, 2025 By Rukaiya Khondaker In Redgate

Redgate Monitor now supports Oracle Data Guard environments, giving DBAs instant visibility into replication health, lag and role transitions, so Standbys stay in sync and are ready to protect availability and data when needed. DBAs running Oracle Data Guard know that keeping replicas healthy requires constant vigilance. It often involves querying dynamic performance views, such as V$DATAGUARD_STATS, or running Data Guard Broker commands to check lag and role status.

Read Post

Redgate

Read more about New in Redgate Monitor: Oracle Data Guard support

Database monitoring for beginners

Sep 2, 2025 By Grace Nalini In Site24x7

Understand what's happening inside your database before your users do. Modern applications live and breathe through their databases. But when slow queries, connection spikes, or failed transactions start to pile up, the impact isn't just technical—it's customer-facing. That's why tracking your databases gives you the visibility into how your databases are performing under the hood.

Read Post

Site24x7

Read more about Database monitoring for beginners

Redgate Monitor Adds Support for Oracle Multitenant

Aug 29, 2025 By Ricky Eaton In Redgate

Redgate Monitor now gives you full visibility into activity across Oracle Multitenant environments. With metrics and alerts at both the Container Database (CDB) and Pluggable Database (PDB) level, you can quickly pinpoint performance issues and ensure compliance. With the introduction of Oracle multitenant architecture in Oracle 12c, many teams began consolidating databases into a single Container database (CDB). This helped them to optimize resource usage and simplify patching.

Read Post

Redgate

Read more about Redgate Monitor Adds Support for Oracle Multitenant

Using PostgreSQL Anonymizer to Generate Synthetic Data

Aug 29, 2025 By Jay Miller In Aiven

Set aside the data masking features of PostgreSQL Anonymizer. This plugin can save the day during development by simplifying your workflow and generating schema-accurate, privacy-compliant test data. In a previous post, we discussed using static and dynamic masking to anonymize data. I spent the last two weeks trying to write followups for the anonymization posts. It's time to confess... I'm an over-engineerer.

Read Post

Aiven

Read more about Using PostgreSQL Anonymizer to Generate Synthetic Data

NHibernate Tutorial: Database-First & Model-First Using Visual ORM Designer

Aug 29, 2025 By Devart In Devart

Learn how to create and configure an NHibernate model with Entity Developer — Devart’s powerful visual ORM designer for.NET. In this step-by-step tutorial, we’ll cover both Database-First and Model-First approaches, show how to update models, generate mappings and classes, and even produce SQL scripts directly from your model. Whether you’re using Visual Studio or working in VS Code, Entity Developer makes NHibernate development faster, easier, and more reliable.

View Video

Devart

Read more about NHibernate Tutorial: Database-First & Model-First Using Visual ORM Designer

dotConnect for SQLite: Fast .NET data access with ORM and encryption support

Aug 29, 2025 By Devart In Devart

Supercharge your.NET applications with dotConnect for SQLite — the high-performance data provider trusted by thousands of developers. Whether you're building lightweight apps or enterprise-scale solutions, dotConnect delivers secure, encrypted access to SQLite with seamless Visual Studio integration, powerful ADO.NET architecture, and full ORM support, including Entity Framework Core. Chapters: Try it free for 30 days and see why thousands of developers trust dotConnect for SQLite in mission-critical environments.

View Video

Devart

Read more about dotConnect for SQLite: Fast .NET data access with ORM and encryption support

What is Database Monitoring

Aug 28, 2025 By Anjali Udasi In Last9

Database monitoring transforms from a reactive troubleshooting exercise into a proactive optimization strategy when you have the right tools and approaches in place. This blog shares practical ways to choose monitoring solutions, set up observability for different database platforms, and design workflows that scale in modern distributed systems.

Read Post

Last9

Read more about What is Database Monitoring

Copyleft and Apache 2.0: From Redis to Valkey

Aug 28, 2025 By Coroot In Coroot

Valkey OSS Developer Advocate Roberto Luna Rojas explains how Valkey can help improve your toolstack, and the history it shares with Redis.

View Video

Coroot

Read more about Copyleft and Apache 2.0: From Redis to Valkey

MySQL vs. NoSQL: What's the difference?

Aug 27, 2025 By Coroot In Coroot

Valkey OSS Developer Advocate Roberto explains the difference between a Relational Database (think Postgres or MySQL) and a key-value datastore. Spoiler: Key-value in-memory stores are mind-bogglingly fast.

View Video

Coroot

Read more about MySQL vs. NoSQL: What's the difference?

What is Dynamic SQL in SQL Server?

Aug 26, 2025 By Rosemary Asufi In Devart

Dynamic SQL in SQL Server is built for scenarios where queries can’t be fully defined in advance. It’s the method of choice when structure depends on user input, variable schemas, or runtime conditions, cases where static SQL falls short. However, without proper structure, this flexibility introduces security and maintenance challenges. To make it work at scale, you need a disciplined approach.

Read Post