by bobtaylor29708 | Jul 1, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
In our final SQL Snacks™ for KQL, we will cover the charting capabilities that exist in the Kusto Query Language. Remember you can always export your KQL query as an M Query and use Power BI visualizations! NOTE: You can obtain all the sample code at my GitHub repo...
by bobtaylor29708 | Jun 24, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, Power BI, SQL Meals™, SQL Snacks™
In this SQL Snacks™ I will examine the User Analytics family of plug-ins. I will demonstrate a few of them but they all operate in a similar manner. One exception is the funnel_sequence which allows us to visualize causation. I will demonstrate how to execute the...
by bobtaylor29708 | Jun 17, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
In this SQL Snacks™ I will examine the plugins that implement several basic machine learning algorithms, namely autocluster, basket, diffpatterns, and the reduce operator....
by bobtaylor29708 | Jun 10, 2019 | boB 'The Tool Man' Taylor, SQL Meals™, SQL Server 2016, SQL Server Tools, SQL Snacks™, TDC
I was presenting at SQL Saturday 893 in Virginia Beach this weekend and when demonstrating the code I accidentally chose TailSpinToys-US database. It turns out that schema names do not like dashes. So I have checked in changes to both the TDC Wizard C# project and the...
by bobtaylor29708 | Jun 10, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
In this SQL Snacks™ we will examine series_fir(), series_iir(), series_linefit(), and series_line2fit()...
by bobtaylor29708 | Jun 3, 2019 | Kusto Query Language, SQL Meals™, SQL Snacks™
In this slightly longer SQL Snacks™ we will examine the family of functions that are based on series decomposition namely, series_outliers, series_decompose, series_decompose_anomalies, series_decompose_forecast, and series_periods_detect....
Recent Comments