(Itzik Ben-Gan) The ISO/IEC 9075:2016 standard (SQL:2016) defines a feature called nested window functions.
Other News
Top Modern Data Warehouse questions
(James Serra) Below are the top 15 questions I am seeing from customers looking to build a modern data warehouse in the cloud, and the blogs that I have wrote that try to answer each question (I have updated most of these blogs):
IBM Spectrum Discover: Metadata Management for Deep Insight of Unstructured Storage
(Joseph Dain, Norman Bogard, Isom Crawford Jr., Mathias Defiebre and Larry Coyne) This IBM Redpaper publication provides a comprehensive overview of the IBM Spectrum Discover metadata management software platform. We give a detailed explanation of how the product creates, collects, and analyzes meta
Adding Reaction Gifs for your Build System and the Windows Terminal
(Scott Hanselman) So, first, I’m having entirely too much fun with the new open source Windows Terminal. If you’ve got the latest version of Windows (go run Windows Update and do whatever it takes) then you can download the Windows Terminal from the Microsoft Store!
Split a Concatenated String with a Delimiter
(Srinath M S) Here is how to split a concatenated string with a delimiter and remove empty entries.
JavaScript Proxy with Storage
(David Walsh) The JavaScript Proxy API provides a wealth of “magic” within JavaScript, allowing you to use any object as sort of an alias that allows a wall of validation, formatting, and error throwing.
Rails Geocoder: A Guide to Managing Locations in Your Apps
(Eric Boersma) The introduction of Google Maps in 2005 changed the way we think about the internet. It’s hard to remember now, but there was a time where the internet was disconnected from the physical world. You
Exposing MyRocks Internals Via System Variables: Part 7, Use Case Considerations
(Peter Sylvester) In this final blog post, we conclude our series of exploring MyRocks by taking a look at use case considerations.
Missing cents when dividing an amount
(stewashton) Alex Nuijten (@alexnuijten) wrote a blog post on this subject a few years ago. Since his blog doesn’t accept comments at the moment, here is a variant I think is interesting.
Prevent crontab jobs overlapping using flock
(Zahid Anwar) As an Oracle DBA, you may find yourself in the situation where you have crontab jobs overlapping.