In this post I cover the use of the new vector datatype in SQL 2025. I’ve noticed that a lot of RDBMS database folks seem to struggle to […]
Converting times across time zones
About 15 years ago I was in charge of maintaining a procedure that had over 300 lines of code dedicated to handling time zone conversions gracefully. It had […]
SQL 2025 Optimized locking in SQL2025
Optimize locking is the generic name given to two mechanisms that reduce the number of locks acquired by the database engine when performing DML operations. These are What […]
Fuzzy String matches in TSQL
This post talks about a new preview feature being introduced within MS SQL SERVER database engine. Readers are advised to check out the full details in the link […]
How to reduce the impact of mismatched collations in MS SQL Server
Does different collation affect performance for queries in SQL Server? The short answer is yes. The details are a bit more nuanced. For example when using datatypes like […]
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 […]
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 […]