Uli BethkeinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceBenchmarking Snowflake Native AppsAs a long time user of Snowflake we are impressed with the near unlimited scalability of the Snowflake Data Cloud.Nov 20, 2023Nov 20, 2023
Uli BethkeDeep dive on SQL parsing on TeradataThis is the sixth article in our series on parsing SQL in different database technologies and SQL dialects. We explored SQL parsing on…Oct 19, 20231Oct 19, 20231
Uli BethkeDeep dive on XML converters, XML conversion tools and XML conversion projectsAre you looking for an XML converter or XML conversion tool for enterprise use cases? Are you looking for advice and tips and tricks for an…Oct 19, 2023Oct 19, 2023
Uli BethkeinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceHow Snowflake EXCLUDE and ILIKE protects you from bad SQL. ILIKE it like that.One of the most common and impactful SQL anti patterns is the use of SELECT *. In this article we will explain what an SQL anti pattern is…Oct 1, 20232Oct 1, 20232
Uli BethkeAmazon Athena SQL parser for table and column audit loggingThis is the sixth article in our series on parsing SQL in different database technologies and SQL dialects. We explored SQL parsing on…Sep 29, 2023Sep 29, 2023
Uli BethkeSQL parser for Databricks. Parsing SQL for table audit logging and much moreThis is the fifth article in our series on parsing different SQL dialects. We explored SQL parsing on Snowflake, MS SQL Server, Oracle, and…Sep 29, 2023Sep 29, 2023
Uli BethkeParsing SQL queries in MS SQL ServerThis is the third article in our series on parsing SQL in different database technologies and SQL dialects. We explored SQL parsing on…Sep 29, 2023Sep 29, 2023
Uli BethkeBad SQL. SQL anti patterns in OUTER joinsYou often need to find both matched and unmatched rows between two or more tables. As we all know we use OUTER joins in SQL to achieve…Sep 29, 2023Sep 29, 2023
Uli BethkeFrom Code to Clarity: Visualizing SQL code for Documentation and DebuggingIn this post we will show you how you can create a visual diagram of your SQL code. We will use the FlowHigh SQL visualiser to achieve…Sep 29, 2023Sep 29, 2023
Uli BethkeParsing SQL queries in Redshift for table and column audit loggingThis is the fourth article in our series on parsing SQL in different database technologies and SQL dialects. We explored SQL parsing on…Sep 21, 2023Sep 21, 2023