Bytes and Bites of Internet
Archive for July, 2012
What’s the point ?
Jul 29th
Like many people, me too don’t like to install stuff in default C: drive. I think that sine C: drive is a system drive it should exclusively used for system files only. And all other programs should be installed in drive other than C:. But you will be surprised to find that there are many programs that simply won’t work well if you install them in drive other than C.
There are some other kind of programs which even if you select non-system drive .. it gets installed in both C and that other drive !! Mostly because they are bound to some sort of shared components or assemblies which can only be installed in C drive … or may be because who ever created those programs just wanted to have some common ground … I have no idea about actual reason.
Just like that I installed Light Switch few days back, and since I have installed VS 2010 in D drive it default to D drive… but even after that it still installed many of its files into C drive too !! Just look at screenshot of installation below …
Easy URL Rewrite in IIS
Jul 22nd
URL rewriting is a process of shortening URL of web pages and making them more user friendly. If you have been working with MVC then you probably already know what I am talking about. But what to do if your application is plain old Web application? Having user friendly URL really simplifies things for end users. Imagine a product URL for your company is http://someCompany/Products/list/ProductName.aspx , which is definitely not helpful to customer who is trying to reach to that product page directly (only way probably is to create a link on some page). But with help of URL Rewrite you can shorten this URL to http://someCompany/Products/ProductName a user friendly URL, isn’t it ? Besides having good lookin’ URL another advantage is it hides actual directory structure from outside world.
In this post I am going to show how easy it can be to use this great little module.
First, if you don’t have this module it can be downloaded from IIS website or using Web PI (if you have downloaded Web PI before then chances are you already have it). Once it is installed, you will see it in IIS Manager (see screenshot below)
Finally I got Beans !!!
Jul 16th
With so much of hype, I was eagerly waiting for my chance to try latest Android OS on my phone. I must say it was one of the main reason I bought the Galaxy Nexus from Google … to have pure Google experience and always have support for latest OS release.
Just now I got notification in my mobile and with surprise it was an OS update request from Google.
It looks like that update is about 147MB. And installation took about 2-3 min after reboot and now I am officially using Jelly Bean 
(I know, in our basement both WIFI and Cell Network sucks)
Page level recovery in SQL Server 2012
Jul 8th
Database corruption can be difficult to detect and sometimes it is very possible that you might not even notice it until you run DBCC command on your database to check logical and physical consistency of that database. It is very common practice to run DBCC CHECKDB without any additional options at regular intervals to make sure that database isn’t corrupted. Whole database corruption recovery process is a bit tricky process and there are many different factors effect steps of recovery. And I think it takes lots of time and experience for someone to be very good at database corruption recovery (and I can say that I am not even 1/2 good at it, but I am learning). In many cases if you find corruption easiest way is to just restore “good” copy of database, but this might not work if you have this “good” copy years old .. or worse you don’t even have that “good” copy …. and based on your case recovery process will very largely.
The point of this post is to show an addition of new feature introduced in SQL Server 2012 which will surely help greatly in process to recover individual page of database. But before we try that you need to have a corrupt database 
.. naturally. For this I found this nice little post about how to corrupt database by Kendra Little. Just make sure to take backup before corrupting database to simulate real life situation (which again, not always stands true).