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

.Net Core 2: Managing Secrets in Web Apps


Introduction As more and more applications moving into the cloud, the more and more securities that need to be handled carefully. Normally for WebApps whether it’s a .NetFramework (or) .NetCore all the configuration and secrets were kept in `web.config` (or) `appsettings.json` all the connection string/ApplicationId/ApplicationSecrets/Passwords were stored in those configurations. But this should not be kept as directly in the configuration which is less secure. Now, … Continue reading .Net Core 2: Managing Secrets in Web Apps

PowerBI: Tracking Location using Google Location Data


Introduction Google Location Tracking We are all used Google location for whenever we travel into the new areas or find exactly where we are. So we simply turn on the location in our mobile. As soon as we turn on the location google will track our location with exact Latitude and Longitude. Infact google will track our lat and lon for every 3-5 seconds. Considering … Continue reading PowerBI: Tracking Location using Google Location Data

Sticky post

MICROSOFT IGNITE – Mumbai


This is my first time travelling outside of south India, Mumbai is a whole new place for me.But I’ve more excited to attend my first ever microsoft ignite conference at mumbai. I’ve planned to stay there for 2 days (1 night) 22nd May -23rd May 2019 ,the first full day I’ve attended the conference. The conference went really good. I’ve the opportunity to see many … Continue reading MICROSOFT IGNITE – Mumbai