KQL Series – SQL to KQL Cheat Sheet
This blog post is about how to quickly learn KQL. Kusto supports a subset of the SQL language. See the list of SQL known issues for the full list of unsupported...
2022-03-31
1,151 reads
Blog Posts
KQL Series – understanding KQL Queries (Part 1)
In my pervious post I wrote about KQL queries that we will write – we also could use some free some samples that Microsoft put up for us to...
2022-03-31
12 reads
KQL Series – understanding KQL queries (Part 2)
In Part1 we talked about what a query is. The most common query we will write is a tabular expression statement which is what people usually have in mind...
2022-03-31
16 reads
KQL Series – what is Kusto Query Language?
This blog post will detail what KQL is all about… KQL was developed to take advantage of the power of the cloud through clustering and compute. Using this capability,...
2022-03-31
48 reads
KQL Series – why is it called Kusto Query Language?
I use KQL on an hourly basis…. But for a query language – why call it Kusto..? Where is a funny tidbit of information: You have probably heard something...
2022-03-31
7 reads
Kusto Query Language – a series
This blog post is about a new query language that I have learnt and I really think you need to learn it too. Especially if you are doing ANYTHING...
2022-03-31
11 reads
Talk to the duck.
Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is ... Continue reading
2022-03-31
560 reads
Tech Lunch News
Ve středu 9.3.2022 jsme se tradičně sešli nad novinkami ze světa dat, datových skladů, Power BI, Azure apod. Jestli jste chyběli (ale příště dorazíte, že? :D), zde je malý...
2022-03-31
3 reads
ADX and KQL – Azure Monitor Logs in Azure Data Studio
G’day, I recently wrote about the Kusto Query Language Extension that’s available as an plugin for Azure Data Studio along with KQL Magic. The main reason that people have...
2022-03-30 (first published: 2022-03-17)
166 reads
Calling the Intercom API with Power Query and Refreshing in the Power BI Service
I needed to pull some user data for an app that uses Intercom. While I will probably import the data using Data Factory or a function in the long...
2022-03-30 (first published: 2022-03-22)
234 reads
Blogs
Microsoft finally adds Tenant Switcher for Fabric / Power BI
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Microsoft Releases Windows 11 ARM ISO – A Game Changer for ARM-Powered Devices
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...
Building Effective Data Governance Framework: Top Areas to Focus On
The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first...
Forums
Pull mssql to Postgres
Does anyone have a script\example that would connect to SQL server instance run a...
Fill in missing hours for each VisitID during the day
create table #T ( VisitID varchar(30), ER_Date date, HR int ) insert into #T(VisitID,...
Database copy for report work load
Hi Team, I am looking for a an help, Please see my problem below....
Question of the Day
The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers