by bobtaylor29708 | Apr 29, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
In this SQL Snacks™ we will look at a very useful operator, namely summarize. We will also examine some of the many aggregate functions that work hand in hand with summarize....
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 | Jan 9, 2019 | boB 'The Tool Man' Taylor, Extended Events, Power BI, SQL Server 2016, SQL Server 2017, SQL Server Management Studio, SQL Server Tools, Tools
I had an interesting question from a customer that I am currently working with. They said, ‘In Azure SQL DB I can see the number of deadlocks very easily in a graphical manner – why can’t I do that on premises?’ I thought for a minute and a...
by bobtaylor29708 | Jul 30, 2018 | boB 'The Tool Man' Taylor, Extended Events, SQL Meals™, SQL Server 2016, SQL Server 2017, SQL Server Management Studio, SQL Server Tools, SQL Snacks™, XE Profiler
In this SQL Snack™ I will examine the three remaining targets (I don’t plan on covering the ETW sync target as it is out of scope for this series). The counter, histogram and pair matching targets are very simple and straight forward to use and consume. In the...
Recent Comments