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
30 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
38 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
29 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
70 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
26 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
24 reads
Passed a CosmosDB Exam
I took the beta exam for Cosmos DB a few months back. I did this as part of the MVP program, as they were asking people to evaluate the...
2022-03-30
36 reads
On bias
Last week saw the second month of my employment at Microsoft. I admit that I’m enjoying my job, and I can’t deny that the reduced amount of time I’ve...
2022-03-30
24 reads
Daily Coping 30 Mar 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-30
17 reads
Daily Coping 29 Mar 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-29
25 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers