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 | Apr 26, 2019 | SQL Meals™, SQL Snacks™, Uncategorized
In this short SQL Snack™ we examine the where operator and compare and contrast its capabilities to those of the WHERE clause in the SQL Server syntax....
by bobtaylor29708 | Apr 25, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™, Uncategorized
In addition to the Kusto Explorer and the sample databases, Microsoft has provided a sample Log Analytics space for you to practice your KQL queries. Log Analytics Demo data
by bobtaylor29708 | Feb 5, 2019 | Uncategorized
I am working with a customer in a performance and scalability lab. One of the functions they are testing is a home grown type of Change Tracking. They apply triggers, and capture the data to move to another database for analysis. They were experiencing...
by bobtaylor29708 | Oct 2, 2018 | boB 'The Tool Man' Taylor, Query Data Store, SQL Server Management Studio, SQL Server Tools, Uncategorized
While at a customer today I was given an interesting question. The individual was writing reports and needed to have right-justified, zero padded fields. He was investigating the FORMAT function which was introduced in SQL Server 2012. He had heard some mumblings that...
by bobtaylor29708 | Jul 12, 2018 | SQL Server 2016, SQL Server 2017, SqlCommandFilter, Tools, Uncategorized
Thanks to reader EricEJ I have added an extension method to SqlCommandFilters which means instead of coding the call like this [csharp] // Explicit usage SqlCommandFilters.Parameters.Parameterize(ref cmd); // you can now call it like this // Extension method on...
Recent Comments