If you’re eager to get ahead with Microsoft SQL Server 2025, this video tutorial is your perfect starting point. Even though SQL Server 2025 hasn’t officially launched yet, […]
Popular Posts
Trending Posts
Recent Posts
Editors Choice
Converting times across time zones
SQL 2025 Optimized locking in SQL2025
You Can’t Be King till You’ve Killed Someone
Fuzzy String matches in TSQL
IntelliSense not working in latest version of SSMS
New toys Had a bit of a brain fart moment recently. In all the excitement of installing the latest and greatest version of SSMS I was eager 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 […]
You Can’t Be King till You’ve Killed Someone
Power tends to corrupt, and absolute power corrupts absolutely. Great men are almost always bad men, even when they exercise influence and not authority; still more so when […]
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 […]
Executing Python Code in TSQL using SQL 2022
In this post, we’ll dive into how you can run Python code in SQL Server 2022. This process has changed significantly from previous versions, making it much easier […]
When is a date not a date in MS SQL SERVER?
Came across a weird issue while working on a project recently. The process is an ETL job that imports data from CSV files into a table and then […]
The certificate received from the remote server was issued by an untrusted certificate authority
Recently there has been a rise in number of error messages regarding certificates in Microsoft SQL Server Management Studio (SSMS). This is because of the breaking change that has […]
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 […]