Database

Announcement: p99 Percentile Metrics

03/01/18 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 m…

How To Buy Software 2018

02/26/18 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…

Traveling With Joy

02/26/18 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 I…

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

02/20/18 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 “go…

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

02/13/18 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 of…

Before Choosing a Technical Disaster Recovery Solution

02/07/18 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 o…

Setting Up Multi-Factor Authentication With the AWS CLI

01/29/18 As part of achieving SOC-2 certification, we had to implement stricter requirements around AWS authentication. Database Performance Monitor has had multi-factor authentica…

It’s Inevitable. Your Database Will Fail

01/23/18 Databases fail. No one can promise 100% uptime, it’s impossible. Whether the database is large, small, on-premise or cloud-based, all have the potential to fail. This coul…

Slow Queries? Move Fast to Fix Them

01/17/18 What Are the Effects of Slow Queries? Slow queries can have serious negative impacts on your business. The impacts will vary depending on your architecture, industry, or a…

2017 Year in Review for SolarWinds Database Performance Monitor

01/04/18 It’s easy to observe (pun intended) in the rear-view mirror. Hindsight bias aside, 2017 was a big year for SolarWinds Database Performance Monitor (DPM) and our customers!…

Top 7 Things Every DBA Should Do Before They Go On Holiday

12/19/17 Everybody wants to take a relaxing holiday from time to time, whether you are a veteran DBA standing watch over million dollar mission-critical database systems or a jack-…

The Future is Always Bright

12/15/17 In my last couple of posts, I’ve tried to paint a picture of the past and present of database management and monitoring. We’ve seen that good database performance has ever…