Episode Description
If you are letting people query Microsoft Fabric with T-SQL, you are already making a security decision, whether you meant to or not. We sit down with data platform MVP John Minor to unpack what it really takes to secure the Fabric SQL analytic endpoint, from the basic shape of the Fabric ecosystem to the small settings that can derail a rollout.
We start with the fundamentals: which Fabric objects actually expose a SQL analytic endpoint (lakehouse, warehouse, mirrored database, SQL database), what “read-only endpoint” means in practice, and why the SQL database has both OLTP and OLAP representations. John explains the purpose of the SQL analytic endpoint, what you can build with T-SQL (views, functions, object-level controls), and why case sensitivity is a gotcha worth fixing before you deploy anything widely. We also cover connectivity, including the TDS protocol and how SSMS fits into real-world management and testing.