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 […]
Popular Posts
Trending Posts
Recent Posts
Editors Choice
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 […]
![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 […]
The ship of Theseus
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 […]