The good thing about KQL is that the syntax is familiar to those who use TSQL, and any other RDBMS query language. This makes sense because the purpose […]
KQL – Tutorial – What is KQL?
What is KQL? KQL (Kusto Query Language) is a query language developed by Microsoft for searching and analyzing data. It is used in various Microsoft products, such as […]
Graph database Script- SQL 2017
Script for the video published here. CREATE TABLE Persons ( PersonId INT identity(1, 1) PRIMARY KEY ,PersonName VARCHAR(100) ) AS NODE INSERT INTO Persons SELECT ‘Batman’ UNION SELECT […]
Creating, Configuring and Querying DocumentDB in Azure
DocumentDB is a NOSQL JSON based data store available in MS Azure. In this post we cover how to create a document database followed by a Collection and […]
Creating a network graph in SQL Server
Over the holidays I have been looking to try out some new concepts in SQL Server and figured I should perform some analysis on all the emails I […]
It’s gorGEOus what you can do with this data type
Had some spare time on my hand today and created the company logo in the MS SQL Server Geometry datatypes. The Geography and Geometry datatypes are one the […]