Setting up errorlog maintenance

December 24, 2015 at 14:00

After installing a new SQL Server instance the default configuration of the errorlog is to keep the 6 most recent files which are only re-initialized after a service restart. This means that after 6 service restarts you start to lose information, on the other hand if you very rarely restart […]

Logoff from a RDP session on a Windows 2012 Server using Powershell

December 18, 2015 at 14:00

When you have a RDP session to a Windows 2012 server and you want to logoff, it can be a struggle to find the log off switch (try to get the charms bar on a slow connection can be difficult). The easiest way I found to log off is to […]

Prevent your errorlog from bloating

December 11, 2015 at 14:49

The errorlog in SQL Server stores information about errors and events occuring in a SQL Server instance. These errors include messages like failed login attempts, (un)successful backup messages, Availability Group failover messages, instance configuration information and mini stack dump information in case something went wrong. Depending on the settings of […]