Operations | Monitoring | ITSM | DevOps | Cloud

How to Use Snowflake ODBC Connection Strings & Parameters

ODBC connection makes it easy for developers to access data stored in the Snowflake AI data cloud. Even if you aren’t familiar with Snowflake API or have never handled the specific formatting types of data this database supports, ODBC connectivity will still work for you. Using ODBC drivers to connect to Snowflake eliminates the need for manual interventions or finding workarounds.

11 Top MongoDB Monitoring Tools - Including Free & Open-Source [2024]

MongoDB has become a cornerstone in modern database architectures. Its flexibility and scalability make it a go-to choice for many organizations. But with great power comes great responsibility—and the need for robust monitoring. There are many monitoring tools out there, and choosing the right one can be confusing. This article lists the top MongoDB monitoring tools, from open-source ones to fully managed SaaS solutions.

Here Come the Newly Updated Delphi Data Access Components With Support for RAD Studio 12.2 and Lazarus 3.4

It’s high time we shared a new release of Delphi Data Access Components with a slew of new features and enhancements that will surely be worth your while—including support for the latest versions of RAD Studio and Lazarus, new options, improved performance, and much more. Curious? Let’s take a look at what awaits you in this release. Please refer to the revision histories in the table below for the full list of changes.

How to Enable, Configure, and Use MySQL Query Logging

What is the purpose of query logging in MySQL? Why is it important? How do you enable and configure it? In this article, we will address these questions and more. You will find a detailed guide on how to use mysqldumpslow to analyze slow query logs, along with tips on harnessing convenient GUI tools like dbForge Studio for MySQL to your advantage.

Time to Empower Yourself With the Newly Updated dbForge Tools for MySQL 10.1

There’s nothing quite like delivering regular feature-packed updates to our dear users—and we’ve got one for you today. dbForge tools for MySQL have been updated to version 10.1 with extended connectivity and quite a few new tricks to make your work easier and faster. To top it off, you get convenient CLI-powered generation of comparison reports. Would you like to know more? Then let’s get started!

How SSIS Expression Works?

Using SQL Server Integration Services, you can perform all kinds of operations on your company’s data. Through a user-friendly environment with a relatively easy learning curve, you can create a vast range of complex and scalable data-rich solutions. Moreover, all of this is done within an easy-to-use IDE, where coding is often unnecessary for most common tasks. Fitting naturally into Microsoft environments, SSIS is also capable of connecting with diverse data sources and destinations.

What Is StrongDM, and How dbForge Studio for PostgreSQL Supports It

Privileged Access Management (PAM) solutions have become increasingly popular due to their ability to address data security concerns with flexible access control. One essential area for employing PAM solutions is using them alongside database clients (from the simplest ones to full-fledged IDEs) to ensure safe access to databases. StrongDM is a leading PAM solution that supports modern software development infrastructures both on-premises and in the cloud.

The Importance of Access Checks and Controls in Database Development | The Tony and Tonie Show

Welcome to another episode of the Tony and Tonie Show, where we dive into the latest articles from Redgate's Product Learning platform. In today’s episode, Tony and Tony discuss a real-life database security incident where Flyway databases were accidentally deployed to the wrong environment. 😱 The team breaks down: The importance of access controls and the Principle of Least Privilege in database development. How a lack of proper permissions can lead to critical errors in production environments.

Flyway Forking and Branching in Database Development: Explained! | The Tony and Tonie Show

Welcome to another episode of the Tony and Tony Show, where we discuss the latest articles from Redgate’s Product Learning platform. This episode dives into Flyway Forking and Branching—an essential concept for team-based database development. In this episode: The importance of forking and branching in Flyway to allow developers to work on separate tasks in parallel. How Flyway supports multiple locations for migration files to enable smooth branching.

Meet SSIS Data Flow Components Major Release: Fresh Components, Subscription Model, New Licensing Options, and Other Enhancements

Devart is excited to announce a major release featuring new SSIS Data Flow Components for Zendesk, SurveyMonkey, and Shopify. This update also introduces a new subscription model with flexible and cost-effective plans for users, along with expanded licensing options. Additionally, significant enhancements have been made to improve performance and functionality of the existing SSIS Data Flow Components that aim to help businesses take their data integration processes to a whole new level. In this release.

How to speed up database testing | The Tony and Tonie Show

In this pilot episode, Tonie and Tony dip into two new technical articles from Redgate: one about Redgate Test Data Manager and how use of containerized clones and PowerShell automation can speed up database testing, and one about Flyway, explaining its Repair command, what it does, how it works and best practice guidance.

Aiven workshop: Boost your PostgreSQL skills: Beginner's guide to SQL optimization

Learn the basics of query optimization in PostgreSQL. From understanding the path of the query to optimizing your indexes and joins, we’ll cover the foundation, tools and techniques to improve the performance of your SQL queries. Open to beginner levels, though the knowledge of SQL basics is desired.

Simple Talks Podcast | Episode 6 - Coffee chat with Tonie Huizer

Louis is joined by Redgate author, business owner and conference speaker Tonie Huizer for coffee and a chat. Tonie discusses how he got into technology, why he loves automation, and how speaking about whiskey has more in common with conference speaking than you may think. He also gives a taster of his upcoming PASS Data Community Summit sessions and teases an exciting new Simple Talk series for 2025.

What sets Redgate Monitor apart. - Joshua Higginbotham | Redgate

Joshua Higginbotham, Senior Architect at Centric Consulting, shares what sets Redgate Monitor apart. Redgate Monitor provides context-rich diagnostic insights to maximize cloud database health and performance while ensuring a consistent monitoring experience across your on-prem and cloud database estate.

The Rise of Open Source Time Series Databases

Time series databases allow you to store and query metrics efficiently. For example, if you want to forecast load on your servers, or identify intermittent faults with your production services, time series databases can help. Besides infrastructure monitoring, time series databases have been invaluable in finance, IoT applications, manufacturing, and more. Many time series databases, including VictoriaMetrics, are open source.

What's new with Oracle Cloud for 2024

As we approach Oracle CloudWorld - a three-day event focused on cloud innovation, automation, and AI, where attendees can learn and network - we take a look at the innovation and growth Oracle Cloud has embarked on this year. Oracle Cloud Infrastructure (OCI) has experienced notable growth in fiscal year 2024. According to Oracle’s Q4 results, Cloud Revenue (IaaS plus SaaS) reached $5.3 billion, marking a 20% increase in both USD and constant currency.

dbForge Tools for SQL Server 7.0: Big Release Overview

Are you a user of dbForge tools for SQL Server? If you are, then we’ve got a great slice of news for you—our entire product line for SQL Server has just been updated, and you’re welcome to get your update right now. If you are not, you may still want to take a look at all the goodies that come with this release. Our tools come with a hefty free trial, and we gladly invite you to give them a go. Down with the intros, let’s get started!

The Latest and Greatest dbForge SQL Complete 7.0 Is Now at Your Service!

dbForge SQL Complete is, without a doubt, one of our key add-ins for SSMS, designed to level up the speed and precision of your routine SQL coding, formatting, and debugging. And today, we’re happy to herald the release of its latest incarnation—version 7.0. Traditionally, here’s a detailed overview of all the new goodies awaiting you in it; so buckle up, since it’s going to be a long ride—but by no means boring.

Oracle COUNT Function: From Basics to Advanced

Oracle is one of the most widely used database management systems for a reason. It provides an extensive set of tools that allow you to accomplish even the most intricate tasks. Today, we will focus on the Oracle COUNT function, exploring what it is, how it works, its structure, and addressing common misconceptions and best practices. dbForge Studio for Oracle will serve as our trusted wingman, supporting us throughout this process.

Monitor Oracle Cloud Infrastructure with Datadog

Oracle Cloud Infrastructure (OCI) provides cloud infrastructure and platform services designed to support a broad spectrum of cloud strategies and workloads. OCI provides enterprise customers with scale-up resource scaling architectures, ultra-low-latency networks, and more to help them migrate legacy workloads to the cloud, while supporting cloud-native applications via an expansive network of cloud partners and services.

Grafana Tempo 2.6 release: performance improvements and new TraceQL features

Grafana Tempo 2.6 is here with performance improvements and buckets of new TraceQL features! Watch the video above for an overview of the new TraceQL features, or continue reading to get a quick overview of the latest updates in Tempo. If you’re looking for something more in-depth, don’t hesitate to jump into the Grafana Tempo 2.6 release notes or the changelog.

Visualize Catchpoint, PagerDuty, and Amazon DynamoDB data: what's new in Grafana Enterprise data source plugins

As part of our big tent philosophy here at Grafana Labs, we believe you should be able to access and derive meaningful insights from your data, regardless of where that data lives. One of the ways we stay true to that philosophy is through our Grafana Enterprise data sources.

Database Monitoring Explained - A Comprehensive Guide

Ensuring all operations are normal and all data is guarded in the firm’s IT structure is vital. Regularly checking out various aspects that indicate the performance of the database makes it easier for management to identify issues that may have gone out of hand through database monitoring.

Fixing Dependent Column Issues With dbForge Data Generator

Users should maintain data consistency to ensure accurate database testing and analysis, especially when generating data in dependent columns. For example, they can use formulas, data generators, or post-scripts to fill in columns based on other columns in the table. However, post-scripts may be complicated and affect database performance. In the article, we’ll explore how to generate values for the referenced columns using dbForge Data Generator for SQL Server.

How to Mass Update Records in Salesforce Using Excel Add-Ins

Manual updating of Salesforce records is far from optimal. If you have ever worked with this CRM, you should know it requires you to find the exact record you want to edit, and only then you’ll be able to change data in its fields. This is fine when you work with separate records, but what if you need to mass update records in Salesforce? If done manually, such an update might eventually lead to errors and consume time.

BEGIN TRY/BEGIN CATCH vs GOTO in SQL Server

When handling errors in SQL Server, SQL developers have several options for resolving issues that arise during query execution. Two commonly used methods are BEGIN TRY/BEGIN CATCH and GOTO. While both serve to manage and respond to errors, they do so in distinct ways. In this article, we’ll compare BEGIN TRY/BEGIN CATCH and GOTO, exploring their use cases, advantages, and potential drawbacks to help you choose the best approach for your SQL Server error-handling needs.