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,150 reads
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,150 reads
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
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
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
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
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
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)
163 reads
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)
156 reads
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)
239 reads
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
73 reads
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
This book was making its rounds on social media, and the concept seems interesting...
By Steve Jones
One of the things that I’ve been asked in every operations situation is what...
I declare @Where based on the input parameter in the stored procedure. Set @SQL...
Hi, hoping someone can help. We're in the process of migrating to a new...
I am building an ETL process between these tables in SQL Server 2022 set to 160 compatibility level:
CREATE TABLE Image_Staging ( imageid INT NOT NULL CONSTRAINT Image_StagingPK PRIMARY KEY , imagestatus TINYINT , imagebinary IMAGE); GO CREATE TABLE Images ( imageid INT NOT NULL CONSTRAINT ImagesPK PRIMARY KEY , imagestatus TINYINT , imagemodified DATETIME , imagebinary IMAGE); GOI want to run this query to check if the images already loaded exist. This will help me decide if I need to insert or update an image. What happens with this query?
SELECT i.imageid FROM dbo.Image_Staging AS ist INNER JOIN dbo.Images AS i ON ist.imagebinary = i.imagebinary;See possible answers