Sometimes the simplest thing is really taken for granted and we take the long route to do the simplest thing. We received a CSV with thousands of ID numbers that will be used to update a database table. The data would look like the following: The goal is just to add a comma at the end of each line so it can be used to update data in a database table. In the past, we would probably write a macro module in Excel, but other than a security risk, it's overcomplicating a simple … [Continue reading]
When you use Visual Studio Code on Windows, one handy feature is you can always call it from the command line by typing "code ." (without the quotes) in the folder where you want to work on. But when you try that on macOS Terminal, this is what … [Continue reading]
Typically, web application is run using ApplicationPoolIdentity on IIS. However, for various reasons, it's very common to find large corporations use service accounts to run the application pools. Sometimes the challenge comes when you need to … [Continue reading]
Setting up a website on IIS is very easy to do. However, it can get very tedious when we have migrate multiple websites from one server to another. For a new server, the easiest to migrate all those settings of course is to clone the server and then … [Continue reading]
Just to build on top of the code from the previous post. This time, there is a page on a Web Forms application with a text that needs to be eliminated, but we no longer have the ability to re-compile. Fortunately, the change is cosmetic so we can … [Continue reading]