Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

A complete guide on Azure SQL Reservations: Save big on your database costs

If you’re using Azure SQL Database for your applications or business, you’ve probably noticed that while the service is amazing for scalability and management, it can get expensive pretty fast. That’s where Azure SQL reservations come in. It is an awesome way to save money. In this blog, we’re going to break down what Azure SQL reservations are, how they work, and why you might want to consider them for your organization. Let’s dive in, shall we?

Tracking and Improving PostgreSQL's Cache Hit Ratio | The Tony and Tonie Show

In this latest episode, Tony and Toney discuss PostgreSQL's buffer cache hit ratio (BCHR), a metric tracked by Redgate Monitor to help you assess the health and performance of your databases. By correctly interpreting this ratio and using it with other relevant memory and IO metrics, you can identify potential bottlenecks in query execution before they impact users.

How to Change a Table Name in MySQL in Different Ways

In one of our previous articles, we discussed how to rename a database in MySQL in detail. In this article, we will focus specifically on renaming tables in MySQL. Rename table operations are common. Quite often, as business situations and requirements change, it becomes necessary to change the names of tables in MySQL databases.

Navigating multi-cloud database deployments with MySQL for maximum uptime

Public cloud providers offer convenient services for database deployments. However, depending solely on a single provider’s database-as-a-service can result in vendor lock-in and reduce your system’s resilience against widespread outages affecting the provider. Instead, explore our approach to deploying MySQL across multiple clouds. A multi-cloud database strategy enables you to retain control of your infrastructure while enhancing overall resiliency and leveraging the unique strengths of each cloud provider.

5 Best Delphi IDEs for 2025: Features and Benefits

An integrated development environment (IDE) for Delphi can streamline workflows, making it easier to deliver high-quality applications. The best Delphi IDE is essentially an all-in-one toolkit for crafting, testing, and deploying your application. Advanced IDEs empower developers to modernize data access components while preserving code security. Yet, not all of them ease the complexities of multi-platform development in the same way.

What's New in Devart ODBC Drivers: Extended Compatibility, Updated SQL Engines, and Further Enhancements

Here comes an update of Devart ODBC Drivers, our high-performance connectivity solutions that enable access to a variety of data sources from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32-bit and 64-bit Windows, macOS, and Linux. Our Drivers fully support standard ODBC API functions and data types, grant easy and secure access to live data from 80+ sources, and can be integrated with 100+ third-party tools.

How to Restore a SQL Server 2019 Backup on a SQL Server 2017 Instance

Restoring a database backup directly from a newer version of SQL Server to an older one fails or causes incompatibility errors. For example, a backup created on SQL Server 2019 cannot typically be restored on a SQL Server 2017 instance. Since a direct downgrade isn’t possible, we’ll demonstrate alternative methods to migrate a SQL Server database from 2019 to 2017.