devops
Configure Hosts File on Asus RT-AX88U Router
· ☕ 4 min read
Have you ever wondered how to configure local access to an externally accessible resource in your network, via the same domain name? Simple example is a NAS storage. In my case Synology DS918+. After setting up SSL, I realized that I cannot access the NAS locally via the same domain name, only by IP. But accessing by IP gives me SSL related errors. Each part of the solution was not difficult to find. There are just a few dozen moving parts. In my case the weak spot was Linux knowledge, and relying on command line, as I am generally a GUI fan.

Cannot open .SQL file in Visual Studio 2010
· ☕ 1 min read
Environment hangs, completely at times, or just for several seconds. If it resumes after hanging, you are able to close the tab where this .SQL file would show up. In any case, you cannot see or edit anything in there, seeing this Visual Studio 2010 branded blue background all over the contents area.

MS SQL Server 2008 R2 error log growing rapidly
· ☕ 1 min read
MS SQL server 2008 R2 was spamming the error log with the following two messages (got around 50GB of them in 4 days). An exception occurred while enqueueing a message in the target queue. Error 15517, State 1. Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.

MS SQL drop column with default constraint
· ☕ 1 min read
The following MS SQL script will generate MS SQL statements to drop a list of columns with default constraint for a certain table. Need to change table_name and list of columns, as applicable. Statements will be generated only if required.

List all valid email addresses in Exchange 2007
· ☕ 1 min read
You may need these to configure your 3rd party antispam software/appliance. There were lots of articles on the internet with complicated solutions, which did not work for me. Here a Powershell one-liner for Exchange management shell.