Data Recovery

How to Auto Classify Incoming Outlook Emails based on Which Type of Recipient You Are

Some users hope to classify and archive incoming Outlook emails based on which type of recipient they are - "To", "CC" or "BCC" recipient. Now, this article will make this come true with Outlook VBA. Perhaps you're accustomed to creating various folders and subfolders to separate emails. For instance, you create three subfolders under Inbox. They are "To", "CC" and "BCC" respectively. Then, you hope, when an incoming email arrives in Inbox, Outlook can auto figure out which type of recipient...

Read more »

3 Crosstab Query Techniques in MS Access

This article addresses some simple crosstab query techniques which can help while working in MS Access. In a nutshell, the Crosstab query can be defined as a matrix, in which column headings are derived from the field values. It is the transformation of data rows into columns. It involves data aggregation like total sum broken down between months or products etc., in which these months are represented through columns. Today we are going to talk about some of Crosstab Query techniques which...

Read more »

2 New Features Introduced in SQL Server Management Studio 17.3

This article addresses the newest features of SQL Server Management Studio 17. 3, particularly Import Flat File Wizard and XEvent Profiler, and how users can use them to increase their efficiency. When it comes to managing nearly any SQL infrastructure, most DBA swear by SQL Server Management Studio (SSMS). In its effort to make this application more effective, Microsoft regularly updates with. The latest iteration, SSMS 17.3 supports all features of SQL Server starting from the 2008...

Read more »