Filter window results without QUALIFY using CTEs and derived tables, compare TOP WITH TIES, and preserve partition and tie rules.
Snowflake – Query Result from Cache or Disk
Comprehensive Database Performance Health Check, The topic is how to identify on the Snowflake platform if the query result is from cache or disk.
Snowflake JavaScript Procedure: A Stored Procedure Template
A Snowflake JavaScript procedure wraps SQL statements in JavaScript code. This post gives a clean template, shows how to call it, read a result, pass an argument and catch an error. The code follows Snowflake’s documented API and was not run on a Snowflake account.
SQL SERVER Agent Missing from SSMS
Agent XPs can explain why SQL Server Agent is Missing from SSMS. I check edition and service state before changing configuration.
Shredding JSON Into Relational Tables in One Pass
Use shredding JSON to stage parent and child rows, validate their data, capture identity mappings, and load relational tables atomically.
PostgreSQL – Definition of a Materialized View
pg_matviews lists each PostgreSQL Materialized View and its reconstructed SELECT definition. A cross-platform customer requested this metadata.
SQL SERVER – Last 5 SQL in Sixty Seconds Video
Today I am going to share the last 5 SQL in Sixty Seconds videos with you all. Please let me know which of the last 5 you find the most interesting and why?