Close

Mentimeter tool

Interesting interactive presentation tool: Mentimeter, including a limited free version. Go to¬†https://www.mentimeter.com/ to check it out! Within a minute, you can make a presentation with a multiple choice question. Click on present and your audience can react live by going to www.menti.com and type in the code shown. Press the F key to go in…

Deploy Logic App via Portal

Another quick gotcha. If you want to migrate a Logic App from Development to Accept and you don’t want to use Powershell/ARM or Visual Studio Team Services (DevOps), you can perform the following steps in the Azure Portal: Clone the Dev version of your Logic App and name it Acc_LogicApp (follow the correct naming convention).…

Logic App parameters in SQL

In a previous post, I explained how you can use Logic App parameters in ARM templates. This solution is quite complicated. You will have to parameterize your Logic Apps. At deployment, the parameters are substituted by actual values. But, If you lookup the logic app in the Azure Portal, you will notice that the value…

Deploy API Connection using ARM

Azure API Connections have a name and a display name. When you create a new API Connection via the Azure Portal, you are not able to specify the name of the API Connection. This name is actually used in Logic Apps however. Example: @parameters(‘$connections’)[‘sftp_1’][‘connectionId’] In this case sftp_1 is the name, not the display name.…

Generate SQL Create and Insert script

Today I came across a SQL feature I had been looking for a long time: creating a table create script including the data that are inside that table. If you right-click the table, you can only get a table create script. If you click the database instead, you can select context menu Generate Scripts. In…

Extract ZIP file on FTP

The Azure FTP Connector currently has a limit on file size of 50MB. That’s pretty tiny for a file transfer application. It may even mean that you are unable to use this connector. There’s a solution however. In my situation I had a file of 134MB. I send this file in zipped format to the…