Secure connection to Exchange 2013 with Powershell

Summary:

Using Powershell to make a secure connection to Exchange. Why? Because no password should be stored plain text, ANYWHERE!

Versions:

Powershell: 4.0 or greater

Exchange: 2013

Instructions:

First you have to create a secure string from the password of an account. This should be done on the server/workstation that will make the connection in the future. Do this by executing:

Continue reading

Shrink MS SQL Temp database using T-SQL

Problem:Temp database on SQL has grown to full size of the disk. Usually because of a bug/error in a scheduled task. There is no need to increase the disk size or replace with another disk. However other files (temp db log, …) are not able to perform well when the disk where they reside is full.

Shrinking our temp db is the only solution. Best practices tell us to always do this with a restart of the server. Sometimes, this just isn’t an option.

Solution:

Got this script from a colleague.

Continue reading