JSON (JavaScript object notation) is an unstructured format for storing and retrieving data within files and databases. It offers the flexibility of an unstructured data format like XML […]
Getting Set Options for a Session
While browsing StackOverflow, I came across an interesting use case for the Set Options feature in SQL Server. I have created a few YouTube videos on the different […]
Is there a difference between using NOT IN and <>
This was a question that came up during a SQL Session I conducted recently. We were reviewing some code in a procedure and it has logic similar to […]
Is there a difference between using <> and ! = when it comes to inequality
I was asked this question recently when I conducted a SQL Session and it felt like a very simple and easy question to answer and something I am […]
Is Using Top operator good for your query?
Using the TOP operator in T-SQL procedures is a common practice among developers. It’s often employed to limit the number of records, either to fetch the first value […]
NULLs in MS SQL Server
NULLs are a frequently misunderstood concept within databases. This confusion often arises because NULL is mistakenly considered equivalent to empty or mathematically equal to zero, which is not […]
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 […]
Query to quickly profile a column
Every once in a while, there is a need to profile columns in a table. typically as part of a redesign, the below query help quickly profile some […]