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 ...

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

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 ...

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 ...

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 ...