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 […]
Setting Up SQL Server 2025 AlwaysOn Lab – Part 3: Availability Groups & Failover
Welcome to the third part of our SQL Server 2025 AlwaysOn Lab series. In the first two parts, we configured the Active Directory and set up a Windows […]
Setting Up SQL Server 2025 AlwaysOn Lab – Part 2: Configuring SQL Nodes & Cluster
In the previous part of this lab series, we set up the Active Directory, which forms the backbone for everything that follows. If you haven’t gone through that […]
Getting Started with SQL Server 2025: Step-by-Step AlwaysOn Configuration and Lab Setup
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, […]
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 […]
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 […]
![Warning: SQL71562: Procedure: [dbo].[Someproc] has an unresolved reference to object [Targetdb].[dbo].[TargetDb].](https://www.jayanthkurup.com/wp-content/uploads/2024/06/Visual-Studio-circular.webp)
Warning: SQL71562: Procedure: [dbo].[Someproc] has an unresolved reference to object [Targetdb].[dbo].[TargetDb].
Recently I came across an issue I have faced multiple time before but unlike previous times I was not able to fix the issue., the problem was that […]