Fix Outlook Categories

Sometimes the categories are no longer valid and appear as white squares.

Also, each category cannot be assigned unless it is re-created.

If there are a lot of categories, then this process can take sometime.

Microsoft provided a solution to resolve this tedious behavior, but it is one of those hidden features.

1. Ensure that Outlook is open and the Mail tab is selected.

2. Right-click on the account that contains the categories and click on the Data Properties... item.

Click on Data Properties...

3. Click on the Upgrade to Color Categories... button to continue the process.

Click on Upgrade to Color Categories... button

4. A dialog prompt appears that informs

SQL Server XML Data Retrieval Using XQuery

SQL Server allows that storage of XML in table columns.

The XML can be stored in either a plain text data type or as valid XML.

The most efficient way of accessing the XML is using a temporary table to store XML data.

The main reason is that the column may not be an XML data type and it also allows more control over the output.

XML Text Values

The XML text is a value specified between the start and end tags.

DECLARE @XmlTable TABLE (XmlResult XML)
    FROM [Book];

Windows Command - setx

Setx creates or modifies environment variables in the user or system environment, without requiring programming or scripting.

The Setx command also retrieves the values of registry keys and writes them to text files.

Setting Environment Variables

Set environment variables permanently, Setx can be used to set Environment Variables for the machine (HKLM) or currently logged on user (HKCU).

> setx <variable> <value> [/m]
  • <variable> - Identifies the variable to be set, e.g. JAVA_HOME, PATH etc.
  • <value> - The variable value, e.g. TEMP C:\Windows\Temp
  • /m - (Optional) Used