How to access an SQL Database from an Azure Function and Nodejs

In this video, I will explain how to use an #Azure Function in #NodeJS to execute a query in a #SQLDatabase.

(#cloud5mins - Episode #27 )

USEFUL LINKS:
-----------------------

FOLLOW ME ON
---------------

BLOGS
------------

GEARS
----------

-

[liluo]

You have no idea how much i was lost before this video, finally ! merci bcp mon ami !

[VillagevlogsNew]

Please suggest connect to "Azure SQL Edge" using node js

[namanmehta]

Hey, a question off the topic, have you tried creating a new file using node program in Azure Functions and a question related to the sql connection, have you faced issue including a ssl file to establish connection to DB?
Thanks!

[kirtiarora]

this is really helpful @Frank Boucher. but can we do the same with postgres db ?

[aadilhussain]

Can you please tell me how can we pick up "var config" properties values dynamically into index.js? here you are giving hard coded data

[ben]

Thank You Frank. btw, How can I store telemetry data(from IoTHub) into Sql Database with Azure Functions ?

[samsmith]

Merci pour une très belle vidéo. Hormis la pandémie, nous aurions visité la France en mai. In future videos, I feel an area not easy to learn about is how to access diagnostic log messages in the portal. For instance, if the DB connection does not work or has error, how best to annunciate (either to log or to user)?

[prashara]

How do we pass the response back for sql call to an application calling the Azure function

[njagdis]

Hi Frank... I just want to learn How we trigger ADF pipeline from anywhere/any-device without login. Can you please make a video that "Create a piperun (manual trigger a ADF pipeline) from your local box ( use Azure Web app in App service without sign in) to Azure data Factory pipeline" .
conditions are
1) you should not use ApplicaionID and Secret key. ( means AAD App Registrations are not allowed)
2) You should use your app service(web app) under SYSTEM IDENTITY but not user identity. make users to run you ADF pipeline manually.

[rimansingla]

How we can achieve the same thing through event hub trigger?

[namanmehta]

Hey, You said that in real life we would make more secure connection to database. What do you mean by that?

[SainathReddy]

can you please show how to query azure SQL DB from node app using active directory authentication

[undercrackers]

It might be a great tutorial. I don't know because I cannot read the code in the video.

[billmanassas]

Just a clarification, you should specify in your title that you are connecting to an *Azure* SQL Database. Connecting to on prem requires more steps (hybrid connectivity/ app service plan)

[Megagonk]

this is very bad code, you are putting username and password in your code and not in your settings exposing it to exploitation

[XinWongDigital]

deploy without testing? something is missing.😉