When non-DBAs think about what it is that a DBA does, performance monitoring and tuning are usually the first tasks that come to mind. This should not be surprising. Almost anyone who has come in ...

Artificial Intelligence (AI) and Machine Learning (ML) are increasingly integral to database management, driving new levels of automation and intelligence in how data systems are administered. Modern ...

Regular readers know that I periodically discuss database performance issues and that I always like to start with a definition of database performance, that I will reiterate here: If you need ...

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...