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