AzureFunctionAppTestConnectivity

Sample Azure Function application to test SQL Connectivity

Function_ConnectSQL

Azure function expect parameter

• "ConnectionString" that you can copy directly from Azure Portal. But should looks like sample below

Server=tcp:XXXXXXX.database.windows.net,1433;Initial Catalog=sandbox;Persist Security Info=False;User ID=XXXXXXXX;Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

REF: https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-private-link-private-endpoint-connectivity/ba-p/1235573

Function_ConnectSQL_MSI

Azure function expect parameters:

• "ServerName"
• "DatabaseName"

REF: https://techcommunity.microsoft.com/t5/azure-database-support-blog/using-managed-service-identity-msi-to-authenticate-on-azure-sql/ba-p/1288248

Function_ConnectSQL_PoolLimit

Azure function expect parameters:

• "HighCPU" (1 or 0) When set to 1 Azure Function will do some math to increase CPU usage
• "LoopLimit" that should int (Sample: 5000)
• "ConnectionString" like sample below, and you can change parameter Max Pool Size=10

Server=tcp:SERVERNAME.database.windows.net,1433;Initial Catalog=sandbox;Persist Security Info=False;User ID=User;Password=XXXXXXXXX;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Max Pool Size=10;