Looking back at April

April 29, 2015 at 00:05

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

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