Operations | Monitoring | ITSM | DevOps | Cloud

MySQL String Functions in Action

What’s so special about MySQL? Why do most developers choose this relational system for managing databases? MySQL is widely used primarily because it’s based on the Structured Query Language (SQL), which is a perfect fit for accessing and handling records. Additionally, MySQL attracts users with its scalability and robust performance. This post will focus on another advantage that should be mentioned to highlight the value of MySQL.

Python Connectors Release: Microsoft Excel Integration and Updated Subscription Model

We are thrilled to announce the latest release of our Python Connectors product line, now featuring a subscription model designed to offer even greater cost-effectiveness and convenience. The new pricing structure makes our connectors more accessible, allowing users to benefit from ongoing updates and support while optimizing their software expenditure.

Simplified Database Schema Upgrades for Icinga Web and Modules

With the release of Icinga Web 2.12, we’ve streamlined and simplified the process for performing database schema upgrades for both Icinga Web and its modules. This new feature not only indicates when an upgrade is pending but also allows for automatic execution of the upgrade. Previously, users had to consult the upgrade documentation and perform the upgrade manually. While it’s still important to read the upgrade documentation, this new feature simplifies the process significantly.

Multi-Tasking in the Modern Database Environment

Every database manager knows the complexities involved in maintaining and optimizing multiple enterprise databases. But knowing the complexities of database management and having the requisite knowledge and skills (never mind the right tools) to get the job done, is a different matter. Businesses today use a wide range of database systems to support a variety of applications and data types.

My Favourite Feature of SQL Prompt - Frank Geisler

Frank Geisler, CEO of GDS Business Intelligence GmbH, shares his favourite feature of SQL prompt. SQL Prompt enables users to write high quality SQL faster. As well as autocompleting your code, SQL Prompt takes care of formatting, object renaming, and other distractions, so you can concentrate on how the code actually works..

MongoDB use cases for the telecommunications industry

A trusted database is fundamental to the smooth and secure operation of telecommunications services:, from network management and customer service to compliance and fraud prevention. MongoDB is one of the most widely used databases (DB Engines, 2024) for enterprises, including those in the telecommunications industry. It provides a sturdy, adaptable and trustworthy foundation. It also safeguards sensitive customer data while facilitating swift responses to rapidly evolving situations.

Monitor Amazon MemoryDB with Datadog

Amazon MemoryDB for Redis is a highly durable in-memory database service that uses cross-availability-zone data storage and fast failover, providing microsecond read times and single-digit-millisecond write times. Datadog’s integration for MemoryDB uses a range of metrics to provide important visibility into MemoryDB performance.

SQL Prompt Improves Productivity - Tracy Boggiano | Redgate

Tracy Boggiano, Database Architect for Sound Physicians, explains how SQL Prompt improves productivity. SQL Prompt enables users to write high quality SQL faster. As well as autocompleting your code, SQL Prompt takes care of formatting, object renaming, and other distractions, so you can concentrate on how the code actually works..

Aligning Database Operations With DevOps

Even with dedicated database staff (often with impressive technical skills), businesses need help understanding how to address database issues. IT managers and database specialists are keen to try different approaches to keeping databases working as efficiently as possible. One popular approach is ‘DevOps’. As companies navigate the complexities of digital transformation and a growing trend toward cloud migration, IT environments have become extraordinarily complex.

Devart Has Become a Digital Sponsor of SQLBits 2024

On March 19-23, Devart joined SQLBits2024, a non-profit yearly conference connecting 2279 attendees from 60 countries for training, networking, and experience sharing. This venue is a place of power for everyone interested in data engineering, architecture, database administration, analytics, and development with SQL, and we were glad to join the ranks with the people who share the same passion for SQL with us.

How to Connect to Azure SQL Database Using Azure Private Link

Azure Private Link is a secure means of accessing Azure PaaS Services (including Azure SQL Database and Azure Storage) over a private endpoint in a virtual network. In other words, you can create your own private link service in your virtual network and deliver it to your customers without exposing it to the public internet. And if you need a tool to develop and manage Azure databases in this environment, there’s no better option than dbForge Studio for SQL Server.

10 tips for Test Data Management success

The role of effective Test Data Management (TDM) is often underestimated in the software development process, yet it is a cornerstone for ensuring quality, compliance, and efficiency throughout the software development life cycle. As Bloor say in their Test Data Management Market Update 2024, “… many enterprises are, to quote one vendor we spoke to, “still in the stone age” when it comes to TDM.

How to set up an open source database monitoring stack with Grafana Cloud

One of the great powers of Grafana is the open source community behind it — a community that provides a breadth of ready-to-use dashboards, plugins, exporters, and instructions that make a million tasks easier. The sheer scale of it all means whatever you need probably already exists somewhere. To illustrate this, I want to share an example of how to use these tools as a base for building a comprehensive database monitoring solution.

How Does SQL Prompt Help Teams - Tracy Boggiano

Tracy Boggiano, Database Architect for Sound Physicians, explains how SQL Prompt helps teams. SQL Prompt enables users to write high quality SQL faster. As well as autocompleting your code, SQL Prompt takes care of formatting, object renaming, and other distractions, so you can concentrate on how the code actually works..

Templates in SQL Prompt - Frank Geisler

Frank Geisler, CEO of GDS Business Intelligence GmbH, shares how he uses the templates available in SQL Prompt. SQL Prompt enables users to write high quality SQL faster. As well as autocompleting your code, SQL Prompt takes care of formatting, object renaming, and other distractions, so you can concentrate on how the code actually works..

Discovering MongoDB Atlas: Perfect for Gen AI-powered Apps

As established in OpsMatters' previous AI articles, generative AI is changing the way digital experiences are created. With its ability to generate new content from existing data - whether that be images, music, or human-like text - GenAI has opened up new possibilities for developers and businesses alike. However, to make any GenAI-powered application run smoothly, you need a reliable database.

How to migrate MySQL databases to a cloud environment?

Migrating MySQL databases to a cloud environment can seem daunting, but with the right approach, it ensures minimal downtime and a seamless transition. The key to a successful migration lies in thorough planning and preparation. This involves understanding your database's complexity, estimating the data volume, and determining the levels of downtime acceptable for your organization.

How SQL Prompt Helps Teams - Frank Geisler | Redgate

Frank Geisler, CEO of GDS Business Intelligence GmbH, explains how SQL Prompt helps teams. SQL Prompt enables users to write high quality SQL faster. As well as autocompleting your code, SQL Prompt takes care of formatting, object renaming, and other distractions, so you can concentrate on how the code actually works..

How the Templates in SQL Prompt Improve Productivity - Frank Geisler

Hear from Frank Geisler, CEO of GDS Business Intelligence GmbH, as he explains how the templates in SQL prompt improve productivity. SQL Prompt enables users to write high quality SQL faster. As well as autocompleting your code, SQL Prompt takes care of formatting, object renaming, and other distractions, so you can concentrate on how the code actually works..

How SQL Prompt Helps with Team Collaboration - Frank Geisler | Redgate

Frank Geisler, CEO of GDS Business Intelligence GmbH, explains how SQL Prompt helps with team collaboration. SQL Prompt enables users to write high quality SQL faster. As well as autocompleting your code, SQL Prompt takes care of formatting, object renaming, and other distractions, so you can concentrate on how the code actually works..

Charmed PostgreSQL enters General Availability

Jul 17, 2024: Today Canonical announced the release of Charmed PostgreSQL, an enterprise solution that helps you secure and automate the deployment, maintenance and upgrades of your PostgreSQL databases across private and public clouds. PostgreSQL is an open source database management system. It has been successfully used for more than 3 decades across all IT sectors. Its maturity and its vibrant community consistently make it a first-choice DBMS among developers.

VictoriaMetrics Anomaly Detection: What's New in H1 2024?

With this blog post, we are excited to introduce a quarterly “What’s New” series to inform a broader audience about the latest features and improvements made to VictoriaMetrics Anomaly Detection (or simply vmanomaly). This first post will cover both Q1 and Q2 of 2024. Stay tuned for the next content on anomaly detection.

Devart Wins Silver at the 19th Annual 2024 Globee Awards for Technology

dotConnect for Oracle from Devart, a high-performance.NET connector that provides direct access to the Oracle Database without the need for an Oracle Client, has won Silver at the 19th Annual 2024 Globee Awards for Technology in the Oracle Cloud Application Services category. This prestigious business award praises companies that excel at hard work and transform tech domains, empowering businesses worldwide.

Optimizing Database Performance with Honeycomb Relational Fields

