JailBreak Iphone 4.1.2

Hey guys, here i would to share my experience in jailbreak Iphone using Redsnow, for concrete I implement this method on Iphone 3G, these were the steps

1. Connect you Iphone to Itunes,
2. Turn the Iphone off by hold power button on upper right corner for few seconds and slide off
3. Download this tool RedSnow 0.9.6b5 for windows, you can google it to find in the internet, it’s free.
4. Download IOS 4.2.1 for 3G, you can directly download from Itunes or googling to download it.
5. Click "Browse" and specify your "IOS 4.2.1" with IPSW extension,

    

   

   if the Redsnow can read your IOS file then message "IPSW successfully Identified"
   At this screen below you can specify the feature you would like to install in your jailbreak iphone,

   

After that you will be asked to follow the instructions to enter the DFU mode, Detail Entering DFU mode

Entering DFU (Device Firmware Update) Mode In Iphone

1. First you should turn off your Iphone.
2. Press the power button to turn on the Iphone for few seconds,
3. Once you see the white the apple logo, press the home button at the same time with power button, the screen will glitch and white screen will appear for a moment,
4. After the 10 seconds release the power button but keep holding the Home Button.
5. After couple of seconds around 15 – 20 seconds, you will be in DFG Mode (you will see notification at right bottom about this state)
6. Once it was in DFU mode, the screen will be black.

Note:

DFU mode bypassed the current installed OS and allow you to upgrade or downgrade your OS.

Small Talk About AS400 & DB2

These are the points that I can share

1. If we you speak about AS400 machine or RPG, then you are talking about DB2.
2. There are available DB2 for different platform that you can download and install locally (www.db2University.com,  this website has provide link to DB2 express even you can take a course freely)

MSSQL VERSION

• SELECT  TOP 10  *  FROM [TABLE_NAME]
• SELECT TOP 10 * FROM [TABLE_NAME] WITH (NOLOCK)

• SELECT TOP 10 A.*,(SELECT TOP 1 PROJNO FROM EMPPROJACT AS X WHERE X.EMPNO = A.EMPNO) AS PRO FROM EMPLOYEE WITH (NOLOCK) AS A
  INNER JOIN EMPMDC AS B WITH (NOLOCK) 
  ON A.EMPNO = B.EMPNO
  

* Note: WITH (NOLOCK) was used for faster query, this concept as solved problem when two query access the same record at the same time that will make the query become slower because the second query should wait for the first query to finish,  by doing WITH NOLOCK the second query should not wait for the first query to finish and the result set can be modified by other query because that is no locking on the result set, so this keyword is very useful especially if you would like to prevent MSSQL to lock a table.

 

DB2 VERSION

• SELECT * FROM  [TABLE_NAME] FETCH FIRST 10 ROWS ONLY
• SELECT * FROM [TABLE_NAME] FETCH FIRST 10 ROWS ONLY FOR READ ONLY
• SELECT A.*,(SELECT PROJNO FROM EMPPROJACT AS X WHERE X.EMPNO = A.EMPNO FETCH FIRST 1 ROW ONLY) AS PRO FROM LUCIAN."EMPLOYEE" AS A
  INNER JOIN EMPMDC AS B
  ON A.EMPNO = B.EMPNO
  FETCH FIRST 10 ROWS ONLY
  FOR READ ONLY

Link Server In SQL Server 2005

Sometimes we would like to create distributed query across different server and database, this circumstance was called "Linked Server" Make sure you have two different server or two different Database Instance, Iam here have SQLSERVER EXPRESS 2005 and SQL SERVER 2005 STANDARD EDITION, the point that you should keep in mind is 'Linked Server was dedicated for distributed query on different Database Instance' whether that is SQLSERVER or other datasource like DB2, ACCESS or EXCEL, on this occasion  I'am going to take SQL SERVER as example. In sql server we can easily make linked server by doing these following steps.

1. You have two instance or more

   

2. Fill the parameter according to this screen cast.
   

   Here detail explanation of the above

   1. Linked Server : Type the linked server that you like to define.
   2. Server Type : specify the server type as Other Data source
   3. Provider Name : Microsoft OLE DB Provider fro SQL Server
   4. Product Name: This was optional, you can fill by empty string
   5. Datasource : This parameter consist of your Server Name and Instance Name, Iam here using ".\SQLEXPRESS"
   6. Provider String: just let it be like that
   7. Catalog : Reflect the database that you would like to access.

Accessing Web Services Using Javascript

I will demonstrate how to acccessing WebMethod(WebServices) using Javascript, this is very simple, and sometimes you will need it when you face the condition to validate the field plus you should check/validate it by sending the data to server, not neccessary when you validate at the server, but when comes up to validate in client side, I meant the trigger was on client script, using javascript as example, then this point can be your solution.

I build DataAccess class with implement with “IDisposable” to manage garbage collection, I named this DataAccess.cs.

Read more »

Create New Sql Server Login / User

Sometimes you would like to create SQL Server account to be able access the specified database than just let it be accessed by computer local admin,  this case comes up when you would like to keep the application just only accessed the specified database only. This approach was the most recommended for better user management. Here are the steps

Read more »