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/
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
TSQL Merge
Sources: https://docs.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver15