---
title: "SQL Server Estate Governance"
slug: "sqlserver-estate-governance"
type: recipe
locale: en-US
canonical: "https://www.coremodels.io/recipe/fabric/sqlserver-estate-governance"
updatedAt: "2026-08-27T01:42:16+03:00"
---

# SQL Server Estate Governance

Govern a plain SQL Server estate, same connector, same T-SQL extract.

The Fabric connector's extract shape is ANSI T-SQL INFORMATION_SCHEMA, so plain SQL Server estates work through the same connector: no Fabric required. PK/FK constraint rows become uniqueness checks and governed references, key-shaped columns with no declared key are flagged (key-column-undeclared, relationship intent invisible to tools), and because T-SQL's information_schema carries no descriptions (extended properties are not extracted, recorded once as descriptions-not-extracted), the governed graph becomes the estate's documentation home.

## Articles

- [Nothing Broke. That's the Problem.](https://www.coremodels.io/connector/fabric/h1-need)
- [Five Questions a Governed Warehouse Answers Without a Meeting](https://www.coremodels.io/connector/fabric/h2-outcomes)
- [Identity, Types and Honest Loss: What a Fabric Import Actually Writes](https://www.coremodels.io/connector/fabric/t5-deep-dive)