How to Read and Analyze Deadlock Logs in SQL Server

It is a well-known fact that deadlocks cannot be avoided. It is necessary that we learn to minimize deadlocks from our SQL server environment. Trace flags enable you to capture deadlock graph in the SQL Server Error log. In this article, we will learn how to get the deadlock history from that log. Deadlock Deadlock occurs when there is more than one session competing for a resource. When a deadlock occurs, SQL Server immediately jumps into action by killing one of the session and that session...

Read more »

How to Batch Change the Cases of All Contacts’ Full Names in Your Outlook

Perhaps you’ve discovered that your contacts’ full names are in various cases. If you would like to batch change the cases of contacts’ full names, you can use the method introduced in this article. Sometimes, you may find that the formats of many contacts’ full names are multifarious, such as non-uniform cases of full names. For instance, you must prefer “John Smith” instead of “john SMITH”. Therefore, here we will teach you to batch change the cases of all contact’s full...

Read more »

2 Methods to Copy All Members from One Contact Group to Another in Outlook

This article will introduce 2 approaches to copy all the members from one contact group to another one. You can choose either as per your needs. Many users hope that Outlook can provide a quick means to copy the members from one contact group to another. It can help them to escape from the trouble of adding members one by one manually. Now, in the followings, we’ll share 2 ways. The first one is a workaround, using Outlook native feature. And the latter one is much smarter due to its usage...

Read more »