How to Log and Monitor Your Server’s Memory Usage without Using Third Party Tools

Stop buying third party tools to monitor Memory usage on SQL Servers. Using this TSQL Script, you can log server's Memory usage. You can also set email alerts accordingly. Why DBA should Monitor Memory Usage? Generally a DBA’s mailbox will be flooded with emails whenever end users are unable to work on a server or if all the task are taking too much time. With a quick check at the Server’s resource usage, you can determine that the reason for this problem is the server’s Memory. The CPU...

Read more »

How to Auto Move the Emails with Specific CC Recipients in Outlook

In reality, most of you may hope to create an Outlook rule to auto move the emails with specific CC recipients. But Outlook rule doesn’t support checking CC recipients. So this article will teach you how to realize it with Outlook VBA. Obviously, it is impossible for you to create an Outlook rule to search specific CC recipients. As shown in the following screenshot, for received emails, you can only check if your own name is in the CC box. Similarly, for sent emails, even there is no...

Read more »

2 Methods to Find the Largest or Smallest N Items in Your Excel Worksheet

Sometimes you need to find the largest N items or the smallest N items in a range in your worksheet. Here we will provide two effective methods for you. Finding the largest N items or the smallest N items in a range is a very ordinary task in your work. In our previous article How to Highlight the Top or Bottom N Items by Conditional Formatting in Excel, we have introduced the methods of using conditional formatting. And in the following part, we will discuss about the two other methods in...

Read more »