Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Redgate Monitor Adds Support for Oracle Multitenant

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.

Using PostgreSQL Anonymizer to Generate Synthetic Data

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.

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

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.

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

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.

What is Database Monitoring

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.

What is Dynamic SQL in SQL Server?

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.

What is Database Change Management (DCM)?

Database change management is the foundation for building a stable, secure, and high-performing application. In today’s fast-paced technological landscape, where agile and DevOps are the go-to for developing database application, rapid releases and continuous iteration are the norms. But with frequent deployments comes the risk of untracked database changes.

Alerting Best Practices

A firing alert is like someone ringing your doorbell - it demands your immediate attention, interrupting whatever else you’re doing. It requires focus and a quick response. But imagine trying to live in an apartment where the doorbell never stops ringing. You could put in earplugs to block the noise, but that only masks the problem - it doesn’t solve it. On the other hand, disconnecting the doorbell entirely isn’t a solution either.