Monthly Archives: October 2012

ILT – How To Change SQL Server Default Database?

16-10-2012 I have been annoyed by having to change the database from the available databases drop-down whenever I want to write a query. This was because the default database which is always selected was the “Master” database which I never … Continue reading

Posted in Social Science, SQL Server | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

Virtual Laser Keyboard – How it works.

20-02-2009 Computer is the electronic device that has been evolved in the most rapid phase over the time. All parts that all together compose the computer now have come a very long journey when compared with their ancestors. The keyboard, … Continue reading

Posted in General Computing | Tagged , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

The transaction log for database is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

09-10-2012 I got this error today for one of my test databases. Following are the steps to solve this. Step 1 The error message gives a hint to look in the log_reuse_wait_desc column in sys.databases table. So we will just … Continue reading

Posted in SQL Server | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

ILT – How to Programmatically Get Version Information of a Visual Studio Solution

03-10-2012 How to get major, minor, build and revision version figures for a visual studio solution (using c#)? Menol ILT    

Posted in C#.Net | Tagged , , , , , , , , , , , , , , , , , , | Leave a comment