Blog

Blog posts on .NET, Azure, and more.

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.

Getting started with Data API builder for Azure SQL Database or SQL Server

April 27, 2023 by Anuraj

Azure API

This post is about Data API builder, which is tool helps to provide modern REST and GraphQL endpoints to your Azure Databases. By utilizing the data API builder, you can make your database objects available through REST or GraphQL endpoints, allowing you to access your data using contemporary approaches on any device, language or platform. The integrated policy engine is both adaptable and versatile, supporting conventional functionalities such as pagination, filtering, projection and sorting. Consequently, creating CRUD backend services can be accomplished within a matter of minutes instead of days or hours, significantly boosting developer efficiency to an unprecedented level.

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