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.
The SOLID design principles can be a little tricky to get your head around. In this post, we dive into the S in SOLID - the Single Responsibility Principle.
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.
Monitoring your resources is vital to being able to detect issues or opportunities for performance improvements. When it comes to Azure the monitoring story ...
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.