SQL
-
Software Development
10 More Common Mistakes Java Developers Make when Writing SQL
I was positively surprised to see how popular my recent listing about 10 Common Mistakes Java Developers Make when Writing SQL was, both…
Read More » -
Software Development
10 Common Mistakes Java Developers Make when Writing SQL
Java developers mix object-oriented thinking with imperative thinking, depending on their levels of: Skill (anyone can code imperatively) Dogma (some…
Read More » -
Groovy
Logging Hibernate SQL
There are two well-known ways to log Hibernate SQL in Grails; one is to add logSql = true in DataSource.groovy…
Read More » -
Software Development
SQL tooling, the ranking
When you need to get up and running quickly with your database, the tooling becomes very important. When developing jOOQ…
Read More » -
Core Java
Arcane magic with the SQL:2003 MERGE statement
Every now and then, we feel awkward about having to distinguish INSERT from UPDATE for any of the following reasons:…
Read More » -
Core Java
GROUP BY ROLLUP / CUBE
Every now and then, you come across a requirement that will bring you to your SQL limits. Many of us…
Read More » -
Software Development
Add APPLY to Your TSQL Tool Belt
Every once in a while I stumble across some SQL keyword that I didn’t really know about, but is extremely…
Read More »
