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 […]

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 […]

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 […]