How to Monitor SQL Server Database Growth using TSQL and Excel

Monitoring database growth is a key factor in planning a server's resource. Use this script and create easy to understand database growth report Why You Need to Monitor Database Growth If you are a SQL Database administrator and if you are not having "SQL Server database capacity planning" in your key task list, then you can be sure that databases on your server will fill up your disk space pretty soon. Tracking the size and growth of SQL databases is one of the primary task of Capacity...

Read more »

3 Methods to Quickly Add Senders to Your Outlook Contacts

Sometimes, you may need to add senders to your Outlook contacts. In fact, there are several methods that can accomplish it. This article will introduce 3 of them in detail. For some reasons, you may be required to add the email senders to your Outlook contacts. In reality, you can achieve this via multiple approaches. But here we will tell you 3 means elaborately. Depending on how many the emails, whose senders you intend to add, you can choose the best one from the followings. Method 1:...

Read more »

How to Find Missing Items in a Column with Consecutive Numbers in Excel Worksheet

When you are working on an Excel file, it is unavoidable to lose some data and information. In this article, we will show you 3 methods to find the missing items in a column with consecutive numbers. Usually in your Excel worksheet, there will be a column with consecutive numbers. However, some reasons will cause some data to be lost, such as copying and pasting, or you forget to collect a sales representative’s information. Therefore, it is necessary for you to check the worksheet in...

Read more »