Learn how to Authorize your Key Vault Secrets to Serverless Azure Function

Learn how to Authorize your Key Vault Secrets to Serverless Azure FunctionAre you looking to Authorize your Key Vault Secrets to Serverless Azure function? If Yes, then this article is for you. In the previous article, we learned how to access and configure Key Vault in our ASP.NET Core web application. Wait! What if we want to access the Key Vault from a Serverless Azure Function. Continue reading

Your secrets are safe with Key Vault in ASP.NET CORE Web App on Azure

Are your application secrets being checked in the source control?
Let me introduce you the way to Safeguard your application secrets that will make your application more secure and no more checked in application secrets in the source control. 

What will you learn in this blog: I have been trying to explore how to secure secrets of web application on Azure using Key Vault.  I have been trying to do small Proof of Concept to try your secrets are safe with Key Vault in ASP.NET CORE Web App but was failing to implement it in a single shot. I searched various article which was shown as working as per code but when I implemented them step by step it never worked.

So finally after lots of hit and trials…
I was finally able to store my web application secrets in the Azure Key Vault.
I will try to cover each and every topic in this small proof of concept to be in depth with all small points to be demonstrated via gif so that it’s easy to understand.

Continue reading

Choose and IIF Function in Sql Server

Choose function in SQL Server is used to get the item at the specified index from the list of available values. The index position starts with 1.

Syntax

Select choose(index,value1,value2,..)

1

If the mentioned index is greater or less than the specified values, It results null.

2

If we pass the float value in the index it will be converted to an integer, based on that the value will be selected.

3

IIF Function

If function returns the one of the two values, depending on the condition evaluates true or false.

Syntax


IIF(BOOLEAN CONDITION,TRUE_VALUE,FALSE_VALUE

The IIF function is like Ternary operator in a programming language with single condition.

4