Have you ever wanted to extract the list of attachment information from an open or selected email? You must feel it time-consuming to get it manually. This article will introduce you a quick method to achieve it with Outlook VBA.
For some reasons, you may be required to get the list of attachment information from an email, including the attachment name, index and size, etc. Perhaps it’ because that you need to make a report or reply the email with the list of attachments. Regardless of why...
Read more »
When working in a very large SQL Server environment, it is very common that no one in the organization knows who uses a particular database. This scenario is very common if there are multiple legacy systems. Follow this article to identify how effectively your SQL Server databases are used.
Method 1:
In this method, we are going to read the output of sp_who2 and capture it in a table. The first step is to create the table using this script.
CREATE TABLE T1 (
session_id INT
...
Read more »
“Cleaning” information before you import it into your database is pretty standard – after all, one of the reasons you’ve started to use a database is so that you can predictably query that database for set criteria right…right? So how you handle external situations where, for example, you have to import info from a file where one person enters “$” but another assumes you know it’s a monetary value – or worse, where someone enters “am” or “pm” but another person uses the 24-hour clock? As usual,...
Read more »
