There are plenty of ways that apps can unintentionally misuse databases. When the abuses are pervasive, you can catch them by means of a few deft queries on various DMOs.
Window functions and CTEs have been a mainstay of many popular DB products for some time now. With the release of MySQL v8 and MariaDB 10.2.0, both vendors have caught up with competing DBMSes.
Monitoring your resources is vital to being able to detect issues or opportunities for performance improvements. When it comes to Azure the monitoring story ...
Where do you begin in choosing a database? We've looked at both NoSQL and relational database management systems to come up with a bird's eye view of both ecosystems to get you started.