[…]
Month: February 2021
Heaviest snowfall of 2021
This might be the heaviest snowfall of 2021. […]
Access SMB UNC share through DNS CNAME alias
When migrating applications from one server to another, one of the headache is to search through all possible depending processes and update them to reference the new server name. One of the solution is to keep using the same server name, and only keep one server online. However, in many cases, you need to keep […]
How to search all objects in all databases with specific word phrase in SQL Server
When migrating SQL databases to new server, one of the challenge is to identify all the hard-coded references to old servers or services. Here is a small piece of code that I wrote to search all databases to identify all objects with references to specific keywords or phases. […]