Database

The Iron Triangle of Sorting, Indexing, and Temporary Storage

01/30/19 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. (The “iron…

What Is Concurrency in a Database?

01/28/19 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 multip…

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

01/24/19 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. Bu…

Your ORM and SELECT FOR UPDATE

01/23/19 What’s an ORM? If you’re not familiar with ORMs, an ORM is an Object-Relational Mapper, which helps you map objects in your code to tables in your database, without writin…

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

01/21/19 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 M…

Three Ways to Become Data-Centric

01/10/19 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 doe…

Quantum Computing Will Put Your Data at Risk

11/29/18 “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 m…

Why I’m Not Worried About Skynet

11/15/18 I’m 98% confident if you ask three data scientists to define Artificial Intelligence (AI), you will get five different answers. The field of AI research dates to the mid-1…

No, You Don’t Need a Blockchain

11/01/18 The hype around blockchain technology is reaching a fever pitch these days. Visit any tech conference and you’ll find more than a handful of vendors offering it in one for…

Don’t Get Bitten by Schrödinger’s Backup

11/01/18 There are two sayings you can find in virtually every article about data protection: “If your data doesn’t exist in at least two places, then it doesn’t exist,” and “If yo…

PostgresConf Silicon Valley

10/30/18 Did you miss us at PostgresConf Silicon Valley in San Jose? Have no fear! Here’s a sneak peek video of Baron Schwartz delivering his talk on database indexing: How to Inde…

Do You Need an On-Prem Storage Vault?

10/15/18 Data protection has traditionally involved an on-prem storage vault, but as data protection solutions evolve, this requirement is becoming increasingly optional. On-prem s…