Installing Azure DevOps Server on local

 If you want to learn and explore but cost and credit card is barrier for you to create the AzureDevOps services, then here is the option for you.

Installing the Azure DevOps Server on your local desktop or laptop.

Download the trial version (90 days free, cool : ) 💪) from here

https://docs.microsoft.com/en-us/azure/devops/server/download/azuredevopsserver?view=azure-devops

On setup wizard use the SQL Server express edition. Once you installed you need to configure your custom agent on your machine.

Now its time for starting  to explore the Azure DevOps services.

Azure DevOps Server Local installation - Custom Agent configuration

And the custom agent on your machine connected with local AzureDevOps server.

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.

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.

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)