Splitting tests using JUnit Tags

Splitting tests using JUnit Tags

Grouping together tests can help you to parallelize your integration tests and make your build times fas...

TIL - Comparing Strings with trailing spaces using TSQL

TIL - Comparing Strings with trailing spaces using TSQL

I set off down this path of enlightenment as I investigated a customer issue that “could never happen”...

Automate away your N+1 problems with Hibernate Statistics

Automate away your N+1 problems with Hibernate Statistics

If you are using an ORM in your projects, The N+1 query problem is definitely one of your issues. If you...

Introduction to Indexes, and the Primary Key

Introduction to Indexes, and the Primary Key

Database indexing is a development task. The most important information for indexing is not the storage...

Fixing the N+1 query problem

Fixing the N+1 query problem

In an earlier blog post, I touched upon the cardinal sin of performance issues - N+1 queries. In this b...

Why (and how) I moved to GatsbyJS

Why (and how) I moved to GatsbyJS

Honestly - the main reason I chose to move away from WordPress and to GatsbyJS wasn't to upskill in the...

How to introduce a Cartesian Product into your generated queries

How to introduce a Cartesian Product into your generated queries

When working with an ORM, it is essential that you inspect your generated queries. Often when doing so...

Activate Hibernate Query Statistics to investigate your performance issues

Activate Hibernate Query Statistics to investigate your performance issues

Often, you may find yourself wondering why application performance has degraded – and almost always that...

Improve query caching with IN clause padding

Improve query caching with IN clause padding

In my experience, the number one cause of application performance problems is not your application code...