Exchange 2013: Hide Mailbox from Address List

In an organization you might need to hide a mailbox from the GAL for some reason. The procedure to do this is quite straight forward and can be achieved using the Exchange Admin Center or the Exchange Management Shell.

Hide mailbox using the Exchange Admin Center:

• Step 1 -> Click on Recipients link.
• Step 2 -> Click on Mailboxes.
• Step 3 -> Click on the mailbox where you want to hide from the GAL.

Once you have located the mailbox you can double click it or click on the pencil.

• On the properties page for the user, ensure you are on the general tab/page.
• Look down to where you see the option to "hide from address lists".
• Select this option and then click the Save button.

Hide mailbox using the Exchange Management Shell:

• Set-Mailbox -Identity Domain\User -HiddenFromAddressListsEnabled $true

Updating the Global Address Book in Outlook 2013

Updating the Global Address Book in Outlook 2013

The Global Address Book (GAL) is a directory of available contact information for CUMC, NYPH and Columbia University faculty, staff and students. It can be accessed when using a CUMC Exchange account with Outlook or when logged in to the Outlook Web App.

If you are not seeing correct contact information in the GAL for someone that has a valid email address (i.e. someone who just received a CUMC Exchange account, a new student, someone who recently changed their directory information) please use the steps below to synchronize your computer's locally cached version of the GAL.

1. Select the Send/Receive tab in the upper left corner of Outlook.

2. Click on the Send/Receive Groups drop down menu, then Download Address Book...

 3.  The Offline Address Book window will appear. Make sure the following options are selected:

• De-check the Download changes since last Send/Receive option
• Make sure the \Global Address List is selected from the Choose address book drop down menu
  

4. Click the OK button at the bottom.

• The most recent version of the Global Address List will be downloaded from the CUMC IT Exchange server. You may see a status window indicating the download's progress, it will automatically disappear when completed.

5. Close Outlook when the download has finished. Re-open Outlook and log in; the Global Address List should now contain the most recent information.

• On Menus tab, click Folders menu
• Choose Recover Deleted Items in the drop down menu
• Then the Recover Deleted Items window pops up

If you have not Classic Menu for Outlook 2007 or 2010 installed

6. In Outlook 2010 and 2013, there is no Tools menu in the Ribbon.

• Click Folder Tab
• Move to Clean Up group
• You may see the Recover Deleted Items button lies in the group

Customize the Remote Connection port for an Azure V2 VM

Customize the RDP port for an Azure V2 VM:

Plan A outlined below is more straightforward, we first change the RDP port from inside the VM, then we make Windows firewall and NSG rule to allow the new port.

Plan B outlined below is recommended. We use a NAT rule to route customized port --> 3389. In this way, we can change the external port anytime later and it doesn't involve additional modify from OS level.

Plan A

Important: Don't cut the branch while sitting on the branch!!
So, in a nutshell please note that :) Do not restart the server when prompted until and unless completing below steps 1 to 3. This can be hectic if you change port from registry level (mentioned in step 1) and then restart without allowing firewall port (mentioned in step 2)
step 1)      Change RDP port on Windows level.

For the steps, please refer to https://support.microsoft.com/en-us/kb/306759

step 2)      Allow the customized port on Windows Firewall.

For the steps, please refer to http://www.howtogeek.com/112564/how-to-create-advanced-firewall-rules-in-the-windows-firewall/

step 3)      Allow the customized port on NSG.

To do this, go to Azure Portal, click on your VM name, click on Network Interfaces, click on the NIC name, select Network Security Group, click on the Network Security Group name, add the inbound security rule here.

Plan B

1)      Create the Azure Load Balancer.

2)      Create a Backend pool and associate it with the Load Balancer.

3)      Create a NAT rule to route the customized port to default 3389.

4)      Associate a NAT rule to the VM's NIC (VNIC)

For more detailed steps, you can refer to the articles below.

