Microsoft Community Insights Podcast

Episode 54 - Securing Fabric SQL Analytic Endpoint with John Miner

Microsoft Community Insights Podcast

Show Notes

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. Text Us About the Show

More from Microsoft Community Insights Podcast

Oct 20, 2026

In this episode chat with the one of the creator behind Gtihub Agentic workflows to find out what inspired him and tell his story behind it. Peli traces the idea from continuous AI with GitHub Next to early prototypes running coding agents in CI/CD, and explains why automation experience from .NET testing and MakeCode learning sandboxes shaped the design. He defines agentic workflows as markdown-defined workers compiled to Actions, with layered security including containers, microVMs, firewalls, MCP-gated access, and a zero-secret policy.

Sep 4, 2026

I joined Art in a conversation Microsoft Office 365 copilot adoption and how he used copilot co-work in daily to do daily task. AI Community Conference HK – September 4 (Co-hosted by our APAC team) Boston Data and AI Saturday 2026 – October 3 Community Summit NA 2026 – Nashville, TN – October 12

Aug 19, 2026

We talk with Navyasree Potluri who is from Microsoft about FabricIQ Integration

Aug 13, 2026

In this episode we discuss the new Foundry Toolbox with Arafat Tehsin. Toolbox is a new way to centralise, configure, and reuse tools across all of your AI agents without re-configuring them in Microsoft Foundry. More information can be found below including link to his demohttps://github.com/arafattehsin/foundry-toolbox-demoshttps://arafattehsin.com/bloghttps://fedorai.com https://devblogs.microsoft.com/foundry/introducing-toolboxes-in-foundry/

Aug 6, 2026

Bernat Agulló is a data platform engineer based in Barcelona who speaks Spanish, English, Japanese, and some German. Agulló has been a Microsoft MVP since 2022 and recently renewed the status for a fifth year. His professional background in data engineering began around 2018, following earlier experience with Excel macros, SQL, and data pipelines like SSIS. He gained recognition in the community by focusing on niche topics such as calculation groups and scripting, areas that were not widely covered by other presenters at the time.

See all episodes →