How to Scan and Get Log Shipped Databases in SQL Server

"Log Shipping Alert" is a job category that is created on the SQL Server instance whenever the log shipping is enabled on a database. Though this might seem to be an easy way to identify if log shipping is running on a particular SQL server, through TSQL we can scan the entire SQL Server environment to identify databases that are participating in Log Shipping. 2 tables Log shipped databases can be easily identified using two tables in msdb database. The first table is the...

Read more »

How to Auto Link Appointments with Related Contacts in Outlook

Outlook permits users to link any items with any contacts. Now, in this post, we will make this feature much more intelligent. It will auto identify the related contacts from the new appointments and link them. As normal, to link an appointment with contacts manually in Outlook, you should firstly enable “Show contacts linked with the current item” feature in “Outlook Options”. Then, after opening an appointment, you will see a “Contacts” button at the bottom. You can click on...

Read more »

How to Auto Sync New Contacts to another Contacts Folder in Outlook

Some users desire that new contacts can be automatically added to two or more folders in their Outlook. So, this article will share a way to auto sync new contacts to another contacts folder. Perhaps you have configured several email accounts in your Outlook. And each of them has its own Contacts folder. In such a case, when you create a contact in one folder, you may wish to sync it to the Contacts folders of other email accounts, too. Why not let Outlook auto accomplish it? Here we’ll...

Read more »