/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
A Slice of Time: Good Use Cases - 36 Chambers - The Legendary Journeys: Execution to the max!
| | boringsql.com
Gentle Introduction to Window Functions in PostgreSQL | boringSQL
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
Window Functions in Redshift
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
T-SQL Tuesday #168 - FIRST_VALUE, LAST_VALUE and NULL Handling - Barney Lawrence - A Blog
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
Azure Data Lake Store - Files Dashboard - Welcome to the Blog of Paul Andrew
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...