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]
From time to time, you may need to modify the time stamp of a file for archiving or any other reasons.This PowerShell script comes in handy when you need to do it. This is for a one-off tweak of a file. If you're doing this in bulk, it's probably … [Continue reading]
You can use the following scripts to find all affected objects that make any references to your search term.You can either use sql_modules or syscomments to accomplish this purpose. Generally, they should give you the same results, but from time … [Continue reading]