SQL Server Identity Transformation — Implementation Companion
The executable counterpart to the narrative series: runbooks, audits and validation for each step
The Implementation Companion turns the SQL Server Identity Transformation narrative into runbooks. The narrative explains why each step happens and in what order; each book here covers how to carry it out, what the tooling produces, and how to check the result. Read Book 01 first: it sets out the prerequisites, the evidence model and the run order the other books assume.
| Book | Title | Narrative counterpart |
|---|---|---|
| 01 | Prerequisites and using this companion | Book 01 |
| 02 | Estate discovery and the consolidation gate | Book 02 |
| 03 | The authentication audit | Book 03 |
| 04 | Arc deployment and the instance identity (managed identity on SQL Server 2025; app registration plus certificate on 2022) | Book 04 |
| 05 | Login migration and parallel-run validation | Book 05 |
| 06 | NTLM detection and remediation | Book 06 |
| 07 | Groups, administrative units and the Conditional Access perimeter | Book 07 |
| 08 | The application chain and connection-string migration | Book 08 |
| 09 | Continuous monitoring and the closure record | Book 09 |
| 10 | Certificate discovery for SQL Server’s ADCS dependencies | Book 10 |
The narrative’s epilogue, Book 11 (the platform question), is a decision framework rather than a procedure, so it has no implementation book.
Back to top