×

CBusPASS – Columbus, OH SQL Server User Group

Date/Time: Thursday, March 11, 2021 18:00 to 20:00 EST
Location: Virtual

View Event: Kusto Query Language (KQL) and Azure Log Analytics

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.



profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

RT: @DCACco: https://bit.ly/3QMQ3UF Are you a speaker in the #SQLServer community? Are you going to the #sqlpass ...summit? Time is running out to register for #SpeakerIdol. If you haven't registered already, get registered ASAP. There are only a few days… https://bit.ly/3Smx9VE

Fun, educational, and full of embarrassing stories! If you can make SQL Saturday Boston, then stop by this session for... laughs, groans, and some useful ways to keep the query optimizer working for you!

#SqlSaturday #SqlSatBoston

@SqlrUs will be talking about "Saving Yourself with Accelerated Database Recovery" at #sqlsatboston

Did you register?
...https://www.eventbrite.com/e/sql-saturday-boston-2022-tickets-380639893167

#sqlsaturday #database #sqlserver #ADR #MVPBuzz

@BryanCafferky will be talking about "Python & SQL Server: A Winning Combination" at #sqlsatboston

Did you ...register?
https://www.eventbrite.com/e/sql-saturday-boston-2022-tickets-380639893167

#sqlsaturday #python #SQLServer

@JohnMiner3 will be talking about "Security your delta lake with table access controls" at #sqlsatboston

Did you ...register?
https://www.eventbrite.com/e/sql-saturday-boston-2022-tickets-380639893167

#sqlsaturday #deltalake #security #encryption #MVPBuzz

Load More...