Wednesday, July 4, 2012

How to get the most for the price you pay?

 Money is earned hard way, it is very important to value money. I believe in this statement and make it a point to make the most value out of every cent I spend. People say I spend a lot of time thinking before buying any product, its true! I do so because I don’t want to miss out on some ongoing deal on a product and I ensure I do enough research before buying any product. So a good way to start saving a few extra cents on every purchase would be to simply find coupons. 

Coupons are everywhere, the internet, in your post, in store, etc. It just takes a little bit of effort and initiative to hunt for the right coupon. You will be surprised that a little bit of effort can bag you more items for less.

A good example is today, I was buying gifts for my folks back home and I selected all the products I wanted. Rather than doing the conventional checkout, I simply typed on google “coupons for xyz brand” and I found a whole bunch of coupons which saved my shipping cost and also gave me a discount of 10% because my order was above a certain bracket. This helped me save around 20$ on my overall purchase.

Groceries are a part of every individual routine, some might do it monthly, some might do it weekly or some might do it daily. You can simply run through your post mail real quick, in which local grocers usually send out deals and discounts. You can always get yourself the membership card of the grocer (any other store) and begin your savings right there. Recently, I was purchasing groceries from a local grocer and I shopped more than 50$ and availed of a coupon to a nearby gas station which got me 20cents/galloon off.

Gas is something I have to fill very often because of my daily driving requirements. Two gas stations where I know you could save up some dollars are shell and speedway.  Shell will offer you a discount of 10 cents/gallon if you ring in your Kroger plus card (please check for participating gas stations). Also, the discount applies if you get a car wash done from a shell gas station. 

For speedway you simply need to hop in to the convenience store (or apply for one online) and get hold of a speedy rewards card. One every refuel you earn points which you can redeem online for a variety of products.

I have attached the links below for convenience.
Speedway: http://www.speedway.com/SpeedyRewards/     

Shell: http://www.shell.us/home/content/usa/products_services/on_the_road/fuels/grocer_rewards/kroger/

Student discount: If you are a full time student registered with a university, you are very lucky! The university usually has a tie up with various companies to deliver products to students at a subsidized price. Check with your university for more details.
In my amazon student account blog post you can find how you can avail free shipping and savings on prime eligible amazon products for students.

July - August is a great time to eye various brands and look out for "Back to School offers".
A good way to shop for the products you need and at the same time save a good amount of money.

I will add a few more “value for money” ideas soon on to this page.

Keep viewing J



Thursday, June 28, 2012

SQL Capabilities - Common Table Expression (CTE)


This is the first of many blog posts of I am writing based on the interesting features of various technologies I have discovered in the recent times and especially during my internship.

The technologies I have been working on during my internship are, eclipse with BIRT capabilities at the front end and sql server at the back end.

I have been working with SQL server since a couple of years now and I am always finding some new (and more efficient) way of writing a particular query.

Just this morning I was working on a few queries (parent query) which required a single query (child query) to be called multiple times at different points of the parent query. I was initially approaching this to be one of the usual copy – paste jobs bound together by a “union” clause. But then I felt that there would probably be a more efficient way of approaching this task. I did some research and wasn’t very surprised on finding a sql capability to handle this task in a very efficient manner.

This sql capability is called “Common Table Expression”.  It basically allows the user to define the query which is to be repeated, once in the beginning of the parent query. Once this is done, the query data can be utilized at any point within the parent query.

Common Table Expression Syntax
A Common Table Expression contains three core parts:
  • The CTE name (this is what follows the WITH keyword)
  • The column list (optional)
  • The query (appears within parentheses after the AS keyword)
Example:
;with sales as (
SELECT TOP 10 CompanyID, CompanyName, SUM(GrossSales) [GrossSales]
FROM CompanySales
GROUP BY CompanyID, CompanyName
ORDER BY SUM(GrossSales) desc
)


select * from sales
union
SELECT -1, 'Other' [CompanyName], SUM(GrossSales) [GrossSales]
FROM CompanySales
WHERE CompanyID NOT IN(
                    select companyid from sales
)

