Should your SQL Server database use foreign key constraints?
Should SQL Server databases enforce foreign key constraints? A veteran DBA breaks down the real arguments
2026-10-14
Foreign Keys (FK)
Foreign Keys and Performance in a Microsoft Fabric Warehouse
I wanted to answer a simple question: Do relationships help, hurt, or have no effect when added to tables in a Fabric warehouse?
2026-09-18
2026-02-23
1,030 reads
2023-12-27
532 reads
2023-10-27
481 reads
2023-10-20
482 reads
2018-08-27
895 reads
2018-06-05
894 reads
2016-08-16
1,395 reads
2016-08-02
1,418 reads
Blogs
SQL Server 2016 Has Reached End of Support. Now What?
By SQLPals
SQL Server 2016 Has Reached End of Support. Now What? On...
The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering
By James Serra
(This post starts a three-part series on how AI is changing the way we...
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Forums
Hyperscale Replicas V
Comments posted to this topic are about the item Hyperscale Replicas V
A Heavy Heart
Comments posted to this topic are about the item A Heavy Heart
Calculating Weighted Average in Power BI
Comments posted to this topic are about the item Calculating Weighted Average in Power...
Question of the Day
Hyperscale Replicas V
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers