A few weeks ago, someone asked me a simple question: "Are our SQL Server databases encrypted?" At the time we had several dozen SQL Server instances spread across AWS EC2, Azure SQL Managed Instance, Azure SQL Database, and AWS RDS. Four platforms, three authentication methods, and multiple teams managing them. Nobody had a single view of the entire fleet. I could have opened SSMS, connected to a Central Management Server group, and run a query. That would answer the question once.
