A developer's diary

Write

Task.Run vs. QueueUserWorkItem

Apr 21, 20252 min read

Optimizing LINQ Queries for SQL Server Bit Fields

Dec 18, 20243 min read

Response.Redirect: true or false?

When you use Response.Redirect with its second parameter set to true, it triggers a call to Response.End() Response.Redirect("Login.aspx"); // default is true Response.Redirect("Login.aspx", true); // same as above This causes AS...

Apr 23, 20252 min read

Thread was being aborted

Dec 11, 20242 min read

Could not load file or assembly X or one of its dependencies.

Jul 29, 20242 min read

Azure Function IP List

https://resources.azure.com/ Select subscriptions > {your subscription} > providers > Microsoft.Web > sites. In the JSON panel, find the site with an id property that ends in the name of your function app. (Look at your function name at Azure Funct...

May 6, 20241 min read

System.Data.Linq.ChangeConflictException: Row not found or changed

Set all non primary-key column's UpdateCheck property to Never in the DBML file. Reference : https://stackoverflow.com/questions/805968/system-data-linq-changeconflictexception-row-not-found-or-changed

Apr 17, 20241 min read

Azure App Service "Production Breakpoints" errors

This article describes a curious fix I found to an issue where Application Insights (seemingly) crashes your Azure App Service, leaving behind interesting, yet non-descriptive errors in the Application Event Logs. Does your Azure App Service’s event ...

Mar 29, 20242 min read

String operations

List<string> to string[] List<EntityName> device = dc.EntityName.Where(p => p.Id == userid).ToList(); string[] the_array = device.Select(i => i.PlayerID.ToString()).ToArray(); string to string[] string someString = "something"; string[] stringArray ...

Feb 23, 20241 min read

How to implement Ola Hallengren's IndexOptimize script on Azure Automation

Download 3 scripts from here : https://ola.hallengren.com/downloads.html Create table : CommandLog.sql Create procedures: CommandExecute.sql, IndexOptimize.sql Edit procedure IndexOptimize according to Brent Ozar article. (https://www.brentozar.c...

Jan 17, 20243 min read

How to permanently remove URL from Google

The removal tool only provides temporary removal for approximately six months. To permanently remove content or URLs from Google search results, make sure your web server returns a 404 (Not Found) or 410 (Removed) HTTP status code. protected void Pag...

Dec 21, 20231 min read

Command Palette

Latest articles