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
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
Today is the end of 2011 and ushering in 2012. I have prepared a great CSS3 Happy new year gift for you. This is 3D slideshow where I have used WebKit CSS 3D transforms. On the demo you will 3D polygon object with photos and text which have a bit ...
Continue
This is a small representation i learned on how you can simply create sticky notes using CSS3 only. Click on the link below to see the demo. DEMO DOWNLOAD DEMO CODE You can copy paste the Code on your editor and it will be up and running. If you got any questions. Drop ...
Continue
Run the command below to see the results select @@version The results of the command will include: The version of SQL Server you are running. If the SQL Server has been updated with a SQL Server service pack, then next to the version you should see the service pack level. If you see (RTM), ...
Continue
I will use the CharIndex function to find the location of the at symbol @. The result then, I will subject to Substring function to display the characters after the @ symbol, add 1 to the position of the @ symbol. The Simple Query you can reuse is as follows. You ...
Continue
