Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

Schedule database backups for MongoDB in a Node.js application

Database backup protects your data by creating a copy of your database locally, or remotely on a backup server. This operation is often performed manually by database administrators. Like every other human-dependent activity, it is susceptible to errors and requires lots of time. Regularly scheduled backups go a long way to safeguarding your customers’ details in the case of operating system failure or security breach.

What does Pinal Dave think of SQL Monitor?

Last week we had the pleasure of speaking to SQL Authority’s Pinal Dave to show him some of our favorite SQL Monitor features! Pinal has used – and been a fan of – SQL Monitor since it launched in 2008 (fun fact: it was named SQL Response back then). There are, however, some newer features that Pinal isn’t too familiar with, and we were delighted to introduce those to him.

Running VictoriaMetrics on ARM-based processors

ARM processors become more popular and more cost-effective according to many benchmarks. One of them was made by Percona for MySQL. Some of our users reported issues with VictoriaMetrics at AWS Graviton instances. The main concerns were higher CPU and disk IO usage compared to x86 instances of the same size and for the same workload. By that time, we verified that VictoriaMetrics works fine for raspberry and IoT devices, but didn’t do any optimizations for ARM builds.

Introducing DevOps to the US Government - Part 2

In the first post in this series, I talked about the challenges for the US Government sector when attempting to introduce DevOps. The sector lags behind others such as Financial Services on every measure, yet the technical obstacles like a disruption to workflows and a lack of appropriate skills are the same.

SQL Sentry Advisory Conditions Tutorials

As a customer success engineer, I hear directly from customers about what issues they need help solving with SolarWinds SQL Sentry®. This insight first motivated me to create posts for the SQL Sentry Tips & Tricks series, which explains how to get the most out of SQL Sentry. Now, I’d like to create more tutorials about what I consider to be one of the most powerful features in SQL Sentry: Advisory Conditions.

A Conversation With Aaron Bertrand

Back in the early days of Microsoft SQL Server, database administrators had few resources to draw upon and learn from. In the ’90s, we had SQL Server Professional, edited by Karen Watterson. We had CompuServe forums for SQL Server and Sybase. We had Microsoft documentation, which meant three printed books with no books online.

DevOps 101: What, who, why, and how?

Organizations around the world are turning to DevOps as a way of working together to improve the efficiency and quality of software delivery and increase value to the business. But what exactly is DevOps and what does it mean for you and your organization? Welcome to DevOps 101. Our new monthly webinar series aims to explain exactly this. Each live session will be hosted by me, Grant Fritchey, starting with the fundamentals to expand your knowledge and understanding of DevOps.

Automating database cleanup with scheduled pipelines

RESTful API projects often require that developers grant temporary access to a particular resource. Sometimes this happens within a specific interval, such as a few days or months. Revoking permissions when they expire could mean including extra logic during the authentication process or writing a middleware function to attach to the secured endpoint. Or, this logic could be abstracted to a separate part and configured to check and manage permissions at a regular interval.

Cross-functional collaboration: Why marketing is perfectly placed to set the example in a distributed, hybrid world

Running successful cross-functional projects, when teams are no longer co-located in the same physical space, requires a different approach. Read on to find out how we used this as an opportunity to improve how the Marketing Division at Redgate collaborates with other parts of the business and how you can apply some of our learnings in your own organization.

Advanced Oracle Monitoring on Microsoft SCOM within Minutes

Monitor your Oracle databases, instances, tablespaces, pluggable databases, processes, system global area (SGA), clusters, automatic storage management (ASM), listeners, disk groups, and more within minutes. Discover Oracle objects automatically and track the overall health of your Oracle environment easily. Spot and act on Oracle latency issues as they appear. Generate detailed Oracle performance reports with a mouse-click. Use build-in Oracle tasks to speed up operations.