SQL Optimization Tips
SQL Optimization Tips: - Some techniques to write optimized queries in SQL which can make your life easy ! - 1) The SQL queries become faster if you select specific column names instead of using “ *
Actionable Web Log Mining
In the Web world Web sites pulls vast amount Web traffic across the world every day, leaving behind Web site traversal information in the form of Web server or query logs. Analysis of these logs can provide various
How to keep Team Motivated
It is always a challenge to keep yourself and your team motivated for a long time. If the team is motivated, it can take up any Herculean tasks and if things are wrong manager has to take some
Forum Integration in a CodeIgniter website
Months back I was trying to integrate phpbb in codeigniter based website. I didn't want that the users register for the forum. Site login/register controllers should handle the forum part as well. I din't find any good
We are Hiring – Be a Star in Auriga Constellation
Job Description - Yes Auriga is Hiring Again. Founded in 2009 to bring together higher standards of technology to improve businesses, Auriga has been quite ahead in achieving the targets. and that is why we are hiring again.
Basic Principle to make your Customer Happy :)
If we can do some basic thing right than we can keep most of our customer happy. We just need to watch our actions carefully and rest is simple. When you are running your business you are bound
How To Turn Off Post Revision In WordPress
One of my client was managing the Worpdress Blog for last 6 years. It was hosted on shared hosting and one day we received a notice from Hosting Provider that your database is acceeding the limit of
Export/Import Mysql database using SSH in Godaddy and other Server
Export Mysql Database How to take the back up of Mysql database using SSH - Enable shell access inside your Plesk control panel Using utility such as PuTTY, log into your server via SSH Change to the directory where you want
Facts about content writing
Before starting about the topic, we have to understand that what is the reason that is making it essential, in terms of making focus upon the content. It is just about explaining what that page is all about and
Solve Date format problem for Excel into SQL Server via PHP
We can upload data in database using excel easily but whenever we will upload any kind of date through excel than the uploaded date unrecognized sometimes. This is because of different supported date formats by different versions of
PHP Apache configurations
Server Request Response Flow-Â Apache is web server, Its job is to receive the request and send the response. So if I opens a web page mydomain.com/test.html . request goes to server, server checks the mime type(.html in
Password Hashing and Encryption
I happened to write this while I was digging into how Magento stores password. well magento stores hashed password separated by a two character salt in db. A sample looks like - 353dc2ba6108461cf3468184bdd0e174:QP split = 353dc2ba6108461cf3468184bdd0e174:QP magentoPass =
Software Project Lifecycle
I never realised criticality involved with Software Project Lifecycle until I became part of - -Undefined Requirements - Vicious cycle of Rework and Rework - Never Ending Projects - Bugs - Late Deliveries - Bad Cash flow
Auriga Day 2012
Whenever I talk about Auriga, the first thing that always comes to my mind is the trivia that Auriga is a Constellation of Stars. And it seems so true, thats what we are, a group of stars
Cart behavior on Login in Magento
While customizing Magento cart, if you are using quote id and item ids of cart in any reference then you must face a problem with login. If you have some thing in cart and guess your cart id
Transferring Domain from Melbourne IT to Godaddy
I had a domain registered with Melbourne IT for which they were charging USD 35.50 for one year. I decided to shift the domain to Godaddy which was much cheaper around USD 8.00 per year. The exercise was
Team Building Activity
Team Building activities plays a very important role and everyone including Management, Employees will reap benefits from this. It helps in bringing out the best in a team and cultivates leadership skills, positive communication and ability to work
Moodle Login Integration
Moodle login integration in other source Introduction  When we need Moodle integration in any site to use some functional part of Moodle like Quiz for that we have to create Single sign on between both platforms. For that
How to resize or make thumbnail images in PHP
When we display images on our web pages we use <img src="path" height="" width=""> tag but this is a hardcode method to display the images. Now suppose the uploaded image is of larger size then the image loading
Why you need to make a Facebook page for your website
Facebook is a very large social networking site. Intend to connect business associates, Facebook announced a feature called “Facebook Pageâ€. Now first question arose in mind what is Facebook page? Facebook page simply a public profile to allow