T-SQL Trigonometric Functions in SQL Server
Introduction SQL Server includes several built-in mathematical functions that allow developers to perform complex calculations directly within queries. Among these are trigonometric functions such as SIN(), COS(), and TAN(), which are useful in scenarios involving engineering calculations, geographic data processing, simulations, and analytics. Although these functions are straightforward to use, developers occasionally encounter unexpected results […]
How Multi-Column Statistics Work
The short answer: in the real world, only the first column works. When SQL Server needs data about the second column, it builds its own stats on that column instead (assuming they don’t already exist), and uses those two statistics together – but they’re not really correlated.
Spring Connections and Learning at PASS On Tour
The spring PASS On Tour event is coming to Chicago in a few weeks.
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Learn how the JSON_ARRAYAGG() function works in SQL Server 2025.
Microsoft On-Premises Data Gateway Administration
As a Microsoft Fabric Administrator, you have the responsibility to manage all the Microsoft Enterprise gateways installed and deployed across your entire data estate.
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Learn about using SQL Server to support AI-enhanced search queries with the Relational Embedding Retrieval Pattern (RERP).
Cross-database ownership chaining in SQL Server: security risks, behavior, and privilege escalation
A dangerous privilege-escalation path exists in SQL Server when cross-database ownership chaining, system database defaults, and overly permissive permissions are combined.
Blogs
Creating a Pulsing Conducting Baton - Part 1
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Forums
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
What Can AI Really Do?
Comments posted to this topic are about the item What Can AI Really Do?
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers