Database

Software industry leaders have been trying to define what DevOps is forever. Most top firms say they’re committed to a holistic DevOps philosophy and they’re trying to put it to…

The signs that the Illuminati exist are all around us. You can find their marking on our buildings, on our currency, and even in our music videos. The Illuminati thrive…

A Historical Account of the Professional Association of SQL Server (PASS) Lately, I’ve been asked many questions about the history and foundation of PASS. As an “old-timer”, I like to…

We’ve completely revised one of our most popular free ebooks, How to Architect and Build Highly Observable Systems. This book, originally written in 2015, has been downloaded by thousands of…

A Guest Post from Jordan Raine, Clio Jordan Raine is a staff software developer at Clio, the leading provider of legal practice management, client relationship management, and client intake software.…

Last week several people from SolarWinds® traveled to attend DevOpsDays Charlotte, where I gave the opening keynote, we had a table to demonstrate our product, we caught up with friends…

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…

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…

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…

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.…