As a developer if you are using Azure for cloud development, one of the first things to do is to authenticate your machine against Azure environment so that Azure knows commands issued against it are from a trusted machine! This is important to also eliminate the need of using connection strings as far as possible! Let's see how easy it is and how it could be done!
How do you ensure that duplicate keys are prevented on a column that allows NULL values?
A colleague of mine had a requirement in which he was interested to put the configuration settings of an ASP.NET Core application inside a SQL Server table and read them at startup of the application with a mechanism similar to what we already have for JSON files; also he wanted to have the ability that these variable being overridden or override other settings if applicable. In this article, I am going to describe how that could be achievable and how to implement such feature.