KQL Series – overview of ingesting data into our ADX cluster
In the previous blog post we created a database in our Azure Data Explorer (ADX) cluster. In this blog post we will discuss how we can ingest data into that database...
2023-03-19
45 reads
HeyMo0sh
KQL Series – Interactive Analytics with Azure Data Explorer
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)
180 reads
KQL Series – quick intro to Azure Data Explorer
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)
402 reads
KQL Series – how not to waste $ running ADX clusters
This blog post is based on my personal experience running an Azure Data Explorer (ADX) cluster. I was doing a presentation for Data Platform Summit in India, I spun...
2022-04-11 (first published: 2022-03-31)
131 reads
KQL Series – Big Data Analytics with Azure Data Explorer
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
32 reads
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
57 reads
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
10 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
13 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
220 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
24 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers