Home » Tag Archives: SQL

Tag Archives: SQL

Do Not Make This Mistake When Developing an SPI

java-interview-questions-answers

Most of your code is private, internal, proprietary, and will never be exposed to public. If that’s the case, you can relax – you can refactor all of your mistakes, including those that incur breaking API changes. If you’re maintining public API, however, that’s not the case. If you’re maintaining public SPI (Service Provider Interfaces), then things get even worse. ...

Read More »

How to use SQL PIVOT to Compare Two Tables in Your Database

software-development-2-logo

This can happen ever so easily. You adapt a table by adding a new column:                     ALTER TABLE payments ADD code NUMBER(3); You go on, implementing your business logic – absolutely no problem. But then, later on (perhaps in production), some batch job fails because it makes some strong assumptions about ...

Read More »

How to Extract a Date Part in SQL

software-development-2-logo

The Modern SQL Twitter account (by Markus Winand) published a hint about how to extract a date part in SQL:                     The right way to get a part of a date/time is: EXTRACT(YEAR FROM CURRENT_DATE) = 2015 http://t.co/UNLyUoQdVb Retweet to spread the word! — Modern SQL (@ModernSQL) February 24, 2015 Is it true? Yes ...

Read More »

10 SQL Articles Everyone Must Read

software-development-2-logo

We’ve been blogging about Java and SQL for a while now, on the jOOQ blog. Over the years, while researching interesting blog topics, we’ve discovered a lot of SQL gems in the blogosphere that have inspired our work and our passion for SQL. Today, we’re presenting to you a list of 10 articles that we think you should absolutely read. ...

Read More »

Still Using Windows 3.1? So why stick to SQL-92?

software-development-2-logo

We’ve been blogging a lot about the merits of modern SQL on the jOOQ blog. Specifically, window functions are one of the most fascinating features. But there are many many others. Markus Winand, author of the popular book SQL Performance Explained has recently given a very well-researched talk about modern SQL. We particularly like his headline:         ...

Read More »
Do you want to know how to develop your skillset and become a ...

Subscribe to our newsletter to start Rocking right now!

To get you started we give you our best selling eBooks for FREE!
Get ready to Rock!
To download the books, please verify your email address by following the instructions found on the email we just sent you.

THANK YOU!

Close