Database

Latest Posts in Database

Assessing Database Health and Performance

Here is an interesting article from my colleague Joe Kim, in which he explores database health and performance. Part of the problem with managing databases is that many people consider…

Numeric Optimization in Golang With Nelder-Mead and Gonum

Numeric optimization is a set of techniques for fitting a function to a dataset by iteratively refining estimates. Numeric optimization is one way to do things like curve-fitting and parametric…

Disaster Recovery – Time To Create Our Plan!

Thus far, we have gone over how to classify our disasters and how to have some of those difficult conversations with our organization regarding Disaster Recovery (DR). We’ve also briefly…

Announcement: p99 Percentile Metrics

I’m pleased to announce that SolarWinds® Database Performance Monitor (DPM) offers 99th percentile metrics to help understand latency outliers in a query workload. These metrics provide visibility beyond the average…

How To Buy Software 2018

Buying software solutions for your company is a skill just like any other business practice. To be effective at purchasing it is necessary to have a clear understanding of what…

Traveling With Joy

Recently, two people I respect very much tweeted about travel, and how to remain positive and grateful while you do it. You can read those tweets (here) and (here). When…

Business Continuity – DR Is Really just a Piece of a Much Bigger Cake!

All too often, especially if disaster recovery (DR) is driven and pushed by the IT department, organizations can fall into the common mistake of assuming that they are “good to…

T-SQL Tuesday #99: Missing Indexes and Index Key Order

Welcome to the 99th edition of T-SQL Tuesday, hosted this month by friend (and coworker) Aaron Bertrand. We were given a choice and I decided to dive into Aaron’s Index…

Before Choosing a Technical Disaster Recovery Solution

Getting right into the technical nitty-gritty of the Disaster Recovery (DR) plan is probably my favorite part of the whole process. I mean, as an IT professional this is our…

Setting Up Multi-Factor Authentication With the AWS CLI

As part of achieving SOC-2 certification, we had to implement stricter requirements around AWS authentication. Database Performance Monitor has had multi-factor authentication (MFA) for access to the AWS web-app console…