SQL
-
Software Development
Lesser-Known SQL Features: DEFAULT VALUES
A lesser-known SQL feature is the DEFAULT keyword, which can be used in INSERT and UPDATE statements. Consider the following…
Read More » -
Software Development
Counting Distinct Records in SQL
The SQL language and its depths… Some of you readers might be aware of MySQL’s capability of counting distinct records…
Read More » -
Software Development
Add LATERAL Joins or CROSS APPLY to Your SQL Tool Chain
The T-SQL dialect has known the powerful CROSS APPLY and OUTER APPLY JOIN syntaxes for ages. The SQL:1999 standard had…
Read More » -
Software Development
Using SQL Injection Vulnerabilities to Dump Your Database
The threat caused by SQL injection is heavily underestimated even by many senior developers and software architects. Most people are…
Read More » -
Enterprise Java
Hibernate Facts: Always check Criteria API SQL queries
Criteria API is very useful for dynamically building queries, but that’s the only use case where I’d use it. Whenever…
Read More » -
Software Development
ID Lists Aren’t the Best Solution for the N+1 Problem
In their eternal attempts to circumvent the N+1 problem, Hibernate users often resort to IN predicates with ID lists. In…
Read More » -
Software Development
Why Staying in Control of Your SQL is so Important
Lots of blog posts and research papers are written about the topics of scaling up and scaling out. This interesting…
Read More » -
Software Development
SQL Trick: row_number() is to SELECT what dense_rank() is to SELECT DISTINCT
The SQL:2003 standard ranking functions are awesome companions and useful tools every now and then. The ones that are supported in…
Read More » -
Software Development
The 10 Most Popular DB Engines (SQL and NoSQL)
How to objectively measure the popularity of a DB engine? Good question! And there’s an Austrian company (Solid IT) who…
Read More »
