AzureDevOps: Deploying Secrets from Azure Pipelines


Introduction We know that Web Apps secrets can be managed from azure key vault using some secrets.json/secrets.xml. There is another easy way of handling the secrets without hanging anything from the code like installing Nuget package/referring Azure Keyault in the code. Here we are going to use simple way in AzureDevOps Release pipeline and Deploy Azure App Service Task for managing all our secrets. Step … Continue reading AzureDevOps: Deploying Secrets from Azure Pipelines

Azure: Daily Reports using Logic Apps


Introduction Working on-premises SQL having many advantages like you have the full administrative rights over a dedicated SQL Server instance, we can run scheduled Jobs using SQL Agent Job. Speaking of SQL Agent Job, I personally a huge fan of this. We can do a lot and lots of stuff like schedule jobs, view the job history, Run manual jobs, Sending Emails etc.,  But when … Continue reading Azure: Daily Reports using Logic Apps

T-SQL: Bulk Insert Azure CSV Blob into Azure SQL Database


Introduction When coming to the cloud, especially in Azure, all the structure and unstructured data will be stored inside a blob container (In Azure Storage Account) as a blob. In this blog, we are going to see how we are going to import (or) bulk insert a CSV file from a blob container into Azure SQL Database Table using a Stored Procedure. Prerequisite Azure Subscription– … Continue reading T-SQL: Bulk Insert Azure CSV Blob into Azure SQL Database