Tech Tips and Tricks
While creating a new application in RoR (on cygwin), I was having issue installing ‘pg’ gem. After a little research I found that you need to install pg-client and pg-devel libraries to install ‘pg’ gem. Even after installing both devel Continue reading RoR – cygwin install – pg gem
Use regedit to edit the following registry key: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders Find the value name called “Desktop” and set its data to the desired location for your desktop.
rails new myapp –database=postgresql
I found a great tool for validating Regex expressions for my C# project. RegexHero – a great tool!
Once transaction log is full, I was unable to shrink it. All searches in Google did not help. Finally I found a script which clears the transaction log if and only if the transaction log is not full yet. I Continue reading Shrink transaction log SQL 2008 r2
Run the following SQL statements to fix the issue: EXEC sp_resetstatus ‘yourDBname’; ALTER DATABASE yourDBname SET EMERGENCY DBCC checkdb(’yourDBname’) ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB (’yourDBname’, REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE yourDBname SET MULTI_USER Please see here Continue reading SQL Server 2008 R2 (Suspect) mode – how to repair?
Follow these steps a) Right click on local code repo b) Go to TortoiseSVN > Settings c) Go to “Network” d) Browse for SSH Client and use following “C:\Program Files\TortoiseSVN\bin\TortoisePlink.exe” – Can be found in TortoiseSVN installation folder d) Append Continue reading How to save password in TortoiseSVN
Full-import http://<host>:<port>/solr/dataimport?command=full-import Delta-import http://<host>:<port>/solr/dataimport?command=delta-import status http://<host>:<port>/solr/dataimport reload-config http://<host>:<port>/solr/dataimport?command=reload-config abort http://<host>:<port>/solr/dataimport?command=abort
I found an interesting link which helped me to speed up the eclipse loading time. Let me know if that helped you.
Sometimes it is necessary to set the starting value of MySQL auto-increment value. This can be set as alter table table_name auto_increment=XXXX where table_name is the name of the table and XXXX is the starting value of auto increment