TechSoft Solutions

Web and Database Development, General Tech tips and Tricks and TechLabs TV IT Training services.

  • Rails 3 rename_column migration as per my experience

    This a just simple demonstration that bothers since most of other rails migration you doesnt need to edit the migration file. It has been explained clearly at StackOverflow. For my case scenario i have a users table with password column. I want to rename the column to hashed_password. Step 1: Write the rails migration ...

  • Can’t connect to MySQL server on ‘localhost’ (10061) in Rails 3

    This is a simple workaround regarding an error which happened to me today when running db migration in Rails 3. I have Rails 3.2.2 and MySQL 0.3.11. I was trying to run bundle exec rake db:migrate to create a table in database. I got this error rake aborted! Can't connect to MySQL server on ...

  • Apache Port 80 collision simple solution

    Most people that are new to Apache spend most time in a war between Skype, microsoft HTTP/2.0 service and Apache of which all compete for port 80. I will spend less than two minutes showing you how the war can end. Fortunately its very easy to configure Skype to use different port. Live ...

  • SQLCMD tip

    This tip is on how to use sqlcmd to get all databases in your SQL server. Note that you have to include sqlcmd exe in environment variables of windows system. The format of the tip is like sqlcmd -s <db server or instance> -q "exec sp_databases" Open your command prompt and paste ...

  • DBA and Project Manager positive effects to my organization

    As such, as DBA\Project Manager you have the ability work from the bottom up to make changes which can have a ripple affect across the organization.  You make ask how is that possible, I am totally overwhelmed and I need to keep the boat afloat, but I want to be ...

I have lately moved my ruby to another framework (MetaSploit in specific)  from Ruby on  Rails. Dont mistake me, i am still Ruby on rails fan. As i set up my backtrack 5,  the system sometimes hibernate and when i want to resume the system could not  hence forcing me ...

Continue

Differences between IPv4 and IPv6

Posted by Samuel K Itotia 0 Comment

This table shows a brief description in differences of IPv4 and IPv6. Category IPv4 IPv6 Address length 32 bits 128 bits Notation style Four sets of three digits Eight sets of four digits separated by a dot   Compression If all three digits are zero, single zero is used If all four digits are zero, a double colon is used Types of addresses Public, ...

Continue

In ruby, there are so many ways of achieving the same functionality using different ways. In this small article I would like to show different method of defining class Methods in ruby First way is getting into class’s scope and defining a self method the as follows: class HisClass def ...

Continue

This is an error that is always caused by a gem in your Gemfile.lock. multi_json-1.3.1 is just example here as it most occuring in my system.       Solution 1. Delete the Gemfile.lock and the following command: bundle install Solution 2. Open Your Gemfile.lock with your text editor. Find your specific gem and in this case multi_json-1.3.1. The Format of ...

Continue

This a just simple demonstration that bothers since most of other rails migration you doesnt need to edit the migration file. It has been explained clearly at StackOverflow. For my case scenario i have a users table with password column. I want to rename the column to hashed_password. Step 1: Write the rails migration ...

Continue

This is a simple workaround regarding an error which happened to me today when running db migration in Rails 3. I have Rails 3.2.2 and MySQL 0.3.11. I was trying to run bundle exec rake db:migrate to create a table in database. I got this error rake aborted! Can't connect to MySQL server on ...

Continue

Most people that are new to Apache spend most time in a war between Skype, microsoft HTTP/2.0 service and Apache of which all compete for port 80. I will spend less than two minutes showing you how the war can end. Fortunately its very easy to configure Skype to use different port. Live ...

Continue

SQLCMD tip

Posted by Samuel K Itotia 0 Comment

This tip is on how to use sqlcmd to get all databases in your SQL server. Note that you have to include sqlcmd exe in environment variables of windows system. The format of the tip is like sqlcmd -s <db server or instance> -q "exec sp_databases" Open your command prompt and paste ...

Continue

As such, as DBA\Project Manager you have the ability work from the bottom up to make changes which can have a ripple affect across the organization.  You make ask how is that possible, I am totally overwhelmed and I need to keep the boat afloat, but I want to be ...

Continue

As a DBA I will like to point some of the good recovery strategies of database recovery and their benefits. Remember your backup is never good unless proven good.  A good practice is: A verification process that enables you to ensure your recovery strategy meets your business requirements. Once you have ...

Continue
  • RSS
  • Delicious
  • Digg
  • Facebook
  • Twitter
  • Linkedin
  • Youtube

Popular Posts

Can't connect to MyS

This is a simple workaround regarding an error which happened ...

Windows Photo and Sl

As per daily schedule to test and diagnose computers in ...

Apache Port 80 colli

Most people that are new to Apache spend most time ...

Building clusters wi

Clustering in Windows Server 2008 has been radically redesigned to simplify ...

What is Rhomobile an

Rhomobile is an open-source Ruby-based mobile development framework for business ...

Sponsors

  • Cheap reliable web hosting from WebHostingHub.com.
  • Domain name search and availability check by PCNames.com.
  • Website and logo design contests at DesignContest.net.
  • Reviews of the best cheap web hosting providers at WebHostingRating.com.