Connect to an Azure SQL Server with no public access

Hi nullabee​, I posted a detailed answer on your other thread with the same question, so it stays in one place: Proper way to connect to Azure SQL wrt Firewall. In short: keep the private endpoint in a small ingest workspace (or use a Copy activity via a VNet data gateway) and run the many short notebooks in a workspace without a managed VNet, so they keep the fast starter pools.