Monday, August 02, 2021

function.json location in Visual Studio Code.

When you are working with Azure Function, you may need to bind the input and output and also applying the log and Application Insight to your Azure function through function.json. This file can be easily available to you if you are working or developing the Azure Function through "Portal". But you have to search it in case of developing through Visual Studio or Visual Studio code. You can find the function.json file under the project folder's output. There you can modify the required attributes needed for your Azure Function.

Sunday, February 14, 2021

NuGet Packages Cache Locations

NuGet cache will be cached based on your project and user context, Often it required to be cleared to see the latest package addition and functional of it. Nuget manage its caches in the global configuration , http level,temp cache and plugin-level. You can find all these cache location
  • HTTP cache: C:\Users\UserId\AppData\Local\NuGet\v3-cache Nuget Global Cahce:
  • C:\Users\UserId\.nuget\packages\ Clearing NuGet Temp cache:
  • C:\Users\UserId\AppData\Local\Temp\NuGetScratch Clearing NuGet plugins cache:
  • Users\UserId\AppData\Local\NuGet\plugins-cache
    • After clearning this, Restore NuGet packages on your project and rebuild. Now you will see the latest packages in your project.

Tuesday, October 13, 2020

Publish an Azure SQL Database

 As part of my learning and preparing for the exam AZ 303 - Microsoft Architecture Technologies, Its a sub topic under "Implement and manage Data platform".

Publish an Azure SQL Database: 


The word "Publish" being used because the nature of the Azure SQL Database.(Service). Essentially publish means, updating your Azure SQL database's schema and data.

Before publishing (updating the Azure SQL), we should know steps to creating and deploying the Azure SQL.

Publishing the Azure SQL Database supports the DevOps cycle within your project.

Different types of approaches to create and deploy the Azure SQL.

  1. DACPAC (Data Tier Application Package - Reference )
        It focusing on capturing and deploying the schema including updating an existing database. Best fit for DevOps. Developer can easily deploy the package from development to production with version controls.

SQL Script
        To run the SQL Script against Azure SQL , you need to create the firewall rules in order to execute the script by Azure Pipeline agent.

ARM (Azure Resource Management based PS)
Classic PowerShell (Windows based)
Azure Pipeline based on YAML (executing the SQL Scripts)

Sunday, October 11, 2020

Implement Azure SQL Databases - AZ 303 exam notes.

As part of my exam preparation , There is a focused skill topic "Implement and manage data platforms" for the exam AZ 303 - Azure Architect Technologies.

To learn the Azure SQL related notes, I have created my own Azure SQL database and check what are the features to be learned.

Implement Azure SQL databases 

  1. configure Azure SQL database settings 
  2. implement Azure SQL Database managed instances 
  3. configure HA for an Azure SQL database 
  4.  publish an Azure SQL database
To learn and deep dive into it, I just recapped my basic SQL related technical words like "Core, DTU, TDE, Data backup and copying data between SQL Server and Databases.

Core and DTU, plays very important role in Azure SQL database while choosing the correct Service tiers as business required.

DTU is combination of CPU, memory , I/O read/write and Storage are metrics  defined by OLTP workload metric. So every read write operation, data storing into storage medium, and the core power used to process the database operation all count for SQL Database cost.

On the configuration side, Initially not sure, but after creating the Azure SQL, It was so easy to learn what are the configuration needed to run and protect your SQL database in Azure.

You can see all the features in your database dashboard.