EugeneChiang.com

Log Deadlock

Alert Log

JavaScript and Blazor without index.html reference

JavaScript Isolation in Blazor WebAssembly From the .NET 5 (RC 1) version, we are able to isolate our JavaScript code as a standard JavaScript module. This is beneficial because We no longer have to add our JS functions to the global window namespace We don’t have to manually import JavaScript files in the index.html file myscript.js Razor... » read more

App Icons

https://www.iconfinder.com/ https://favicon.io/ https://fontawesome.com/

Print Barcode Labels using Microsoft Word

Use Mailings -> Labels -> 5160 Address Labels (10×3=30 labels/page) Create an excel with 30 records with “Barcode” title and use “Select Recipients” -> “Use an Existing List” to read in the data. Use the following to print out barcode… Change MERGEFIELD to MERGEBARCODE and add CODE128 at the end. { MERGEBARCODE Barcode CODE128 }... » read more

SendGrid: Using Template via Web API

Data Field For Each If Then Sources: https://htmlemail.io/blog/custom-sendgrid-templates https://sendgrid.com/docs/api-reference/ https://sendgrid.com/docs/ui/sending-email/how-to-send-an-email-with-dynamic-transactional-templates/ https://sendgrid.com/docs/for-developers/sending-email/using-handlebars/#handlebarjs-reference https://docs.sendgrid.com/for-developers/sending-email/using-handlebars#iterations https://github.com/sendgrid/email-templates/tree/master/dynamic-templates/receipt

SendGrid Error: Status Code Forbidden

Getting this error when calling the web API. Error only occurs with certain from email address. Status Code: Forbidden Issue: I was having the same problem. I discovered that the emails from of my application and the sender authentication of the SendGrid API need to be the same. Fix: To fix this error you need go... » read more

Database Transaction Log and Update Large Number of Records

Getting this error during updating a large number of records to a large table. Solutions Put the database recovery mode from “Full” to “Simple” to avoid generating transaction logs in the Full recovery mode. Update in batches. Update multiple columns at a time.

SendGrid: How To Send An Email With Dynamic Transactional Templates

https://sendgrid.com/docs/ui/sending-email/how-to-send-an-email-with-dynamic-transactional-templates/

Check for Valid Email String

SQL Server Import and Export Wizard Tool

To import/export between Staging and Production server, use the SQL Server Import and Export Wizard Tool. Use “SQL Server Native client 11.0” Use query to import data to a temporary table and then insert into the destination table from the temporary table. 30 million records = 10 minutes to import data from source table to... » read more