The answer to this philosophical question holds profound implications for a number of scenarios. It aims to answer the question: when does something stop becoming itself? It was […]
Microsoft has removed the blog template from MS Word
Microsoft has removed the blog template from MS Word, basically this means you need to type your text directly into WordPress going forward since you cannot directly publish […]
Now that AI is here, What next?
We are faced with an interesting decision! Now that LLMs are here how do we proceed. In order to fully grasp the impact of what AI will do […]
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The above error message is common when working with SQL Server, however the generic nature of the error message means that inexperienced developers go down a rabbit hole […]
Working with JSON in MS SQL Server – A Quick Guide for Developers
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 […]
Should you monitor Logical Reads
The argument that reducing logical reads isn’t crucial because they occur in memory and are fast compared to physical reads is indeed valid on the surface. However, it’s […]
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 […]
What happens when you delete a column in MS SQL Server?
What sounds like a simple question as expected can have a complex answer in MS SQL Server. This is a good thing because there is a myriad of […]
Generational Inequity
What is generational Inequity? Generational Inequity refers to a phenomenon influencing various aspects of life such as politics, commerce, and even the judiciary. To best understand generational inequity, […]
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 […]