Kumar Prateek

List of target databases or tools applications where data can be moved using Azure Data Factory  (aka. Azure Data Factory Connectors)   Azure Data Factory as we know is an PaaS (Platform as a Service) offering by Microsoft Azure. Which is known for its fully managed integration services. Which can also be called as serverless integration service as most of the other PaaS offering. With use of Azure Data Factory one can seamlessly integrate the source data source, perform the data transformation (if any) and load the data into a difference data store. Basically, it's a fully-managed ETL (Extract-Transform-Load) process/ tool in other words.     But most of us don’t know which are the data sources where Azure Data Factory can make connection with using there in built connectors. Well, there are more than 90 built-in,  maintenace -free connectors (as per Azure official documentation). And in this article, we will try to understand what are  those lists of conn...

How To do Case Sensitive String Match in SQL Server    In this post we will try to understand how can we perform case sensitive search/ string match in SQL server. As most of us continue to use SQL server with the default setup where the regular string match is case-insensitive.  So, to understand the concept let's take an example.  Let say we have a table with 2 columns ID and UserName, i.e., like this.  CREATE TABLE TestTable (      Id int,  [UserName] varchar(255)  );   Also let's add some data to our table using the following script.  insert into TestTable Values (1,'Kumar');  insert into TestTable Values (2,'Prateek');  insert into TestTable Values (3,'Kumar Prateek');  insert into TestTable Values (4,'KUMAR');  insert into TestTable Values (5,'PRATEEK');  insert into TestTable Values (6,'KUMAR PRATEEK');  And so, the data in our table looks like this.  Id UserName  1 Kumar...

  Disaster Recovery of Azure Blob Storage In this post we will try to understand various approaches available to restore Azure Blob storage in case of any disaster reported in the region where the service was hosted.     First, we need to understand the importance of having a disaster recovery approach. It is important as there are chances of unfortunate situation either technical or natural which can happen in the environment where our services are hosted. And based on how important the service is for our end-users, we can have one or the other approach or a combination of approaches.   These are the approaches we are going to discuss broadly. ·        Bring-up new blob using ARM templates ·        Enable Geo-replication on the storage account ·        Create snapshots of the blobs   Now, let's talk about them individually one at a time.

  How to authenticate REST APIs for Azure Resource Manager       In this post we will try to understand how to get authenticated for Azure Resource Manager Rest APIs. As we understand that all of the tasks that we do on resources using the Azure Resource Manager (ARM) must be authenticated with Azure Active Directory.       Following are the steps one need to follow in order to authenticate against Azure Active Directory:   Add an application to Azure Active Directory tenant   Set permission for the application that we added   Get token for authenticating requests to Azure Resource Manager  

Disaster Recovery of Azure API Management (APIM)     In this post, we will try to understand how we can apply a disaster recovery approach for Azure API Management aka. APIM. So, first of all, we will have to understand the importance of it. It's very important for an application using APIM to have a strong disaster recovery approach, as in case of any issue because of disaster reported, the system using the APIs underneath should be accessible for the users/ systems, and since the APIM is used as the fore front of the applications (mostly)  it's  important to restore the APIM service ASAP in case of any disaster reported, so that the application consuming the APIs underneath it  is  not having issue connecting to the APIs.       There are 2 broader options which one can think of:   Have a stand-by service in one or more regions   Service back-up and restore features    Let's  talk about both the approaches (one at a ...