SQL
-
Software Development
All You Ever Need to Know About Recursive SQL
Oracle SYNONYMs are a great feature. You can implement all sorts of backwards-compatibility tweaks simply by creating SYNONYMs in your…
Read More » -
Software Development
SQL Tip of the Day: Be Wary of SELECT COUNT(*)
Recently, I’ve encountered this sort of query all over the place at a customer site: …
Read More » -
Software Development
Are You Using SQL PIVOT Yet? You Should!
Every once in a while, we run into these rare SQL issues where we’d like to do something that seems…
Read More » -
Enterprise Java
Tracing SQL statements in JBoss AS 7 using a custom logging handler
Using an ORM to abstract from your specific database and to let it create and issue all the SQL statements…
Read More » -
Enterprise Java
Stop Trying to Emulate SQL OFFSET Pagination with Your In-House DB Framework!
I’m pretty sure you’ve gotten it wrong in numerous ways, so far. And you probably won’t get it right any…
Read More » -
Software Development
Java 8 Friday: JavaScript goes SQL with Nashorn and jOOQ
At Data Geekery, we love Java. And as we’re really into jOOQ’s fluent API and query DSL, we’re absolutely thrilled…
Read More » -
Software Development
Yet Another 10 Common Mistakes Java Developers Make When Writing SQL (You Won’t BELIEVE the Last One)
(Sorry for that click-bait heading. Couldn’t resist!) We’re on a mission. To teach you SQL. But mostly, we want to…
Read More » -
Software Development
Time to break free from the SQL-92 mindset
Are you stuck in the 90s? If you are only using the SQL-92 language reference, then you are overlooking so…
Read More » -
Software Development
The Index You’ve Added is Useless. Why?
Recently, at the office: Bob: I’ve looked into that slow query you’ve told me about yesterday, Alice. I’ve added the…
Read More »