https://buildwindows.wordpress.com/2016/02/10/how-to-access-an-azure-virtual-machine-arm/

https://azure.microsoft.com/en-us/documentation/articles/load-balancer-get-started-internet-arm-ps/?tduid=(76e202f4792cf32043a1ac5c129e8af9)(256380)(2459594)(TnL5HPStwNw-83q5_sDR1pnM_oXQ3Pxz.Q)()

Troubleshooting The remote procedure call failed. [0x800706be] WMI Error in SQL Server 2012

SQL: You may end up getting "The remote procedure call failed. [0x800706be] WMI Error" when you click SQL Server Services in SQL Server Configuration Manager as shown in the snippet below.

This error pops-up when you have SQL Server 2008 or SQL Server 2008 R2 running along with SQL Server 2012 on the same machine OR you have installed Visual Studio 2012 OR while activating SharePoint 2013 features OR by activating any of the additional components you want to activate on the back-end machine (SQL 2012 & above) which thereby automatically installs SQL Server 2012 components.

One of the solution is to recompile MOF File to resolve "The remote procedure call failed. [0x800706be] WMI Error"

for this ..Open command prompt under administrative privileges i.e., using "Run as Administrator" and execute

mofcomp.exe "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"

Now, you can go ahead and open SQL Server Services under SQL Server Configuration Manger to see all SQL Server Services

BUT, in some cases we have experienced this may not turn out success for you.

So, make sure the SQL Server Configuration Manager which you are trying to OPEN is from the right executable version (SQL2008 or SQL2012) as there will be two executable files. So if you try to open the shortcut on a SQL 2012 installed machine you will definitely end up with EMI Error.. All what you can do is UNPIN and PIN the right executable.

Simple GB Convertion in Excel

Format bytes a cell in Excel as KB, MB, GB etc?

Right click a particular cell, Format the cell and apply a Custom category and add to the 'Type' field [<1000000]0.00," KB";[<1000000000]0.00,," MB";0.00,,," GB"

works in office 2010 and above without any issues.

Martin Luther King's - I Have a Dream speech by Tejas Rinith - Grade 5

Network Load Balancing and Virtual Machines: Tuneup

SharePoint 2010 Web-Front-End NLB Tuning (points to be noted before configuring Network Load Balancing and Virtual Machines on Windows Server 2008 R2):

When running NLB as a Virtual Machine (VM) guest using Windows Server 2008 R2 Hyper-V you need to be aware of some specific configurations settings in Hyper-V host prior to configuring NLB. If you do not enable spoofing of MAC address prior to configuring NLB on the VM you could potentially have problems with the NLB cluster. 

When configuring NLB in unicast mode on Hyper-V with enable spoofing of MAC Address disabled you may see some of the following symptoms:

• When initially configuring NLB you will lose network connectivity on the network adaptor NLB was configured on.
• Either of the nodes NLB status might show converging instead of converged and healthy status.
• There will be an NLB error event in the Windows Event Log stating that the network adaptor does not support dynamic MAC address updates.
• After rebooting the server, NLB will appear to be bound to the network adapter, but the cluster VIP will not have been added to the network adaptor.
• The cluster MAC address will still be the original MAC address associated with the network adaptor prior to configuring NLB.   Use CMD> ipconfig /all to view the MAC address.  It should start with "02-BF-***"
• If you ignore all previous symptoms and manually add the VIP you could get an IP conflict if there are other nodes in the cluster that have the same VIP.

With that said, to allow VM guests to run NLB you need to set the VM property for "Enable spoofing of MAC Address". 

To enable spoofing of MAC Addresses open the Hyper-V management console.  Make sure the VM is stopped open the properties of the VM.  Select the Network Adaptor for the NLB VM and check the "Enable spoofing of MAC Address" and click OK.  Then start the VM.

also refer articles from technet here http://technet.microsoft.com/en-us/library/cc917873.aspx