Sometimes we cannot improve query performance because we don’t have control over the code. Consider a query that is generated by Entity Framework (EF) from the application and you do not have access to the source code. The main question is how you can improve SQL Server query optimization for a poorly performing query?
In this article, I will provide a set of examples to show case the use of OUTPUT clause for INSERT and DELETE statements.
This article covers the 10 key concepts developers should understand to avoid surprises and to use the model database intentionally.
In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]
Just like advances in artificial intelligence, I have heard that quantum computing is going to be a disruptive technology for our future. For instance, there’s the concern that it’s going to break/crack a lot of network encryption and potentially data encryption. What’s going to be affected, how long do we have, and what do I (and my organization) need to do to prepare for it?
Learn about the new ZSTD compression algorithm in SQL Server 2025.
Beneath the surface though, AI is just a tool that learns certain patterns and draws conclusions from information on the Web to answer questions, make decisions, or craft a code sample or two. Those that have used AI in the past will know that just as it’s capable of providing valuable information, AI tools can also generate inaccurate responses, and that’s why it’s important to use it wisely.
By Arun Sirpal
As part of my wider work exploring Claude Code and AI-assisted database engineering, I...
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
Comments posted to this topic are about the item Why Your Index Isn't Being...
Comments posted to this topic are about the item Distance Metric Algorithms
Comments posted to this topic are about the item What Can AI Really Do?
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers