This blog is about how we can do interactive analytics with Azure Data Explorer to explore data with ad hoc, interactive, and lightning fast queries over small to extremely...
2022-05-27 (first published: 2022-03-31)
211 reads
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
50 reads
This blog pos illustrates how Azure Data Explorer and Azure Synapse Analytics complement each other for near real-time analytics and modern data warehousing use cases. This solution is already...
2022-03-31
60 reads
Azure Data Explorer is a PaaS offering from Azure providing an end-to-end solution for data exploration. https://azure.microsoft.com/en-us/blog/individually-great-collectively-unmatched-announcing-updates-to-3-great-azure-data-services/ Here is a quick introduction of the features: https://azure.microsoft.com/en-us/services/data-explorer/#features This service from...
2022-04-15 (first published: 2022-03-31)
434 reads
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
244 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,344 reads
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
34 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
40 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
35 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
75 reads
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
When I run my query from DW, which uses a linked server, it times...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item The Disabled Index
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers