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 […]
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 […]
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 […]
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 […]
It has been the month of challenges. First there is the #SQLNewBlogger Challenge. In March Ed Leighton-Dick (b|t) called out to everybody to join him in this challenge and publish a blog post every Tuesday in April. After reading it I decided to join the challenge. I have published 3 […]
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 […]
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 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.