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. DECLARE @listReferenceObjects

The sun will come out, the ice will melt

A splendid winter morning

It’s -8 Celsius in the morning. I was hesitating before heading to the lake, but my dog Lucky insisted, and we went. I must say, it was magnificent!

Eat, Play, Love during pandemic lockdown

The pandemic turned the world upside down. Staying home, stay strong, eat, play, take care of loved ones. This is the best thing we can do to fight the virus.

How to install AD Tool and other RSAT tools on Windows 10 1809 and later

Active Directory tool is always a very handy tool for most Windows administrators. However, this tool does not come with Windows by default. Prior to Windows 10 build 1803, the easiest way is download the RSAT package from the below link, install the package, and then go to "Add