Database

Latest Posts in Database

3 Perspectives on Technical Interviews for 2020

Technology work is very progressive. Rapid progress drives the industry to constantly learn new ways to meet objectives and innovate. A ubiquitous theme is that we keep up to avoid…

Database 102 – Why Is My Query Slow?

As a database administrator (aka DBA, or Default Blame Acceptor) throughout my career, I’ve worked with a myriad of developers, system administrators, and business users who have all had the…

Calculating the ROI of SQL Server Monitoring

I was recently approached to help develop our latest online version of a Return On Investment (ROI) calculator for the SentryOne monitoring platform. We know the ROI of our monitoring solution is excellent, based…

Why Machine Learning Matters

While there are many silly depictions of machine learning and artificial intelligence throughout Hollywood, its reality delivers significant benefits. Administrators today oversee so many tasks, like system monitoring, performance optimizing,…

MySQL Query Performance Statistics In The Performance Schema

Quite some time ago, when we added the ability to monitor MySQL query performance statistics from MySQL’s PERFORMANCE_SCHEMA, we learned a number of valuable lessons, still worth sharing. There are definitely right…

How AI Is Transforming the Data Center

There have been so many changes in data center technology in the past 10 years, it’s hard to keep up at times. We’ve gone from a traditional server/storage/networking stack with…

What Is Cardinality in a Database?

Databases have a lot of jargon, and cardinality is one of those words experienced people tend to forget they didn’t know once upon a time. But if you don’t know it—and it…

A Quick Look at Parallel Rsync and How it Can Save a System Hours

In this post, we’ll take a quick look at rsync (“remote sync”) and parallel rysnc—a way to increase the efficiency and speed of traditional rsync—both of which can be effective…

Reducing SolarWinds DPM’s Agent Overhead With Partial Network Capture

SolarWinds Database Performance Monitor (DPM) now supports partial network capture to reduce load while monitoring MySQL database servers, where a trade-off between full visibility and monitoring overhead might be desirable.…

What Is MongoDB’s _id Field and How to Use It

The MongoDB _id field is fundamental to every collection in MongoDB, and, by default, it has some useful properties users can take advantage of when familiar with how _id is…