/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

36chambers.wordpress.com
| | boringsql.com
2.8 parsecs away

Travel
| | Unlock powerful data analysis in PostgreSQL with window functions. Go beyond aggregates to rank, calculate running totals, and compare rows directly within your queries.
| | michaelerasm.us
2.4 parsecs away

Travel
| | One of the coolest things I learned about in my Redshift journey has been Window Functions. Although Window functions aren’t a novel feature and exists in other SQL databases, they are a ...
| | barneylawrence.com
2.7 parsecs away

Travel
| | FIRST_VALUE and LAST_VALUE had limited uses when they were first released to the world back in 2012, but with the introduced of the ability to ignore nulls in SQL Server 2022 they become a lot more useful. Let's take a look at some examples of why.
| | mrpaulandrew.com
28.3 parsecs away

Travel
| A tool I've used in the past to query my local disk drives is WinDirStat. It's great for finding out where large files are hiding in your directories using a heat map visual. In this post I talk you through how I've created a similar tool for Azure Data Lake Store using PowerShell, SQL Server...