Getting ready

Navigate to the Azure portal and perform the following steps:

1. Create a logical SQL Server with a name of your choice. It is recommended that you create it in the same resource group where you have your Azure Functions.
2. Create an Azure SQL Database named Cookbookdatabase by choosing Blank database in the Select source drop-down of the SQL Database blade while creating the database.
3. Create a firewall rule for your IP address by clicking on the Set Firewall rule button in the Overview blade so that you can connect to the Azure SQL Databases using SQL Server Management Studio (SSMS). If you don't have SSMS, install the latest version of SSMS. You can download it from https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms.
4. Click on the Show database connection strings link in the Essentials blade of SQL Database, as shown in the following screenshot:

1. Copy the connection string from the following blade. Make sure that you replace the your_username and your_password templates with your actual username and password:

1. Open your SSMS and connect to the Azure logical SQL Server that you created in the previous steps.
2. Once you're connected, create a new table named EmployeeInfo using the following schema:

CREATE TABLE [dbo].[EmployeeInfo](
[PKEmployeeId] [bigint] IDENTITY(1,1) NOT NULL,
[firstname] [varchar](50) NOT NULL,
[lastname] [varchar](50) NULL,
[email] [varchar](50) NOT NULL,
[devicelist] [varchar](max) NULL,
CONSTRAINT [PK_EmployeeInfo] PRIMARY KEY CLUSTERED 
(
[PKEmployeeId] ASC
)
)