by bobtaylor29708 | May 29, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
In this SQL Snacks™ we will investigate some of the operators we will need to understand, prior to tackling the time series functions. Today we examine the range operator and range function, the make-series operator, as well as the series_stats operator....
by bobtaylor29708 | May 10, 2019 | boB 'The Tool Man' Taylor, SQL Meals™, SQL Snacks™
I will be in the labs with a customer for the next two weeks and I may not be able to release SQL Snacks™ during this time, due to the time required to record and post-edit the videos.
by bobtaylor29708 | May 10, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
In this SQL Snacks™ we will examine the datatable operator which allows us to construct a tabular source separate from the permanent tables in our database. Additionally, we will take a look at prev, next, row_cumsum, and matrialize. The datatable operator becomes...
by bobtaylor29708 | May 9, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
IN this SQL Snacks™ we will examine the let, join, and union operators. NOTE: for the join operator I will NOT be using the Kusto Explorer, but rather the demo portal for Log Analytics https://portal.loganalytics.io/demo...
by bobtaylor29708 | May 8, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™, Uncategorized
In this longer SQL Snacks™ we will examine some advanced aggregation operators namely: make_set, make_list, mv-expand, percentiles, top-nested, min, max, arg_min, arg_max, dcount, dcountif, countif, sum, sumif, and any() The video is too long so I have created two...
Recent Comments