sql 15
- How I halved the runtime of my PostgreSQL dbt model using DuckDB
- My favourite papers on columnar databases
- Introduction to PostgreSQL High availability with pg_auto_failover
- My articles for Sonra Intelligence
- Loading Data into Snowflake Data Warehouse and performance of joins
- My favorite features of Snowflake Data Warehouse
- Caching in Snowflake Data Warehouse
- Using Spark Structured Streaming to upsert Kafka messages into a database
- Clustering keys Snowflake
- Advanced Spark Structured Streaming - Aggregations, Joins, Checkpointing
- Writing UDAFs on Snowflake
- Window Functions on Snowflake
- Windows functions in PostgresQL
- T-SQL Window functions syntax
- SQL Server Security Basics - Logins and Users