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()....
Recent Comments