Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

SQL Server Transaction Log Analysis

Transaction logs play a crucial role in database management, especially in SQL Server databases. These logs meticulously record every transaction and the corresponding changes made to the database. Such detailed tracking is indispensable for identifying issues and restoring the database to a specific state and time if any failures occur. In SQL Server, every database includes a transaction log, a feature that is always enabled and cannot be turned off.

Explore the NiCE MariaDB Management Pack in Action2025Q3

If you’re running critical MariaDB workloads and need reliable, performance-focused monitoring, this session is for you. You’ll get a live walkthrough of the Management Pack, learn how it integrates seamlessly into SCOM, and explore real-world use cases to improve your database monitoring strategy.

Complete Guide to Redis Monitoring: Essential Metrics, Tools & Best Practices 2025

Redis is a powerful tool, but its position in the critical path of applications means that performance issues can have a widespread impact. Whether you use Redis as a cache, session store, or primary database, effective monitoring is essential to prevent slowdowns and ensure a responsive user experience. This guide provides a comprehensive walkthrough of Redis monitoring, covering the essential metrics you need to track, the tools available to you, and the best practices to adopt in 2025.

Vector Databases Explained: What they are & Why they Matter [Quick Question Ep. 2]

Ever wondered what a vector database is and why it’s becoming so important in AI search? In this quick video, I’ll break down what a vector database is, how it works, and what you should consider when choosing one. About Elastic Elastic, the Search AI Company, enables everyone to find the answers they need in real time, using all their data, at scale. Elastic’s solutions for search, observability, and security are built on the Elastic Search AI Platform — the development platform used by thousands of companies, including more than 50% of the Fortune 500.

PostgreSQL Table partitions now supported in Flyway

This blog post was originally authored by Prajakta Tamhankar, whose insights and expertise shaped much of the content you’ll read here. We are thrilled to announce the General Availability (GA) of Table Partitions for PostgreSQL users in Flyway v8.0.2. This new functionality is designed to enhance your database management experience by providing robust support for table partitions, including sub-partitions and range partitions.

Build EF Core Models Visually with Entity Developer - No More Manual Mapping!

Want to simplify your EF Core development? Discover how Entity Developer — a powerful visual ORM tool from Devart — helps.NET developers design, generate, and maintain EF Core models faster and with fewer errors. In this video, you’ll learn how to: Entity Developer works as both a standalone app and a Visual Studio plugin, giving you flexibility across any development environment. With support for EF Core, NHibernate, and LinqConnect, it's your all-in-one solution for ORM design in.NET.

Live PostgreSQL Monitoring on Azure & AWS with pgNow

Managing credentials gets trickier as your Flyway project grows, especially when databases contain sensitive data. In this episode, Tony and Tonie break down how Flyway’s Property Resolvers help you keep secrets safe by pulling them securely from local or cloud-based stores, avoiding hardcoding them into config files.

Database Naming Standards: SQL Conventions for Tables, Columns, and Keys

SQL naming conventions are often at the root of database headaches. One careless name like temp1 or new_table can lead to broken queries, failed deployments, and hours of avoidable debugging. To prevent this, teams need clear, enforceable naming standards: rules they can rely on as databases evolve. Many organizations also turn to purpose-built SQL Server IDEs to apply the standards programmatically, visualize relationships, and manage schema changes across environments.

Credentials and Flyway: Keep Secrets Safe with Resolvers

Managing credentials gets trickier as your Flyway project grows, especially when databases contain sensitive data. In this episode, Tony and Tonie break down how Flyway’s Property Resolvers help you keep secrets safe by pulling them securely from local or cloud-based stores, avoiding hardcoding them into config files.