Instances instances instances or SQL server consolidation

This post is about the (lack) of usage of Microsoft SQL Instances or SQL instance consolidation.

In the wild you see a lot networks where there are several (small) SQL servers. And if you want to save costsĀ our keyword should beĀ consolidation.

When should you think about consolidation?

  • You have more then 2 SQL Servers in your environment? Oh yes, those nasty SQL Express editions delivered with several software packages. I mean you too.

Continue reading

Secure connection to Exchange 2013 with Powershell


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


Powershell: 4.0 or greater

Exchange: 2013


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.


Got this script from a colleague.

Continue reading