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,317 reads
HeyMo0sh
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
33 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
64 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
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
13 reads
Azure Platform Series – renaming your YAML pipeline in Azure DevOps
This blog post is about YAML pipelines in Azure DevOps. I had a repo called InfrastructureAsCode for a client. I have been transitioning them to use YAML for their...
2021-08-02 (first published: 2021-07-15)
173 reads
Azure Platform Series: cloudshell code -your (brilliant) online editor
This post is about code which is an online editor you can use with cloudshell. I live in the Azure platform all day (almost) every day. What this means...
2021-02-05 (first published: 2021-01-25)
160 reads
Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”
This blog post relates to where you might be doing scale operations of your app services or VMs in Azure and get the following error after doing quite a...
2021-02-01 (first published: 2021-01-23)
247 reads
Bash: ^^}: bad substitution – upgrade your Bash version (macOS)
This blog post is about a situation where you are capitalising an argument in bash and you get the following error: bash: ${state^^}: bad substitution In this example I...
2021-01-24
94 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
SQL Art, Part 2: New Year Fireworks in SSMS
Comments posted to this topic are about the item SQL Art, Part 2: New...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers