Posts

Showing posts from April, 2020

Tidy up - Unused Project and Nuget package reference using Visual Studio 2019

If you are a Developer/Architect using Visual Studio as IDE for your development activities, this blog post will be of your interest. During the Ignite 2021 conference, Microsoft released Visual Studio 2019 v16.9 and v16.10 Preview 1. As part of version 16.10 Preview 1, one of the cool features they introduced is to "Remove Unused References..." for any Projects and Nuget packages that are not in use. At the time of writing this blog post, we have Visual Studio Version 16.10.0 (official release) which includes this new feature.  As part of development, we generally get carried away and introduce new Nuget package references to your project and add new references to your Projects. By the end of development, you will not be 100% sure which are not being referenced and unused which means you will leave those unused project references in your application. Now you might be wondering what's the big deal in it since it doesn't harm. The advantage of removing unused project r...
Post a Comment
Read more

AZURE SQL - Vulnerability Assessment

Image
In my last blog post, we looked at the Data Discovery & Classification features within the Advanced Data Security (ADS) offering for Azure SQL. In this blog post, we will have a look into Vulnerability assessment. Azure SQL Overview Azure SQL Database is a fully managed Platform as a Service (PaaS) Database Engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. As with any database platform, security remains a top concern to address this issue or concerns Microsoft have offering called Advanced Data Security with Azure SQL service. Pre-requisites Enable Advanced Data Security (ADS) at the database level by navigating to Settings > Advanced Data Security for your SQL database and click  Enable . Alternatively, ADS can also be configured and managed at the server level by navigating to Settings > Advanced Data Security for your server and switching the ‘Advanced Data Security’ ...
Post a Comment
Read more

AZURE SQL - DATA DISCOVERY & CLASSIFICATION

Image
Azure SQL Overview Azure SQL Database is a fully managed Platform as a Service (PaaS) Database Engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. As with any database platform, security remains a top concern to address this issue or concerns Microsoft have offering called Advanced Data Security with Azure SQL service. Pre-requisites Enable Advanced Data Security (ADS) at the database level by navigating to Settings > Advanced Data Security for your SQL database and click Enable . Alternatively, ADS can also be configured and managed at the server level by navigating to Settings > Advanced Data Security for your server and switching the ‘Advanced Data Security’ setting from ‘Off’ to ‘On’. AdventureWorksLT database will be used. Enable the Auditing settings to have complete investigation experience. Go to the Auditing blade and toggle Auditing switch from OFF to ON. Choose...
Post a Comment
Read more

Azure WebJob - configurable Cron Expression

Azure WebJobs is a feature of Azure App Service that enables you to run a program or script in the same context as a web app, API app, or mobile app. Azure WebJob are ideal for running long running background tasks in cloud. There are 2 types of web job: Continuous web job Triggered web job Manual triggered web job Scheduled triggered web job Scheduled triggered WebJob will be executed based on provided CRON expression.The scheduling is done with a TimerTrigger that takes in a cron expression as argument as shown below public async Task TimerTriggerFunction ([TimerTrigger( "0 */5 * * * *" , RunOnStartup = true )] TimerInfo timerInfo, CancellationToken cancellationToken) { //Some logic goes here... _demo.SomeAction(); } Above code snippet shows CRON expression which is scheduled run every 5 minutes. Which is absolutely fine but when you are building enterprise grade solution we want job to be flexible enough to r...
Post a Comment
Read more