Azure

Category

PowerVault: Manage your Azure Key Vaults from PowerApps

The Azure Key Vault service is perfect for saving all kinds of information in a secure manner: authentication keys to connect to a database server, SSL certificate files, and of course, passwords... or as Azure Key Vault names them, secrets.

Recently, Microsoft released a connector to use this service (still in preview) so building a PowerApp to manage these secrets is a match made in heaven

Query and transfer data between Azure SQL databases

In the DevOps world, there are some situations where you need to have a way to transfer data from different Azure SQL databases.  For example, let’s say you have a client who inadvertently deleted a huge amount of records from a table in the production database. With the help of the Point in Time backups, we could restore the database to an earlier point in time in which those records still exists. This process will create a new database with the restored contents and then we could swap names between these databases by renaming them. However, there is a caveat of performing this action. The restored database will lose all the...