Database

Latest Posts in Database

Inspecting Index Usage In MySQL, PostgreSQL, and MongoDB

In my recent post about the Left-Prefix Index Rule, I explained how queries can use all or part of a compound (multi-column) index. Knowing what makes an index fully usable…

The Left-Prefix Index Rule

There’s an important heuristic in database indexing that I call the left-prefix rule. It helps you understand whether the database will be able to make the best use of a…

Covering Indexes in MySQL, PostgreSQL, and MongoDB

A covering index is a fantastic query performance optimization. An index covers a query when the index has all the data needed to execute the query, so the server can…

The Iron Triangle of Sorting, Indexing, and Temporary Storage

Databases have a kind of iron triangle for specific types of query plans, whereby they can pick between two out of three things but can’t get all three of them.…

What Is Concurrency in a Database?

Databases are confusing! Not only are they complicated bits of software, but database jargon is really complicated. Part of this comes from the number of words with multiple meanings: depending…

How to Clean Dirty Data – The Life of a Data Janitor

If there’s one thing I’ve learned in my decades as a data professional, it’s this: Things aren’t what you think they are. Data’s ultimate purpose is to drive decisions. But our…

Your ORM and SELECT FOR UPDATE

If you use a programming language framework such as Django or Ruby on Rails, chances are you use an ORM to help you construct queries. What’s an ORM? If you’re…

SolarWinds Lab Episode 72: Two Geeks and a Goddess II: Azure the Easy Way

IT pros are discovering a smarter way to manage servers.​ In this episode, Microsoft Cloud advocate Phoummala Schmitt (@ExchangeGoddess), Head Geek™ and 10-year Microsoft MVP Thomas LaRock, and Head Geek…

Three Ways to Become Data-Centric

The conservation of quantum information is a theory that information can neither be created nor destroyed. Stephen Hawking used this theory to explain how a black hole does not consume…

Quantum Computing Will Put Your Data at Risk

“Too many secrets.” – Martin Bishop One of the pivotal moments in the movie Sneakers is when Martin Bishop realizes that they have a device that can break any encryption…