From the browser to the back end, the ‘boring’ choice is exciting again. We look at three trends converging to bring SQL back ...

Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types. Datetimes and intervals are ...

Hadoop has introduced a lot of agility into the world of analytics and data integration. Concepts such as schema on read and the radical flexibility of processing data stored in files have allowed ...

For those of you still using SQL Server 2005, Microsoft will completely end support on April 12th 2016. You can head over here to check out upgrade guidelines, download migration tools, and read more ...

SQL Window functions are an advanced type of function in SQL. In this post, you will learn about what SQL window functions are and how they can be used or work. What are SQL window functions? SQL ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...