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...
by bobtaylor29708 | May 7, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
In this SQL Snacks™ we look at conditional operators such as case() and iif(). We also take a quick look at split() and strcat()....
by bobtaylor29708 | May 6, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
In this SQL Snacks™ we examine the datetime, timespan, date_part, format_datetime and format_timespan...
by bobtaylor29708 | May 3, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
In this SQL Snacks™ we will cover the following operators – extract, parse, between, in, and todynamic...
by bobtaylor29708 | May 2, 2019 | Kusto Query Language, SQL Meals™, SQL Snacks™
In this SQL Snacks™ we will look at our first set of scalar operators and functions, namely print, now(), ago() and sort/order....
by bobtaylor29708 | May 1, 2019 | Kusto Query Language, SQL Meals™, SQL Snacks™
In this SQL Snacks™ we examine a few more of the basic operators, namely distinct, sample-distinct, top, and top-nested....
Recent Comments