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, 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...
Recent Comments