Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

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.