Blog

Blog posts on .NET, Azure, and more.

Implementing database change notification using SignalR and Azure Functions

May 29, 2023 by Anuraj

Azure Serverless Functions SQLServer SignalR

This post is about implementing database change notification using SignalR and Azure Functions. In this post we will using Azure Function with SQL trigger for change identification and Azure SignalR binding for notifications. Here is the basic architecture of the implementation.

Azure SQL triggers for Azure Functions

May 27, 2023 by Anuraj

Azure Serverless Functions SQLServer

This post is about Azure SQL trigger for Azure Functions. The Azure SQL trigger uses SQL change tracking functionality to monitor a SQL table for changes and trigger a function when a row is created, updated, or deleted. Changes are processed in the order that their changes were made, with the oldest changes being processed first. Currently SQL trigger is not available as part of Visual Studio new function screen. We need to create an Azure function and modify code to support Sql triggers.

Azure SQL output binding for Azure Functions

May 16, 2023 by Anuraj

Azure Serverless Functions SQLServer

This post is about Azure SQL output binding for Azure Functions - this feature is preview right now. The output binding helps us to write data to SQL Server in Azure Functions. In the earlier post, we explored the Input binding which helps to read data from SQL Server. Azure function now offers SQL trigger as well, we will be discussing this in a later post.

Azure SQL input binding for Azure Functions

May 14, 2023 by Anuraj

Azure Serverless Functions SQLServer

This post is about Azure SQL input binding for Azure Functions - this feature is preview right now. The input binding helps us to read data from SQL Server in Azure Functions. To write to SQL Server we need to use the Output binding. Azure function now offers SQL trigger as well, we will be discussing this in a later post.

Configure Auto Scaling in Azure App Service

May 13, 2023 by Anuraj

Azure AppService Scaling

This post is about configuring automatic scaling in Azure App Service. Automatic scaling is a new feature available in Azure App Service scale out configuration. The feature of automatic scaling is a novel way to expand the capacity of your web applications and App Service Plans without having to make scaling decisions yourself. It differs from the existing Azure autoscale, which allows you to specify scaling rules according to schedules and resources. With automatic scaling, you can modify scaling settings to enhance your application’s performance and prevent delays in starting up. This Automatic scaling feature is in preview. And it is available for Premium Pv2 and Pv3 pricing tiers, and supported for all app types: Windows, Linux, and Windows container.

Copyright © 2024 Anuraj. Blog content licensed under the Creative Commons CC BY 2.5 | Unless otherwise stated or granted, code samples licensed under the MIT license. This is a personal blog. The opinions expressed here represent my own and not those of my employer. Powered by Jekyll. Hosted with ❤ by GitHub