Shrink MS SQL database

Written by Denis Stadler on 9 June, 2011. Posted in SQL Scripts, SQL Server

Many times when I was developing SharePoint or CRM solutions on virtual machines (yes with small virtual hard disks) it happened to me at some point to receive a lot of unexpected errors.

This happened because of full disk. The quick and dirty fixes for development are truncation of the database log file and shrink the database.

To do this operation you should open the Microsoft SQL Server Management Studio. Click on the New Query button.

Use the following code:

-- replace UserDatabase with you own database name use UserDatabase backup log UserDatabase TO DISK='NUL' dbcc shrinkfile (UserDatabase_log, 1) GO

Continue Reading No Comments

My first mission – Svendborg, Denmark

Written by Denis Stadler on 1 June, 2011. Posted in Personal Thoughts

When I was a child I used to listen to an old vinyl having recorded stories written by Hans Christian Andersen. Coincidence or not my first project as a contractor was in Svendborg, Denmark less than 50 km away from Andersen’s home town.

My mission here was to do a Sales Force Automation project based on Microsoft Dynamics CRM 4.

I had a very pleasant time and what I can say is that the city really deserves a visit: a very calm blue sea with fairy-tale houses.