SQL Parsing for PostgreSQL Table and Column Audit Logging

PostgreSQL, or Postgres, is an open-source object-relational database system known for its reliability, data integrity, and robust features. It offers advanced data types, comprehensive extensibility, and strong community support. Its…
Uli Bethke December 8, 2023

Mastering SQL: How to detect and avoid 34+ Common SQL Antipatterns

Overview Are you looking for reasons why your SQL queries are slow or costly. Look no more. This blog post showcases a comprehensive list of 34 SQL antipatterns. Use it…
Uli Bethke December 6, 2023

Benchmarking Snowflake Native Apps

As a long time user of Snowflake we are impressed with the near unlimited scalability of the Snowflake Data Cloud. We were wondering if the same scalability and performance magic…
Uli Bethke November 20, 2023

SQL Challenge: Tackling the Island Problem in Time Series Data

Jump into our SQL Challenge! Today, we're exploring customer loyalty trends. Are you prepared to show off your SQL skills? About the quiz In this SQL pop quiz, we're challenging…
Uli Bethke November 7, 2023

Deep dive on SQL parsing on Teradata

This is the sixth article in our series on parsing SQL in different database technologies and SQL dialects. We explored SQL parsing on Snowflake, MS SQL Server, Oracle , Databricks…
Uli Bethke October 19, 2023

AWS Athena SQL parser for table and column audit logging

This is the sixth article in our series on parsing SQL in different database technologies and SQL dialects. We explored SQL parsing on Snowflake, MS SQL Server, Oracle , Databricks…
Uli Bethke September 29, 2023
spinner