Post reply

Connect an Azure Function to Azure SQL database Using a Managed Identity

  • July 20, 2026 at 12:00 am

    #4869254

    Comments posted to this topic are about the item Connect an Azure Function to Azure SQL database Using a Managed Identity

  • July 20, 2026 at 4:40 pm

    #4896931

    I was curious your thoughts on choosing between pyodbc (as in this example) and the newer Python driver (mssql-python) or the SQL bindings integration for Azure Functions. SQL bindings could be easier to get started, mssql-python would likely be best in terms of performance.

  • July 20, 2026 at 4:51 pm

    #4896936

    Thanks for the great question! I haven't had the opportunity to try mssql-python yet, so I can't compare it with pyodbc from firsthand experience. From what I've seen, it looks like a promising option and now supports Managed Identity as well, so it should work for this scenario. My article focuses more on the Managed Identity authentication flow than the specific driver, which is why I used pyodbc since it's a mature and widely adopted choice. As for SQL bindings, they're great for simpler Azure Functions, but I generally prefer using a driver directly because it provides more flexibility for real-world applications.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply