As a follow-up of the post String Literals as Column Aliases are Deprecated, this one feature from Redgate's SQL Prompt is quite handy to correct any existing SQL scripts quickly. Using the SQL from How to Find All References to an Object in a … [Continue reading]
Steps to Install a Certificate on a Window Server Right-click on Windows button at the bottom left corner and select Run. Type in mmc and click OK. On the new Console window menu, click on file and select Add/Remove Snap-in... or press … [Continue reading]
Something that's still found in SQL scripts in enterprise environment, even with newly written scripts is the use of string literals as column aliases. Although this feature has been deprecated since 2012, old habits die hard. So what's … [Continue reading]
AVIF is a modern image format based on the AV1 video format and generally has better compression than WebP, JPEG, PNG and GIF. This format is designed to supersede them. Unfortunately, the support for AVIF in web browsers is still not as high as it … [Continue reading]
How do you take advantage of serving AVIF image from IIS server? For simplicity sake, since the setup is very similar to serving WebP format, I'm going to use the same screenshot illustrations from that post. The problem with using IIS Server is … [Continue reading]