How to check your Apple device such as IPhone warranty?

Buying iPhone or any apple device seconds hand is not always get the real product. I do not mean to all markets It is just for some markets where product is where the seller would like to take huge profit from selling a fake device mixing with this real one. Sometimes we can come into a situation where fake device is showing up. It is not easy to differentiate the real and the fake one. The fake one is always made in the way where simple notice hard to identify. This is the case of when you want to buy second hand products. If your device is running into the case where hardware failure is happening what should you do? Does warranty is still valid? Should you contact support with free of charge?

By checking their manufacturing specifications is one of the things that we could avoid failing into a fake products. It is not just finding fake or original one but also can see whether the device is still in warranty, phone support, …

Currently we can check on Apple website to see whether IMEI(International Mobile Station Equipment Identity)

Where and how can you find IMEI number of your iPhone device?

  1. Through the box of your device

IPhone Box


  • Short cut code


Once you can access to dial number, you can easily check device IMEI via short cut command *#06#.

IPhone ShortCut Key

The IMEI code is immediate display just when you finished typing last code ‘#’ of the *#06#

IMEI display


  • Phone settings


Phone settings is where every specifications are displayed not just only IMEI. It has also serial number, Operating System version, …

You can get those information by going in to Setting -> General -> About


Read More

How to open SQL Compact Edition file(*.sdf) in Visual Studio or LINQPad?


I try to look for some tools to open a sample database attached with application development sample on the net. I have found that the file has an extension .sdf. It make me strange at first because I do not really know what that file extension would be. Would that possible a database file or just a flat file? It is exactly as what I thought, it is an extension file for an SQL Server Compact Edition. A sample of Northwind.sdf (SQL Compact Edition 3.5) file can be download from my backup here.

Microsoft SQL Server Compact (SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops. Prior to the introduction of the desktop platform, it was known as SQL Server for Windows CE and SQL Server Mobile Edition

This guide is provide the step on how to open the file content using either extension is Visual Studio or standalone application call LINQPad. I made these to share with you all in case that you need to see the data, schema of that SQL Compact Edition look like.

Currently there are two possibility to open .sdf (SQL Compact Edition):

  • Using Visual Studio toolbox

Visual Studio logo
It is support in Visual Studio 2015, 2013, 2012, 2010. You need to download SQL Server Compact/SQLite Toolbox from Microsoft or from my backup and install it into your PC.


Here are the step to integrated into Visual Studio:

    • Download SQL Server Compact/SQLite Toolbox for Visual Studio

You can download toolbox for Visual Studio from Microsoft Web site or from my own copy of SqlCeToolbox. in case of previous link does not works.

    • Install toolbox extension

Before installing it is a must to close your Visual Studio if you are currently open first otherwise you can not see the change effect to your IDE, then double click on the file you have just downloaded to proceed to the setup process.

SQL Compact Toolbox

    • Install SQL Server Compact runtime

The Toolbox requires one of these SQL Server Compact runtime MSIs to be installed, if you want to connect to a SQL Server Compact database file:
Download 3.5 SP2 – installed with VS 2010
Download 4.0 SP1 – installed with VS 2012 (No runtimes are installed with VS 2013 and VS 2015)

    • Open Visual Studio to see toolbox extension being installed

Once the toolbox is installed, now it is ready for the feature of opening *.sdf file extension in Visual Studio.

SQL Compact Toolbox-002


It is time to try it out by your self from Northwind.sdf Read More