Martin investigates: what database queries are taking the longest? Then he digs into the one taking the most time, and asks: What user-initiated requests trigger this query? This kind of question helps developers focus our efforts where they count. And it's possible in Honeycomb with Relational Fields. This is #observability during development, using #OpenTelemetry #tracing and Honeycomb.

How to Import and Export QuickBooks Online Data Using Excel Add-Ins

Managing financial data efficiently is important for any business, and QuickBooks Online and Excel are two of the most powerful tools available. However, one of the main challenges businesses face is the limited flexibility in generating custom reports and visualizations directly within QuickBooks. By exporting data from QuickBooks to Excel, businesses can create custom charts, graphs, and visualizations that are not possible in QuickBooks.

Q2 2024 Round Up: VictoriaMetrics & VictoriaLogs Updates

Many thanks to everyone who joined us for our recent virtual meetup, during which we discussed some of our Q2 2024 highlights, including features highlights, the 2024 roadmap for VictoriaMetrics and all the latest news on VictoriaLogs! In this blog post, we’d like to share a summary of these highlights.

Amazon DynamoDB Pricing Simplified: A 2024 Guide For Cost Savings

You’re not alone if you’ve had trouble understanding Amazon DynamoDB pricing. Getting a handle on DynamoDB costs can be complex and tedious. But with the right tools and resources, it doesn’t have to be. In this bookmarkable guide, we’ll break it down step-by-step so you can tell what drives DynamoDB costs.

MongoDB use cases for automotive industry

The automotive industry is a vast and complex sector that includes all companies and activities involved in manufacturing vehicles or their components (such as engines, electronic control units (ECUs) and bodies). However, this sector is growing even more, as it experiences a technological revolution driven by new technologies like artificial intelligence, machine learning, and big data analytics.

SimpleTalks Podcast | Episode 1 - The power of community events and networking

In this episode of Simple Talks, Steve, Ryan and Grant delve into the latest happenings in their world of travel and events. From major conferences to smaller user groups, here’s an overview of recent and upcoming events such as PASS Data Community Summit, PGConf, THAT conference, Data Grillen and local developer meetups. They discuss key takeaways, the impact these gatherings have on the industry and the benefits of building a diverse professional network and how it can open doors to new opportunities.

How to prevent accidental load balancer deletions

The worst thing you could do after successfully deploying to a new environment is to accidentally delete critical infrastructure. Unfortunately, that happened to one Google Cloud customer when their private cloud subscription was accidentally deleted, resulting in nearly two weeks of downtime. This isn’t an isolated problem either: Microsoft Azure had a similar problem when a typo inadvertently deleted an entire SQL Server instance rather than a specific database.

Database Observability and Storage Insights

Storage monitoring involves discovering the estate, devices, and network interconnections. Key telemetry requirements include their states, performance metrics, and logs. As the complexity of the environment increases and storage reliability improves, the focus shifts. Understanding the layers above, such as file systems and databases, and their demand for storage services becomes crucial. This article delves into the detailed knowledge required to achieve effective observability.

Connect MongoDB Databases in Cloud Using Devart ODBC for MongoDB

This tutorial explains how to build Credit Card Analytics by leveraging Power BI Desktop, Devart ODBC for the MongoDB driver, and the MongoDB database. It will not instruct you on how to work on PowerBI Desktop or MongoDB; instead, we will demonstrate how to work with Devart ODBC for the MongoDB driver.

Advanced Insights with SolarWinds Database Performance Analyzer

Resolving an incident before end users are impacted is the new standard, but managing separate observability and incident management solutions is tempting fate. You are at risk of an issue slipping through the cracks. It's time to consolidate, streamline, and decomplexify your operations. Hybrid Cloud Observability combined with SolarWinds Observability and SolarWinds Service Desk make all of this much, much easier.

Optimizing Azure Cosmos DB Costs

Optimizing Azure Cosmos DB Costs In this episode of FinOps on Azure, FinOps certified practitioner - Mike and Gary from the Microsoft Cosmos DB team discuss cost management challenges on Azure, specifically focusing on Cosmos DB. They begin by addressing the common challenges organizations face when managing costs on Azure, particularly with Cosmos DB. The conversation then shifts to practical strategies for cost optimization, including topics like provisioned throughput choices, API options, and factors affecting cost.