Elam's Personal Blog

Shrink LDF file in SQL SERVER 2008

Elamparuthi SK — Tue, 27 Mar 2012 14:08:39 PDT

Today i had a problem. when i checked my database LDF file (log) file it’s some where around 25GB. I was trying to shrink the file it’s not possible. Could not able to shrink it from management studio. Found an workaround for that, Here the command for it. First make the database to SIMPLE Recovery [...]

Steps to check website and Sql performance

Elamparuthi SK — Sat, 24 Mar 2012 15:37:19 PDT

Hi all, It’s been very long time since i updated my blog. i am really sorry for that. Well coming to the topic. I was working for one of our entrprise customer. We have web analytics data close to 90GB. we are building another application to displaying the data, so i need to migrate the [...]

Google Analytics Sub Domain Tracking

Elamparuthi SK — Wed, 01 Feb 2012 09:34:59 PST

Today I had an issue For one of our customer. They had implemented the Google analytics tracking code in their website and they have so many sub domain which they want to track in main domain GA profile Id. They had implemented the Ga code properly and also used _gaq.push(['_setDomainName', '']);, but the problem is [...]

Back again

Elamparuthi SK — Tue, 20 Dec 2011 10:19:44 PST

Today my friend karthi told me how my blog was useful to him and his team on the project. I was really happy. I stopped updating my blog regularly because of poor response of visitor, today when he said that I was really happy and plan to update my blog on regular basis because I [...]

Google Analytics Premium

Elamparuthi SK — Thu, 29 Sep 2011 12:12:09 PDT

Today Google had released the google analytics premium account with the price band of $150,000 per year, i was really shocked on the price band, no idea how many enterprise customer will go for it. In general google analytics premium account we have some nice stuff like Run sql query aganist your data Client will [...]

Twitter hacks [infographic]

Elamparuthi SK — Tue, 27 Sep 2011 22:53:52 PDT

Nice infographic on twitter hack Infographic by Veracode Application Security Elam Tweet

Facebook f8 features

Elamparuthi SK — Thu, 22 Sep 2011 12:58:22 PDT

First my impression on the features they had released is WOW. Actually couple was week back I was thinking “what I was doing last year same day”. Try to find that in facebook I try scroll my wall to find but could not find it because of the amount of status msg I had, now [...]

Solving Facebook tshirt spam

Elamparuthi SK — Wed, 14 Sep 2011 12:02:00 PDT

Today when I was looking into my facebook wall I found most of my friends was posting the free facebook tshirt. When I ask them they told it was spam. When I try to debug further on the spam i found the problem. They did it in smart way. actually they ask for your name [...]

Are You Addicted to Angry Birds? [INFOGRAPHICs]

Elamparuthi SK — Sun, 11 Sep 2011 22:02:38 PDT

Nice Infographics on Angry bird game by AYTM.com. I remember when then time angry bird was release i used to play for hours.. Now it’s changed i am playing it frequently, only when i was bored i used to play Infographic by: AYTM Market Research Elam Tweet

Install Cassandra 0.8.5 in windows 7

Elamparuthi SK — Sat, 10 Sep 2011 10:35:29 PDT

Today i was exploring Nosql option and found Cassandra 0.8.5. you can download the latest version from here. After Download Follow the Below steps Step 1: Download Java JDK also from here Step 2 : Install the JDK Step 3 : Unzip the Cassandra file to some location in your local drive (D:\dev\) step 4 [...]