I like the image of the city of Mesa Verde. It’s fascinating to see how ancient cities were built, especially as an inhabitant of one of the world’s largest cities today, New York. I’m a long-time relational database guy. I worked at scores of dot-coms in the 90’s as an old-guard Oracle DBA, and pivoted…
SQL is derided by many and for good reason. It’s key to scalability yet terribly difficult to write good code. You can write tighter queries in MySQL easily by following 3 simple tricks – SUBQUERIES, UNION, and PAGING. In this article, we will explain all these patterns to write MySQL codes more efficiently. 3 Best…
In the realm of database management and development, optimizing SQL performance is a perennial challenge. If you’re looking to up your SQL performance tuning game, Markus Winand’s book “SQL Performance Explained” is a must-have in your arsenal. It’s become the go-to resource for understanding and mastering all things SQL performance. Let’s explore the five great…
Deploying new code that includes changes to your database schema doesn’t have to be a process fraught with stress and burned fingers. For better database change management, you need to be a little bit tricky. You can make it more efficient by deploying roll forward and rollback scripts, performing backups, reviewing tests, and much more….
MySQL replication technology is powerful and flexible. But it doesn’t do everything perfectly all the time. You may experience trouble with the slaves falling behind the master or want to scale horizontally by building new slaves automatically. Or you might need to build a slave without blocking the master database. All of these goals can…
MySQL databases are great workhorses of the internet. They back tons of modern websites, from blogs and checkout carts to huge sites like Facebook. But these technologies don’t run themselves. When you’re faced with a system that is slowing down, you’ll need the right tools to diagnose and troubleshoot the problem. MySQL has a huge community following…
While working with database operations, it is common to face a variety of errors. But when the error occurs, it gives us a lot of pain in the head. Fortunately, there are some tricks to avoid these troubles in database operations. So, why you should face trouble when you have options in your hand to…
Everyone is hot under the collar again. So-called serverless or no-ops services are popping up everywhere allowing you to deploy “just code” into the cloud. Not only won’t you have to login to a server, you won’t even have to know they’re there. In this guide, I’m going to provide you with 30 questions that…
So, you’ve been tasked with managing the MySQL databases in your environment, but you’re not sure where to start. Here’s the quick & dirty guide. Oh yeah, and for those who love our stuff, take a look to your right. See that subscribe button? Grab our newsletter! Steps to MySQL Management Here are the steps that…
I like that this book is small; 150 pages means you can carry it easily. It’s also very no-nonsense. It does not dig too deeply into theory unless it directly relates to your day-to-day needs. And those needs probably cluster heavily around optimizing SQL queries, as those pesky developers are always breaking things Jokes aside,…