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.
Using Powershell to make a secure connection to Exchange. Why? Because no password should be stored plain text, ANYWHERE!
Powershell: 4.0 or greater
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:
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.