Category: Database


author:

Database

Outcomes From Home

April 17, 2020

This post is not meant to be a typical “here’s how you work from home” post. This is not a post about routines, habits, equipment, or if you should shower before noon. No, this post is meant to offer my perspective about work, productivity, …






author:

Database

Database 102 – Why Is My Query Slow?

February 14, 2020

As a database administrator (aka DBA, or Default Blame Acceptor) throughout my career, I’ve worked with a myriad of developers, system administrators, and business users who have all had the same question—why is my query (or application) slow? Many organizations lack a full-time DBA, …


author:

Database

Why Machine Learning Matters

January 20, 2020

While there are many silly depictions of machine learning and artificial intelligence throughout Hollywood, its reality delivers significant benefits. Administrators today oversee so many tasks, like system monitoring, performance optimizing, networking configuration, and more. Many of these tasks can be monotonous and tedious. Also, …


reporting vs analysis difference

author:

Database

MySQL Query Performance Statistics In The Performance Schema

January 12, 2020

Quite some time ago, when we added the ability to monitor MySQL query performance statistics from MySQL’s PERFORMANCE_SCHEMA, we learned a number of valuable lessons, still worth sharing. There are definitely right and wrong ways to do it. If you are looking to the P_S tables …


author:

Database

How AI Is Transforming the Data Center

January 10, 2020

There have been so many changes in data center technology in the past 10 years, it’s hard to keep up at times. We’ve gone from a traditional server/storage/networking stack with individual components, to a hyperconverged infrastructure (HCI) where it’s all in one box. The …