Six years of blogging
Quality over quantity I’ve been blogging for six years already, and every year I like to write a report with the achievements I’ve made over the last year. If you are curious about my previous reports, check out the following list: 2018 2017 2016 2015 2014 Page Views In 2019, I got around 10,547 daily page views, meaning that this year, I’ll get over 3.85 million page views. That’s a 22% traffic increase since 2018. Overall, in these six years of blogging, I got over 8.8 million page views and 4.5 million… Read More
How to get the query execution plan on SQL Server
Introduction In this article, we are going to see how we can get the query execution plan when using the SQL Server relational database system. The execution plan allows you to understand the operations done by the database engine when executing a specific SQL query.
How to map Oracle JSON columns using JPA and Hibernate
Introduction In this article, we are going to see how to map the Oracle JSON column storage types when using JPA and Hibernate. The Hypersistence Utils project provides a generic JsonType that works with Oracle, SQL Server, PostgreSQL, and MySQL, and it can even use the columnDefinition attribute of the JPA @Column annotation to determine the underlying database column type.
How to write a compact DTO projection query with JPA
Introduction In this article, we are going to see how we can write the best DTO projection JPQL query by omitting the package name when using JPA, Hibernate, and Spring. As I already explained, DTO projections are the most efficient way of fetching data when using JPA and Hibernate.
How to get the SQL execution plan on Oracle
Introduction In this article, we are going to see how we can get the SQL execution plan on Oracle. When tuning performance, the execution plan is indispensable as it allows you to understand the operations done by the database when executing a certain SQL query.