A Fine Slice Of SQL Server
Robert 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.
Leave a CommentAnshika Agrawal shows a few examples of how Scala 3 is a bit easier to pick up than Scala 2:
Scala 3 is a remodel/refit for the scala language. It attracts developers due to its improved features such as simpler syntax, better type inference, improved error messages, and enhanced support for functional programming. In this article, we will compare the syntactical enhancement of Scala 2 & Scala 3. How indentation will help developers to write code efficiently and effortlessly.
Click through for some examples. On the whole, these are small but welcome changes in eliminating unnecessary code cruft.
Leave a CommentIn Snowflake, there is another function that is SOUNDEX-like that can give slightly different results – SOUNDEX_P123.
For those cases where the first and second letters of the string have the same SOUNDEX number, the SOUNDEX_P123 function will keep the number for the second letter. This variant is used in a few other database systems, for example, Teradata.
Click through for a demonstration of the two SOUNDEX() variants and how results can differ.
Deborah Melkin riddles us this on dynamic SQL:
I admit it – I do waaayyyy too much with dynamic SQL. But I just keep running into situations that require it. That being said, I ran into an interesting problem that had me puzzled. I found a bunch of different blog posts that pointed to me to the right direction but required a little extra work to find the solution.
There are several concepts that are at play here, so I’ll try to break this out so we can put the pieces together. The first once is centered around dynamic SQL. There are two parts of this I want to make sure we understand first – how it fits into sessions and how it gets executed.
Read the whole thing.
Leave a CommentThe
maxandminaggregation functions are common to almost every language, and the Kusto Query Language is no exception. As you would think, when you pipe in a datasetmaxreturns the maximum value for the column name you pass in. Likewiseminreturns the lowest value.In addition, there are variants for each,
maxifandminif. We’ll see examples for all of these in this post.
Click through for a few functions you can call via the summarize operator.
Ryan Adams continues a series on querying the serverless SQL pool in Azure Synapse Analytics:
There are two ways to read data inside Data Lake using the Synapse Serverless engine. In this article, we’ll look at the second method which uses an external table to query a path within the lake.
Synapse is a collection of tools with four different analytical engines (Dedicated Pool, Spark Pool, Serverless Pool, Data Explorer Pool). This gives you a lot of options for ingesting, transforming, storing, and querying your data. Here you will use the Synapse Serverless Pool to query the data in your ADLS account.
Read on for a demonstration.
Leave a CommentLukas Eder says, we have window functions at home:
One of MySQL 8’s biggest improvements is the support of window functions. As I always said in conferences, there’s SQL before window functions and SQL after window functions. Once you start using them, you’ll use them everywhere.
Some of you poor souls are unfortunate enough to be stuck on MySQL 5.7, either of your own choosing, or because you’re using a clone / fork that is still 5.7 compatible. While for most people, this blog post is just for your amusement, or nostalgia, for some of you this post will be quite useful.
If you are in a windowless world, read on to see how you can make life a little more manageable.
Leave a CommentReitse Eskens does a performance comparison:
A few days ago, I heard someone stating that Group By was much quicker than Distinct. Less disk impact, less memory etc.
So, I thought I’d find out if it’s true or not because I found it interesting. I always thought there was no difference. I tested a single small table and found no difference in speed, reads or execution plan. But that’s no real world example. Usually the tables contain a lot of data and are joined to other tables.
Click through for the results of Reitse’s analysis.
Leave a CommentKendal Van Dyke walks us through a few new bits of T-SQL in SQL Server 2022:
Time series data is often used for historical comparisons, anomaly detection and alerting, predictive analysis, and reporting, where time is a meaningful axis for viewing or analyzing data.
Time series capabilities in SQL Server were introduced in Azure SQL Edge, Microsoft’s version of SQL Server for the Internet of Things (IoT) which combines capabilities such as data streaming and time series with built-in machine learning and graph features.
I am happy to see that these operators and functions made the leap from Azure SQL Edge and am hopeful that we’ll see a bit more of what makes databases like influxdb so useful for time series make their way in as well.
Leave a CommentKevin Wilkie does some winter cleaning:
Sometimes, in Snowflake as well as in SQL Server, you’re forced to delete data. Hopefully, you’re not deleting from the main table of a database in Production, but that is definitely one way to wake up in the morning.
The syntax starts off as similar to T-SQL but there are a couple wrinkles in there as well.
Leave a Comment