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.
Java 8 and streams: A match made in heaven, but it can be a little overwhelming. In this post, we take an in-depth look at this combination with some examples.
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.
Looking for a new editor or communication tool for your agile-based web development team? Read on for a discussion of some of the best tools out there.
Learn about Teradata SQL Analyzer, a utility framework to discover processing flows in SQL scripts, find inter-table dependencies, and convert them to ANSI-SQL standards.