You Tube Channel: https://www.youtube.com/@brrknowledgecenter

  When there is more than 1 server in web farm scenario it is an obvious choice to go for session out-of-proc either with SQL server or State server. While storing session with SQLServer if you see issues with SQL deadlock during peak loads involving  DeleteExpiredSessions  . It goes like this… Looking at the current implementation of the  DeleteExpiredSessions  stored procedure: CREATE PROCEDURE DeleteExpiredSessions AS DECLARE @now DATETIME SET @now = GETUTCDATE() DELETE ASPState.dbo.ASPStateTempSessions WHERE Expires < @now RETURN 0 GO This would take the locks on all the expired records for deletion and these locks may be promoted to page locks. This can give rise to deadlocks with other ‘session state write statements’ when the number of records marked for deletion increases. By default this stored procedure is supposed  to run every minute. For Example: In one of the case. Looking at no. of records which are marked for deletion Select count (*) from ASPState.dbo.ASPStateTempSe

Azure Cognitive Services is a machine-learning service from Microsoft that brings AI within the reach of developers.  These are APIs, SDKs and services to build AI application without having detail knowledge on AI and data science. Azure Cognitive Services are divided in to following five categories Vision Speech Language Search Knowledge  It has almost 22 sets of different APIs. Vision APIs Vision API offers powerful pre-trained machine learning models through REST and RPC APIs. Assign labels to images and quickly classify them into millions of predefined categories. Detect objects, read printed and handwritten text, and build valuable metadata into your image catalog. Computer Vision : Sets of API which allow you to access advanced algorithms for image processing and getting information. Custom Vision : Its allows you to build custom image classifier. You can access information through API. Content Moderator : Content Moderator provides monitoring for possible offensive, undesirable,