KQL Series – create a database in our ADX cluster
In the previous blog post we created an Azure Data Explorer (ADX) cluster. In this blog post we will create a database that we will ingest data into, as...
2022-03-31
63 reads
Blog Posts
KQL Series – create an Azure Data Explorer cluster
I have written a lot about the magic of KQL and the brilliance of Azure Data Explorer. Now we should create a cluster of our own that hosts Azure...
2022-03-31
18 reads
KQL Series – creating KQL queries
Basically when we are writing KQL we are asking the following questions: Does it exist? Where does it exist? Why does it exist? What shall we do with the...
2022-03-31
20 reads
KQL Series – KQL usage with Advanced Hunting (this is huge)
This blog post is about another use of KQL that will definitely help your organisation and make you very popular. First of all check out this video here which...
2022-03-31
234 reads
KQL Series – Security Monitoring with Azure Data Explorer
This blog post demonstrates a hybrid end-to-end monitoring solution integrated with Microsoft Sentinel and Azure Monitor for ingesting streamed and batched logs from diverse sources, on-premises, or any cloud,...
2022-03-31
38 reads
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,326 reads
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
18 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
34 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
65 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
13 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers