What is New in SQL Server 2025
Learn about the latest version of SQL Server and get help installing it on your system.
2026-05-04
3,828 reads
Articles
How to pass Microsoft certification exams: tips and guidance
In my previous article, I discussed how to prepare for Microsoft certification exams. In this article, I’m covering what you should do when actually taking the exams.
2026-05-04
Understanding Deadlock Victim Selection in SQL Server
A short introduction to how deadlocks work and how you can affect their behavior inside your system.
2026-05-01
2,179 reads
Net Present Value and Internal Rate of Return in SQL Server
Many organizations store cash-flow data inside SQL Server and decision-makers often need metrics like Net Present Value (NPV) and Internal Rate of Return (IRR) to evaluate those cash flows. Is it possible to calculate NPV and IIR values in SQL Server without the use of external tools?
2026-05-01
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 […]
2026-04-29
2,016 reads
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.
2026-04-29
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Learn how the JSON_ARRAYAGG() function works in SQL Server 2025.
2026-04-27
3,758 reads
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.
2026-04-27
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).
2026-04-24
1,611 reads
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.
2026-04-24
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCU SAMARINDA No tlpon:08385883376
whatsapp:08385883376.Jl. Jend. Sudirman No.30, Ps. Pagi, Kec. Samarinda Kota, Kota Samarinda, Kalimantan Timur 75111
BCA KCP Kas Tajem TLP-WA 08216977701
Jl. Raya Tajem No.17, Denokan, Maguwoharjo, Kec. Depok, Yogyakarta, Jawa Tengah 55281
BCA KCP Kas Sekolah Vokasi UGM TLP/Wa 08216977701
Bulaksumur, Jl. Notonegoro No.1, Dabag, Condong Catur, Depok, Yogyakarta, Central Java 55281
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers