Ninja Database Lite is a light and nimble database for Windows Phone 7, Silverlight 3, Silverlight 4, .NET 3.5, and .NET 4.x

you can download the full feature list here.

You can get Ninja Database Lite Single Developer License for free until midnight October 31st, 2010; a $49.99 value.

Use coupon code :  twitterninja

Steps :

1. Go to http://www.kellermansoftware.com/c-9-windows-phone-7.aspx
2. Select Add To Cart for  Ninja-Database-Lite -Single Developer License 
3. Enter Coupon code twitterninja in coupon code and click Checkout Now
4. Go register and checkout
5. Complete the registration form.
6. Click Create account and checkout.
7. It will not ask you for making payment or credit card information since your effective amount to be paid is zero.
8. Done…

Spread the word and enjoy.

Excel is excellent. No doubt about that. But excellence does not mean that, it will not have glitches. So Excel also have few !!!

Recently, We wrote a small data migration utility for our clients which reads data from Word file and store it in excel. The entries included Credit Card numbers which has 16 digits.

In all surprises, Excel was doing magic. When you enter a number greater than 15 digits, Excel rounds it off and you get zeros padding the end of your number.

Example :

Enter the number

234587654567123456 in Excel

and you get this

234587654567123000

          Solution:

Excel supports 15 digits of precision in its cells. Credit card numbers are usually 16 digits.For identifying numbers, you should enter them as text. To enter a number as text, precede the entry with an dash (-) or format the cell as Text (Format>Cells>Number) before you enter the number.

Note : Tested and replicated in Excel 2007, Excel 2010

Godaddy Virtual Dedicated machine, Windows server 2008, PLESK 9.3, New Web application setup and I was greeted with below YSOD.

Problem :

As the error message said, Access is denied. It means that the user account under which asp.net is running is trying to access resource without having sufficient permissions on that resource.

Solution :

1. Login to your Virtual Machine using Remote Desktop ( mstsc )

2. Go to “C:\plesk\etc\DiskSecurity” folder

3. Edit disksecurity.xml file. Add following entry at the end ( before </Entries> )

<Entry AccounType="1" Account="Psacln" Path="C:\Windows\assembly" AceFlags="FilesOnly" AccessMask="Read" EntryFlags="0x0" />

4. Save.

And you are done… Enjoy…