Azure SQL Server provides multiple ways to connect and fetch the data. The most common authentication is based on username and password, however, in the world of the cloud, the most secure authentication method is based on the Azure Active directory using MFA. Supported features By default, this feature is not enabled, but once enable... Continue Reading →
Do you know that we can connect Azure services using Excel? I came across a scenario where I was supposed to utilize Azure Blob and Azure SQL service, and bring the data to Excel and do some analysis and create charts. In this post, we are going to connect Azure Blob Storage and Azure SQL... Continue Reading →
Creating Azure resources or services in Azure Portal is relatively easy activity. But, many times we need to understand some concepts or services which involve data. So, who likes creating tables, primary key - foreign key relationship, preparing inserts statements for tables, stored procedures etc.? I think most of us would not like it. That's... Continue Reading →