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

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