A week in Kusto and SQL

Hello there,

It is time for a round up of what has happened in the world of Kusto and Azure Data Explorer.

SQL Bits 2023

First of all, the SQL Bits 2023 event is on! The biggest event for people around data. I've meet so many new and interesting people, and have also rejoined with my known network in the community.

What an event - this year with the feature of Dungeons and Dragons - and as SQL Bits are known not to save money on their event merchandise, this year is no exception.

T-SQL Tuesday #160 is out

This is a bit off topic, but still needs attention.

As every month the T-SQL Tuesday is out. This month is a wish list of things we would like to see in the cooperation between Microsoft and Open-AI - specifically using GPT3 (or GPT4 just released this week).

My contribution can be found on my blog here.

Kusto query sheet sheet

If you are trying to learn the Kusto Query Language (KQL), then Microsoft Learn has a great capability to "translate" from T-SQL to KQL.

It can be found here.

Things I've been reading this week

This week I've been re-starting my journey into the world of Azure Data Explorer (ADX) and are plunging myself into the abys of learning new stuff.

I've found these links of interest.

• Power BI modelling with ADX - when using Power BI together with ADX you need some settings that are not set as a standard. This small guide helps you out to do that
• ADX Web UI updates - every month Microsoft sends out a compiled list of changes to the ADX UI. This is a very good resource to read, to be on top of things.
• General availability of ADX dashboards - with this feature we can now build dashboards directly in the ADX UI - really helpful to get real time insights into your timeseries reporting without using Power BI. The UX here is not on par with Power BI, so you have to choose.

Thank you for reading and subscribing - if you haven't subscribed yet, don't forget to hit the button.

Feel free to reach out for a chat or networking.

Have a great weekend

Brian