Tuesday, June 22, 2010

Recommended Software Related Tools

Source Control and Bug track:
http://www.mantisbt.org/ , Mantis: Open source bug tracking system for multiple projects. It is free!
http://git-scm.com/ , Fast version control system. It is free and open source.
http://subversion.tigris.org/ , Subversion: Open source code repository and code control. Multiplatform and feature rich.
Windows Administration:
http://www.SysInternals.comMicrosoft acquired Sysinternals in July, 2006. Whether you’re an IT Pro or a developer, you’ll find Sysinternals utilities to help you manage, troubleshoot and diagnose your Windows systems and applications.
Web Development:
FireBug, Excellent addon tool for Fire Fox. You should have this.
NotePad++ Very good geneal purpose text editor.
WAMP Apache, MySQL, PHP on Windows. Single install with utilities if you don't want to mess with configs.
jQuery: Excellent javascript library. Check also JQGRID and JQuery UI tools. 
Desktop Apps:
7-Zip, file compresison, multiple formats, open source.
FileZilla, my FTP  
Portable Apps, you can carry your favorite portable programs in a USB drive. Use any USB flash drive, portable hard drive, iPod/MP3 player, etc
 http://eyeos.org/ open source web OS. There are others out there, but this is Open Source and apears stable.
 Content Management Systems:
CMS Made Simple: It is really simple and powerful. You can add code snippets inside layouts and it is evaluated in run time. It has admin menu to change layouts and styles. you can also edit them. You can install different Modules or develop your own module. It has good level of supporting documentation. 

Thursday, June 10, 2010



What happens if you delete default database for a user in sql server?
--You will get an error msg as : Cannot open user default database
--Easy solution:  
1- Click options in login window

Login Screen in SQL Server Management Studio

2-Set database to master or model

Change database for connection

3-This will fix your login problem. Next step is to find your default database and change that. It is normally located in security> logins> your loginname

Find your Login settings in security tab

4-Change your default database if it is not changed. 

Now, you can fix the problem with your default database. Here is the cause of the problem from Mic:
The user default database is unavailable at the time of connection. It is possible that the database:
  • Is in suspect mode.
  • No longer exists.
  • Is in single user mode and the only available connection is already being used by someone else or by something else.
  • Has been detached.
  • Has been set to the RESTRICTED_USER state.
  • Is offline.
  • Is set to emergency status.
  • Does not have the login account mapped to a user or the user has been denied access.
  • Is part of a database mirror.
Additionally, the login account may be a member of multiple groups and the default database for one of those groups is unavailable at the time of connection.-->