Azure Logic Apps for Azure Database DBAs

Agenda

• 18:00-18:15 - Opening, Announcements, and More...

• 18:15-19:15 - Azure Logic Apps for Azure Database DBAs

• 19:15-19:30 - Q&A and Open Discussion

Session: Azure Logic Apps for Azure Database DBAs – Ronen Ariely (60 Minutes, Hebrew)

The work of database administrators does not stop at the database level. Many tasks require the use of external tools to maintain and improve our databases. These tasks can be very challenging when we use a fully managed platform as a service (PaaS) such as Azure SQL Database or Azure Elastic Pool.

Azure Logic Apps for the rescue! Azure Logic Apps and the Azure SQL Database can interact with each other. The database can trigger the execution of logic apps, and a logic app can trigger read and write operations on the database. For example, Azure Logic Apps allow us to send email notifications triggered by DDL and DML actions in the database, it allows us to monitor database usage and database events, and it allows us to read the data stored in the database and use it in the content of the email.

For whom? Azure SQL Database is a fully managed platform as a service (PaaS). This makes it very simple to be used without any need to maintain the host. It has a fully functional GUI using the Azure Portal, which means that we can use it without writing any code. If you are a DBA and you manage Azure SQL Databases, then this session is for you. No previous experience in developing applications is needed.

In this session, we will show you how to send emails using logic apps and interact with Azure SQL Databases. We will go over common scenarios, and present practical examples with step-by-step guidance for implementing the solution. According to the time, we will show some tricks, tips, troubleshooting, and automated maintenance tasks using Azure Logic Apps and the new Azure Logic Apps Preview.

This session is a practical demonstration!

Session level: 300-400. Target audience: DBAs and developers.