SSRS jobs in MSDB

January 8, 2016 at 10:00

When you have Reporting Services (SSRS) running in your environment and have created subscriptions to reports you will notice these very descriptive jobs appearing on your SQL Server with names like 38EE888E-5943-4CCE-9EA9-26240B226BB4 or 9C2C8FAB-83EB-408E-AEA2-BD9C59DA4951 or something else ;). When you open the properties of these jobs you hope to find a […]

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 […]

Check for database files not in default location

April 21, 2015 at 20:50

This week I discovered a database with its files not placed in the default folder (it was in fact installed in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ :(). It turned out the creation of this database was done using a script provided by the manufacturer, ignoring the default file location settings. I […]

SQL Server error 17310

April 14, 2015 at 20:33

The problem Recently I had to migrate a SQL2005 database to a SQL2008R2 instance. So I picked up a copy of the database and restored in onto a test server. After restoring the database I changed a few settings (change compatibility mode, set page verify to checksum, changed recovery model) […]

Trace flags in SQL Server

April 3, 2015 at 15:56

Trace flags in SQL Server allow you to change the behaviour of parts of SQL Server. Most information about trace flags can be found in several KB articles but usually this information does not provide too much detail.