Abstract:

Kusto is a service for storing and running interactive analytics over Big Data. Kusto was designed from scratch to be a “big data” repository for Azure and easy to query using Kusto Query Language (KQL). As we progress in our migration to the cloud, we are learning new ways to monitor and alert resources and services. Microsoft has consolidated many services under the umbrella of ‘Azure Monitor.’ Whether you are detecting and diagnose issues across applications and dependencies,’ ‘correlate infrastructure issues with Azure Monitor for VMs,’ ‘drill into your SQL database monitoring data with Log Analytics’, you will be using ‘Azure Monitor.’ Azure Monitor uses a version of the KQL used by Azure Data Explorer that is suitable for simple log queries and includes advanced functionality such as aggregations, joins, and smart analytics. As we advance, the KQL must be your primary resource for querying the Azure Monitor log.

This 95% demo session will show you some ‘getting started’ tips and a few sophisticated queries using KQL. We will do a live demo, generating an alert using KQL. We will dive into Kqlmagic, which brings you the benefit of notebooks, data analysis, and rich Python capabilities in the same location against Azure Log Analytics workspace. The demo will also include how to pass variables from Python to Kqlmagic and vice-versa – (Bonus: a sneak preview on parameterization support in notebooks in Azure Data Studio). At the end of this session, beginners will have a solid knowledge about KQL that they can build upon by themselves; others will also learn many advanced operators, including machine learning ones. Come and learn about the future of monitoring and investigations of Azure services.

Bio:
Julie Koesmarno
Principal Program Manager at Microsoft
Julie Koesmarno is a Principal Program Manager at Microsoft, for the SQL Tools and Experiences team. She has worked in Data Management, Data Warehouse, and Big Data Analytics solutions both on-premises and cloud over the past decade. She’s currently working on Azure Data Studio improvements for modern data professionals. She is a regular speaker for user groups and conferences such as SQL Saturdays, PASS Summit, and SQL Bits. She is a co-author of SQL Server 2017 Machine Learning Services with R.

Taiob Ali
Microsoft MVP – Data Platform
Taiob Ali, Microsoft Data Platform MVP, is an accomplished technical leader with a proven record of success. During his last 15 years, he has worked with the Microsoft Data Platform and MongoDB both on-premises and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare. Taiob has hands-on experience in managing large database projects, including massive data migration, intricate process design, testing and deployment, performance tuning, long term capacity planning.

Taiob is currently working at “GMO LLC” as Database Solutions Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual chapters, Data Saturdays, and Azure conferences. He is a board member of New England SQL Server User Group, founder of ‘Database Professionals Virtual Meetup Group’, and organizer of Boston Data Saturday.