So as it is seen above, the output was required to display the TOP 10 values from the CompanySales table and group the remaining values in the “Other” category. If this is approached with the conventional copy – paste method it would require the first query to be repeated multiple times at different points within the parent query. The CTE capability eliminated the unnecessary repetition and certainly enhanced the query performance. 

Wednesday, May 30, 2012

Podcasts


I am interning in Columbus, Indiana which is a good 50 minute drive, one way from Bloomington.

It is a great drive which after a short period of time became a routine. After a few days of hearing the same music over and over again, I realized that why not make this travel time more productive.  In this fast moving world where to remain in sync with what is happening around you is not only important, but required I decided to load my cell phone with podcasts.
Podcasts are short episodes of audio/ video/ combination of both files based on various topics such as technology, sports, news, etc. You can load them onto your cell phone or music device and hear them on the move. You can also stream them online and listen to them on your computer.
Seems like a tedious process right? Well it is not. You just need to have the iTunes music player installed on your computer and a steady internet connection.
I will run you through the steps real quick.

Download iTunes (if you don’t have it)

On the left hand side, you will see podcast, click on it.











You can either enter the podcast (category) you want to search for or browse the directory of podcasts iTunes has to offer.



iTunes Store Podcast directory screen

Here you are, stream / download whatever podcasts you are interested in.















Once the podcasts is downloaded, you can access the mp3 / mp4 files from the windows explorer.  
Simply go on your downloaded podcast, right click on it and click on 
“Show in Explorer”

Monday, May 14, 2012

Actuate BIRT webinar


BIRT (Business Intelligence and Reporting Tool) is an open source software which provides business intelligence and reporting capabilities. I have been working on this tool since quite some time and I enjoy every bit of it. Actuate is the creator of this tool and takes a lot of effort to create awareness of this technology amongst the masses,roadshows and webinars being the two most popular initiatives.  I have attended a few of their webinars in the past and I am looking forward to attending the one on Thursday (17th May) particularly because it is on business intelligence for financial services – optimizing the customer experience. I work in the finance domain and hence this webinar would be a good match for what projects I am working on currently and in the future.

For a comprehensive list of webinars:


Business intelligence for financial services – optimizing the customer experience (17th May)

http://www.actuate.com/info/q212wsem-financialservices/ 


Below, is the link to the archived version of this webinar:


Hope this helps.

Cheers :)

Soups by design , Columbus - Indiana


After having a really light and tasty lunch, I felt the urge of posting this out here. I work in Columbus, Indiana and recently discovered this really interesting eatery called soups by design in downtown Columbus. It serves a variety of soups combined with a portion of bread, cookie and a choice of sodas/juices for just $5. I had a thai coconut curry soup today and it was really nice. It was quite close to the traditional sambhar that is prepared in India to be had along with dosa (rice pancake).


Amazon student account


An amazon student account is a good way for students to manage their money well and save some of it by getting rid of taxes and shipping costs on eligible items. I use this account and get really good deals on the items that I need to purchase. To avail this benefit you must be pursuing some sought of education at school / college and must have a valid (not expired) student id.


Sunday, May 13, 2012

List of websites which come in handy in day to day life


Hey, I just felt like putting down a list of websites / apps which come in handy for day to day use and what can be extracted from each of them.

Facebook : Social Networking

LinkedIn : Professional Networking

YouTube : Browsing video, listening to songs 

Spotify : Listening to songs on demand

Big4.com : A good resource for those who plan on getting into a big 4 firm.

Stackoverflow.com : A good resource for technologists who are working on projects and require solutions to various technical issues.

IEEE Computer Society Digital Library : A paradise for computer freaks who love to be up to date with technology in general.

Wikipedia : Online encyclopedia which has information of almost anything and everything you want to know of

Forbes : Source for reliable business and finance information

Bloomberg :  Source for reliable business and financial market news

Harvard Business Review : Brilliant source of information which addresses various topics and challenges faced in business 


All the websites mentioned below are very good sources to find white papers and articles on various domains within technology:

codeproject.com : Software development and design

whitepapers.technologyevaluation.com : a good source to compare technologies when making a technology purchase decision

computerworld.com : be up to date with the happenings in the computer world


Data Science central : A good online resource for the current boom "Big Data'


I have added a link list on the right side bar for ease of use.. 


Cheers :)