by bobtaylor29708 | Apr 30, 2019 | Kusto Query Language, SQL Meals™, SQL Snacks™
In this SQL Snacks™ we examine the three ‘flavors’ of the project operator, the extend operator and the explain service....
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 | Apr 25, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
In this rather long snack, we will look at the most basic operators found in KQL. We will look at search, take, and count. After this SQL Snack™ I will be producing one video per operator or operator family (such as project, project-away, project-rename) so that...
by bobtaylor29708 | Apr 24, 2019 | Kusto Query Language, SQL Meals™, SQL Snacks™
In this post I will demonstrate multiple editors that will allow you to begin your KQL journey. In this video I will cover Kusto Explorer, Azure SQL Analytics, Log Analytics (via Lens Explorer) and briefly mention KQL magic for Jupyter notebooks. In the next session...
by bobtaylor29708 | Apr 15, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
This introduction video will explain the goals of this SQL Snacks™ series. We will examine why you might want to learn the Kusto Query Language and I will outline the subjects that will be covered in this series....
by bobtaylor29708 | Apr 9, 2019 | boB 'The Tool Man' Taylor, SQL Meals™, SQL Snacks™
After my return from vacation I will be starting a new SQL Snacks series, titled “A deep dive into the data lake with Kusto” where I will first show you the relevant Microsoft services such as Log Analytics that leverage the Kusto Query Language (KQL) as...
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 | 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...
Recent Comments