How to Read SQL Server Configuration and Installation Information from Registry

Many DBAs rely on Windows Registry search to get info about SQL Server Instances. It is not necessary to go through the registry for fetching SQL Server information. In this article, we will learn how to use TSQL and retrieve SQL Server information from Windows Registry. Get the permission: Before running the script, user account or the SQL Service account that would be running this script should have view server state permission on all servers from which data would be collected. If you run...

Read more »

How to Easily Set the Print Regions for Your Excel Worksheets

When saving data on Excel sheets it is a good practice to set print regions. Otherwise, we will end up with a huge task of adjusting column positions. Using Excel macro, you can easily set print regions for all your worksheets. Let's learn about that in this article. Download Now If you want to start to use the software as soon as possible, then you can: Download the Software Now Otherwise, if you want to DIY, you can read the contents below. Excel printing – not a rocket...

Read more »

How to Auto Set Follow up Flag for a Contact and Pop up a Reminder When His Birthday Is Today

If you hope that Outlook can automatically flag a contact for follow up and remind you if his birthday is today, you can use the VBA codes introduced in this article to achieve it. As we know, when you fill in the contact birthday field, Outlook will auto create the birthday appointments in the calendar. However, actually, many dislike such appointments since they will clutter up the schedules. Therefore, as Outlook also allows users to flag contacts for follow up, like flagging emails, so...

Read more »