Kumar Prateek

  API Aggregation Using Azure API Management         There are cases where we need to call multiple APIs from the client at the same time in order to proceed further with the processing from the client application. Now as oppose to calling those APIs individually  i.e.,  making separate HTTP requests for all those multiple APIs what if we can make one HTTP request and get all the responses aggregated in one response as opposed to multiple response isn't it going to be super cool.       So,  in this post we will try to understand how we can aggregate/ merge multiple API responses from the backend and provide one single request and response from the Azure API Management (APIM) to the calling client application.       To do this first of all we need to understand our APIs request body which we want to merge using APIM, so let say we want to call 2 APIs and  their   URI  are like this.       ...

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 ...