Database

Latest Posts in Database

Six Ways to Protect your Database Backups

I often see forum posts from accidental administrators who want to know how to recover data without a backup. The short answer is, “Now is a good time to work…

Be Responsive and Responsible

Over the years, I’ve read more than a few articles about the qualities that are found in the best administrators. These articles focus on soft skills, but sometimes will list…

How DevOps Changes Monitoring

One of the most interesting changes that I have observed in my career is Microsoft shifting from just being a development organization to truly becoming a DevOps team, in the…

The Future Isn’t in Databases, But in the Data

In the past year I have earned a couple of certificates from the Microsoft Professional Program. One certificate was in Data Science, the other in Big Data. I’m currently working…

Monitor Critical Databases Confidently with the Sensitive Data Vault

Building extremely deep monitoring as a SaaS product has a drawback: we capture too much data for some customers’ compliance requirements. As a result, some companies have been unable to…

New Stats Exposed in Go’s database/SQL Package

If you keep up with the Go development cycle, then you’ll know Go recently entered its feature-freeze for the Go 1.11 release. One of the changes for this upcoming release…

The High Cost and Low Benefit of Unused Index Advice

You have to be careful what you wish for. The signal:noise ratio of finding out which indexes are “unused” is low. This isn’t obvious at first glance, but upon deeper…

How to Select the Right Queries to Optimize

Why is selecting the right queries to optimize so important? There are several reasons. Penny-Wise, Pound-Foolish  Look at the forest, not just the trees, and optimize globally, not locally. If…

Cognitive Bias in IT Decision Making

Logic and objective thinking are hallmarks of any engineering field. IT design and troubleshooting are no exceptions. Computers and networks are systems of logic so we, as humans, have to…

The Impact Of Coupling On System Design

In system design, every technical decision can be seen as a series of trade-offs. If I choose to implement Technology A it will provide a positive outcome in one way,…