Pauls Blog

xp_cmdshell allows you to run shell commands from T-SQL Instructions on enabling xp_cmdshell are found at  https://msdn.microsoft.com/en-us/library/ms190693.aspx -- To allow advanced options to be changed. EXEC sp_configure 'show advanced options', 1; GO -- To update the currently configured value for advanced options. RECONFIGURE; GO -- To enable the feature. EXEC sp_configure 'xp_cmdshell', 1; GO -- To update the currently configured value for this feature. RECONFIGURE; GO

http://www.w3schools.com/sql/func_convert.asp

      public static XmlDocument ConvertToXmlDocument(XDocument input)       {          var xmlDocumentObj = new XmlDocument();          using (var xmlReader = input.CreateReader())          {             xmlDocumentObj.Load(xmlReader);             return xmlDocumentObj;          }       }

https://technet.microsoft.com/en-us/magazine/hh289310.aspx

It's something like this Write - Host "$($blah.Name) $($ blah .Desc) "

nable Remote Desktop and add this domain user to Remove Desktop Users group.   http://technet.microsoft.com/en-us/library/cc794832(WS.10).aspx Enable "Allow log on locally" and add this domain users.  http://technet.microsoft.com/en-us/library/cc785165(WS.10).aspx Delegating administration http://technet.microsoft.com/en-us/library/cc778807(WS.10).aspx

A list of Exchange Cmdlets https://technet.microsoft.com/en-us/library/jj200780(v=exchg.160).aspx Deleting messages from Exchange Online https://support.office.com/en-us/article/Search-for-and-delete-email-messages-in-your-Office-365-organization-3526fd06-b45f-445b-aed4-5ebd37b3762a#step2 The Exchange Web Services API - When youi need message access and the msonline cmdlets don't get you there. https://msdn.microsoft.com/en-us/library/office/dd877012(v=exchg.150).aspx