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 […]
Updating Stats in Azure SQL Database
Recently we were having some issues with DTU utilization in Microsoft SQL Azure. One of the troubleshooting steps that was suggested was the update statistics and rebuild indexes. […]
Profile columns for indexes
Every once in a while, as part of a consulting project I need to investigate all the different columns and datatypes used within the tables. Often in order […]
Monty Hall Simulation using T-SQL
The first time I heard about the Monty Hall problem was while watching TV. The host of the TV show had presented the problem as you typically see. […]
Query to quickly profile a column
Every once in a while, there is a need to quickly profile columns in a table. typically as part of a redesign, the below query help quickly profile […]
Outlook 2019 keeps asking for password multiple times
A few years back I had tried upgrading my version of Outlook from 2013 to 2019. During this time I faced a number of issues and the most irritating one was that […]
Part 2:- Learning T SQL for beginners – Datatypes
In the previous post I talked about what Microsoft SQL Server programming language (T-SQL) is about. I also explained what a table is and what basic information is requires. In this […]
Part 1:- Learning T SQL for beginners- SQL, Tables and Nulls
Learning SQL is easy when you have a good understanding of the basics. Everything else is based on the basics and it’s been the same since RDBMS (relational […]
Query to find execution time of Jobs
Recently we have been facing couple of issues with regard to the way the jobs have been scheduled. To investigate this, we needed a query that can identify the execution […]