Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

PostgreSQL vs MySQL: Use Cases & Attributes To Help You Choose

Choosing whether to go with PostgreSQL or MySQL depends on your needs as they are both great databases to use under different circumstances. In this article we will run through a few of the top reasons and use cases to help you choose between these choices for database creation. Note: As a matter of fact, MySQL is so popular it became part of the LAMP stack (Linux, Apache, MySQL, PHP) used for building many web servers.

Why Full Reporting Capabilities for Your Databases and Files Are Helpful

Do you know what files your employees access to? Do you know when they create new files? How about when they copy, move, or delete files? How confident are you that your databases are safe and secure from potential intrusions? These are the types of questions any business owner should ask themselves, especially now. With more people working from home and telecommuting, you need to know exactly what databases and files your employees access, use, update, change, alter, move, and delete.

Start and Stop DocumentDB Clusters Actions

Amazon DocumentDB is a managed MongoDB-compatible database service provided by AWS. It provides the database in clusters, with multiple instances, for high-availablity. To help with cost-reduction strategies, AWS allows DocumentDB clusters to be stopped and restarted. While the cluster is stopped, you’re not charged. So it’s a great candidate to shut off overnight and on weekends if it’s not needed.

What unique technical value does Redgate's Database DevOps solution provide?

Why a GitHub account or an Azure DevOps subscription isn't enough to implement database DevOps. A colleague recently relayed a great question from the community: why isn’t a hosted development, collaboration, and automation environment such as Azure DevOps enough by itself to implement Database DevOps? In short, generalized DevOps development and automation tooling does an excellent job at hosting version control repositories and at enabling automation.

Challenges to Database DevOps: Dealing With Drift

Sometimes, people start their DevOps journey by getting their database into source control, but then, they don’t deploy from source control. Instead, they continue their manual deployments to production. Quickly they find that the database code in their production instances and the database code in their source control system don’t match.

New SQL Change Automation Filter Features for Enterprise Teams: Migrations and Drift Report

Options for filtering when generating migrations and when reporting on database drift help teams make the best of tricky database environments. From Enterprises to tiny startups, most developers prefer to do work in small teams these days. But when it comes to database development, teams in Enterprises often have a hard time keeping these small teams fully separate in the development process.