A Fine Slice Of SQL Server
Paul Hernandez gets Inspector Cluseau’d:
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.
Comments closedKevin Wilkie puts on the flannel and grabs his database lumberjack axe to split some strings:
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.
Lukas Eder hits on an interesting data point:
I’ve found an interesting question on Twitter, recently. Is there any performance impact of using
FILTERin SQL (PostgreSQL, specifically), or is it just syntax sugar for aCASEexpression 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.
Comments closedKevin Chant deploys some database objects:
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.
Comments closedImke Feldmann has a clever solution to a problem:
When you reference another query in Power Query you will automatically get the results of the final step. But what if you want to reference a step that sits within that referenced query?
One solution would be to split up that query into 2 and reference the final result of the splitted query. But that could result in additional query time, as the data might be pulled from the source twice (once for each query).
Read on for a better way to do it.
Comments closedJohn MacKintosh troubleshoots an issue:
I recently updated my R installation, and then realised that I’d broken my VSCode/ R set up in the process – I could not launch an R terminal either directly or via radian.
I have a repo where I’ve collated various blog posts relating to setting up VSCode for R, but that didn’t solve all my problems.
I did get it resolved eventually, and here’s how.
Read on for that resolution. H/T R-Bloggers.
Comments closedSteven P. Sanderson provides an overview of an R package:
If you’re looking for an easy-to-use package to calculate cumulative statistics in R, you may want to check out the TidyDensity package. This package offers several functions to calculate cumulative measurements, including mean, median, standard deviation, variance, skewness, kurtosis, harmonic mean, and geometric mean.
Click through for a quick description of each function, as well as examples of each. H/T R-Bloggers.
Comments closedRobert Cain continues a series on KQL:
In my previous post, Fun With KQL – Max, MaxIf, Min and MinIf, we looked at the aggregation functions
maxandmin. In this post we’ll talk about another aggregation function,sum. We’ll also look at a variant of it,sumif.
Check out the details and examples in Robert’s post.
Comments closedPatrick Gruenauer counts the ways:
The enum statement can be used to declare an enumeration. Microsoft describes this statement as follows:
The
enumstatement allows you to create a strongly typed set of labels. That enumeration can be used in the code without having to parse or check for spelling errors.
Click through for more description, as well as an example of how to create, instantiate, and operate on enumerations.
Comments closedNicholas Xuan Nguyen doesn’t just echo to the screen:
The PowerShell
Write-Outputcmdlet writes objects to the output stream and displays the output of a command or message in the console. But you will be surprised how this tool makes the output more meaningful and valuable.
Read on to see what you can do with the cmdlet and why it’s better than Write-Host.