How to Effectively Use Backup Compression in SQL Server

SQL Server's backup compression allows you to save disk space by compressing backup files. Many SQL Server database administrators forget to enable this feature, thereby allowing backup files to occupy a lot of disk space. In this article, we will learn how to quickly enable the feature "Compression" on all your SQL Servers. Scan using registered servers: From your SQL Server management studio, click on the View and then select Registered Servers. Create a new server group and add all your...

Read more »

Why One Should Avoid Using Memo Fields for Grouping in Access

In this article we would learn the key aspects related to memo fields and learn why they are not really helpful and often result in bugs and truncation. A memo field can store large amount of information, allowing up to 65,536 characters, with various options. In the latest editions of MS Access, it can store up to 1 GB of characters and allows rich text formatting. But it is often suggested to avoid the use of Memo fields for purpose like grouping in MS Access. The article will discuss the...

Read more »

How to Quickly Find the Contacts without a Photo in Your Outlook

Outlook doesn’t provide search filters that can support users to find the contacts that don’t have photo. Thus, if you wish to quickly search out the contacts without a photo, you can use the method shared in this article. Some users would like to quickly find out all the contacts that don’t contain photo. Yet, by default, Outlook doesn’t offer such a native search filter. Hence, you have to create such a filter in the first place. You could use the piece of VBA code below to achieve...

Read more »