# Day: February 8, 2023

Suppose you are trying to approximate some number x and you’ve got it sandwiched between two rational numbers:

a/b < x < c/d.

Now you’d like a better approximation. What would you do?

The obvious approach would be to take the average of a/b and c/d. That’s fine, except it could be a fair amount of work if you’re doing this in your head.

Read on for a separate approach taking the mediant (not median) of the two fractions.

The post is a little too terse to grab a lede from, but it does show a good way of generating a formatted image of a table using the ggplot2 library in R.

The Kusto Detective Agency was created last year (2022) to let people learn KQL solving funny puzzles at the same time. For me it has been a kind of scape room game, where you can exercise your solving problem capabilities and learn ADX at the same time. If you want to participate just follow this link

Click through for the scenario which got Paul.

But, sometimes, you want a small list of data inherent to a query in SnowFlake. And that’s what I want to talk about today.

In SQL Server, you would create a temp table and then insert the data into it. But in Snowflake, there may be a better / easier way.

Let’s use the function SPLIT_TO_TABLE. Shockingly, it does what’s on the label – it split data and puts it into a table.

Click through for an example. Also check out the Snowflake documentation, where they make use of the `lateral` operator (the ANSI version of `APPLY()`) to generate results for multiple strings and make use of the `SEQ` column.

I’ve found an interesting question on Twitter, recently. Is there any performance impact of using `FILTER` in SQL (PostgreSQL, specifically), or is it just syntax sugar for a `CASE` expression in an aggregate function?

Click through for the answer and your daily reminder that SQL variants aren’t pure fourth generation languages—if they were, the optimizer would take all possible constructs of a given desired operation and generate the same execution plan for all of them.

In this post I want to cover using Azure SQL Deploy v2 for dedicated SQL Pool deployments using GitHub Actions. Which is the GitHub Action that is also known as sql-action.

This post provides an overview of what is new and provides plenty of links along the way.

Check out what’s new and the way Kevin handles the deployment.