Database

The Difference Between Lock Wait Timeout and Deadlock

09/12/18 If you use ACID transactional databases, you’ve probably heard of lock wait timeouts and deadlocks. What are these? And how are they different? Inevitably, many of us will…

Databases 101 – Factors to Consider When Choosing a Database

09/06/18 In part one of this series, we discussed the different types of databases available on the market today. In part two, we discussed how to choose the right database for you…

The Hidden Costs of Backup Software

08/31/18 The focus of data protection has changed. Backups and data recovery used to exist primarily to protect against human error or natural disaster. The focus was on recovering…

Culture of Data Protection: What Your Customers Expect

08/23/18 We’ve talked about building a culture, why it applies to all data environments, and some specific types of data protection features you should be considering. Today, we’ll…

Databases 101: Choosing the Right Database

08/20/18 In my last post, we talked about the different types of databases available on the market for you to choose from. With over 300 options, it is hard to know which one is th…

Culture of Data Protection: Data Quality, Privacy, and Security

08/10/18 As I explained in previous posts on building a culture of data protection, we in the technology world must embrace data protection by design. To Reward, We Must Measure. H…

What Is Root Cause Analysis?

08/10/18 If you work in engineering or support, you’ve probably spent a lot of time troubleshooting things. You’ve probably spent just as much time trying to figure out why things …

Are Women in Technology Receiving Bad Advice?

08/08/18 IEEE ProComm 2018 Recently, I attended the IEEE ProComm 2018 conference in Toronto. I had the opportunity to hear about research and ideas involving professional communica…

What Is Cardinality in Monitoring?

07/30/18 I wrote a couple of “definitions and nuances” posts about terminology in databases recently (cardinality, selectivity), and today I want to write one about cardinality in …

What is Database Index Selectivity?

07/18/18 I wrote recently about database cardinality, and there’s a closely related topic that is equally confusing and I want to explain too: index selectivity. Index selectivity …

A Million Little Things: Strive for Greater Efficiency

07/13/18 OK, so a million is a little bit of an exaggeration, but there are tons of cool features inside our SentryOne solutions that I find a lot of our customers and evaluators d…

Five Common Problems with SQL Server

07/12/18 I am fortunate that I still work with SQL Server daily, and consulted from time to time on various projects and performance troubleshooting. It helps keep my skills sharp.…