Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Supercharging FerretDB Performance with Coroot: A Success Story

At Coroot, we’re passionate about providing developers with the tools they need to build and maintain high-performing applications. Recently, we had the opportunity to help a team using FerretDB, the open-source document database offering MongoDB compatibility with a PostgreSQL backend, significantly improve their monitoring and performance. This is their story.

How to benchmark your database management system | Data & AI Masters | Canonical

In this talk Mohamed Nsiri will provide a step-by-step guide on how to perform a benchmark of a given database management system configuration. We will explain how to assess the performance impact of a change (in memory, cpu speed, etc.) and how to universally compare different setups. The workshop will cover various factors that can significantly impact the performances of your databases including number of concurrent users, workload pattern and more.

Finding Significant Differences in Flyway SQL Migration Code | The Tony and Tonie Show

In this episode of The Tony and Tonie Show the pair discuss using PowerShell-based tokenization to compare two SQL migration files. How it ignores non-functional changes like comments or formatting and pinpoints the first meaningful change in SQL logic, providing detailed feedback on its location and nature. Make sure to subscribe to our channel if you want to watch more from Tony & Tonie.

Monitor your Pinecone vector databases with Datadog

Pinecone is a vector database that helps users build and deploy generative AI applications at scale. Whether using its serverless architecture or a hosted model, Pinecone allows users to store, search, and retrieve the most meaningful information from their company data with each query, sending only the necessary context to Large Language Models (LLMs). By providing the ability to search and retrieve contextual data, Pinecone enables you to reduce LLM hallucinations and enhance data security.

How to Handle Null or Empty Values in SQL Server

When working with databases, we often encounter rows that lack data. This missing data may result from unknown or inapplicable values, errors during data import or input, or specific calculations involving non-existent values. In such cases, there are two ways to represent missing data: NULLs and empty (or blank) values. While these might seem identical at first glance, they are different and impact essential database operations in distinct ways.

Simple Talks Podcast - Episode 13 - Ending the Season Together

Today, all the hosts (Louis Davidson, Ryan Booz, Kellyn Gorman, Steve Jones, and Grant Fritchey) get together for a festive adjacent discussion about AI, content, books, community, vector, PIVOTing, observability, and we end up with a brief discussion on gluten-free gingerbread men (because we did!) All this, though absolutely none of us broke into song like a Hope/Crosby musical!

VictoriaMetrics helps IHI Terrasun Win Big in Vegas on $1.2B Clean Energy Project

We’re happy to announce that VictoriaMetrics, open source time-series database and monitoring solution, and IHI Terrasun Solutions, a leading energy storage system integrator, have partnered on one of North America’s largest clean energy projects! The Gemini Solar + Storage project, which is carefully situated on less than 5,000 acres, is designed to provide clean energy for up to 10% of Nevada’s electricity needs during peak use times.

phpMyAdmin vs. dbForge Studio: Why Upgrade to a Pro-Level MySQL Tool?

Tired of the limitations of phpMyAdmin? Upgrade your database management with dbForge Studio for MySQL—a professional IDE packed with features to simplify and accelerate your MySQL and MariaDB workflows. In this video, we compare phpMyAdmin's basic features with dbForge Studio's advanced tools, covering SQL code completion, object editors, database comparison, source control integration, and more. Whether you're managing databases for a small project or working on complex enterprise-level systems, dbForge Studio offers the power and flexibility you need.

DBaaS Explained

Managing databases is a real pain point for businesses. It is time-consuming and complicated, and it often distracts resources away from main operations. This is where database as a service (DBaaS) comes into play. DBaaS is revolutionizing the way organizations manage their data—tremendously faster and in a much more secure manner. It is a cloud-native solution that manages your database problems. You no longer have to build and maintain your own database infrastructure.

NiCE Oracle Management Pack | 5 Minutes Explainer Video

This short video will give a quick overview of the main features of the NiCE Oracle Database Management Pack, such as Discovery, Monitors, Diagnostic Tasks, Performance and Logfile Monitoring, Reporting, and, of course, Security aspects of advanced Oracle database monitoring.