How to Auto Archive Expired Items when Your Outlook File Is Larger Than a Specific Size

You may wish Outlook to auto archive expired items when your Outlook data file exceeds a specific size limit. Though there is not such a native feature, you still can get it by the means introduced in this post. As we all know, the larger Outlook file is, the more vulnerable the file will be. So, it is necessary for you to always keep your Outlook file in small size. For instance, you can use the following method to auto archive expired items when Outlook file is larger than a specific...

Read more »

How to Batch Delete All Exceptional Occurrences of a Recurring Outlook Appointment

If you want to quickly find all exceptional occurrences of a recurring appointment and delete them in batches, you can use the method introduced in this article. After you create a recurring appointment, you may modify some of its occurrences. For example, you removed the reminders of the weekend occurrences, etc. In this situation, if later you think these exceptional occurrences are useless, you may be eager to delete them. Then, you can apply the approach shared thereinafter. It allows...

Read more »

4 Key Tips to Avoid Deadlocks in SQL Server

The article suggests important tips to avoid Deadlocks in SQL Servers Although SQL Server has witnessed huge evolution in past couple of years, users still regularly face the situation of deadlocks. Ideally, a database server should be able to retrieve multiple requests but it often results in blocks. The conflicts where one process awaits the release of another resource are called blocks. And then there are Deadlocks. Imagine a situation where one person is asking the second to release a...

Read more »