Mohamed Zaatar's Blog

If you want to update your BB device to 7.1 ( if applicable) without waiting the operator confirmation or approval (as they do), just follow these steps:

1- Download software exe from BlackBerry Official site ( about 254 MB)
2- Install the exe it on your machine ( PC or Mac)
3- search for file named "Vendor.xml" in your system. For Windows it will be located on two possible places : C:\Program Files (x86)\Common Files\Research In Motion\AppLoader
and in
C:\Users\Mohamed\AppData\Roaming\Research In Motion\BlackBerry\Loader XML
4- Delete these files
5- Open "Loader.exe" from the folder "C:\Program Files (x86)\Common Files\Research In Motion\AppLoader"
6- Enjoy upgrading your BB :)

Tested on my BB new Curve 9360

Don't forget to backup your device before anything :)

When writing my thesis i faced a problem, how to avoid displaying Appendix section from TOC, i found a coding solution in StackOverflow.com and i modified it to allow up to 3 levels.
Just add these Command after the preamble of your document and use them as following:

\newcommand{\hiddensection}[1]{
\stepcounter{section}
\subsection*{\arabic{section}\hspace{1em}{#1}}}

\newcommand{\hiddensubsection}[1]{
\stepcounter{subsection}
\subsection*{\arabic{section}.\arabic{subsection}\hspace{1em}{#1}}} 

\newcommand{\hiddensubsubsection}[1]{
\stepcounter{subsubsection}
\subsection*{\arabic{section}.\arabic{subsection}.\arabic{subsection} \hspace{1em}{#1}}}

Now you can use the new commands as following:

\hiddensubsection{SubSectionName}
instead of \subsection{SubSectionName}

\hiddensubsubsection{SubSubSectionName}
instead of \subsubsection{SubSubSectionName} 

While exploring my old data, i discovered an old source code for a game developed in 2003 by me and only me. :)

The game was Selem w Te3ban (سلم و تعبان)(Snake and Stairs), it coded by Visual Studio 2003 and C# .NET 1.1. It support up to two players and really i was talented in graphics, i made some pretty images in it. Sorry if you find any bug, i was just a new pie in programming ;)

For try and play it , follow this link.

Quick Response code (QR code):


is a specific matrix bar-code (or two-dimensional code) that is readable by dedicated QR readers, smartphones, and to a less common extent, computers with webcams. The code consists of black modules arranged in a square pattern on a white background. The information encoded may be text, URL, or other data.

Common in Japan, where it was created by Toyota subsidiary Denso-Wave in 1994, the QR code is one of the most popular types of two-dimensional bar-codes. The QR code was designed to allow its contents to be decoded at high speed

Nice QR code Generator :
http://qrcode.kaywa.com/

I created one for my mail : check it ;)

Also you can download QR code reader for IPHONE from this link
QR Reader for IPHONE

My Resume

To see my Resume in Google Docs , Please Click Here

Did you ask yourself what is the reference for some logos we saw them every minute in our life, like USB, @ in the mails address , power button or Bluetooth !!!
i will tell you a brief description about the source of these icons.


Everyone know that Bluetooth epithet comes from the epithet of the tenth-century king Harald I of Denmark "Harald Blutooth", but why he took this nickname? because he was crazy about tasting the blue berries. So one of his teeth fully turned into blue color. BTW, first Bluetooth transmitting device was look likes tooth and with blue color also.




UBS Logo design is taken from Trident shape in Olympic legends but they changed its ends to a triangle, circle and square to represent the multifunctions of USB technology.


About the power button, In the 2cd World War, the Engineers were using the digital numbers to define the buttons so they gave ON button number One, and the shutdown button number Zero. In 1973, One of the standardization institutes make this icon refers to the Stand By operation but later on IEEE decided to be used as Power On.




First Introduced in 1885, in typewriter machines as an abbreviation to the "At the Rate of"




Firewire is a serial interface standard for high speed communications for data transfer like USB. First introduced in 1995 by a sub company of APPLE. They gave it this logo to represent the high speed of transmitting voice and video so it came with three pins: one represents the Sound, the second one for the Picture and last one for the Data.




WiFi name is not a technical name, it reflects Wireless Fidelity. this expression is used from a long time but in research and documents but it was used commercially in 1999 by WiFi Alliance.


Note: some of the contents is copied with disposal from Arab Hardware magazine April 2011

From Months ago, i want to install MAC OS X on a virtual machine to try this beautiful OS ever :)
i said that because i'm a IPhone user from 3 years.

The Steps :
1- Download Snow Leopard Mac OS X iso from any torrents or ftps.
i used : Snow.Leopard.10.6.1-10.6.2.SSE2.SSE3.Intel.AMD.iso

2- Download boot-able iso for Mac from this link
and Extract the contents into specific folder.

3- Open Folder extracted and open Mac "OS X Server 10.6 (experimental).vmx" with notepad app.

4- Change the line of ("guestos = "darwin10") with this line ("guestos = "darwin10-64")
and save the file

5- now open VMWare (i used vmware workstation 7 ) and click on the file "OS X Server 10.6 (experimental).vmx" to open the virtual machine settings.

6- edit the CD/DVD player for the Virtual machine to be an ISO file located in the CD
"darwin_snow.iso", like this image:


7- Run the Virtual Machine, it will boot and ask you to press the "option" button, ignore and press F8. You will have this menu:
8- DO NOT take any action, now right-click on the most right bottom CD/DVD icon in the VMWare workstation and select settings.
- Change the ISO redirecting file for the DVD into the Snow Leopard ISO file downloaded from the first step (Make sure "Connected" check box is checked).
- Press OK

9- Still the VM is waitng for your choice, now press inside the VM itself and type "C" to boot from the installation DVD. :)

10- Now you will install MAC OS X into the Windows 7 :)
here is my screen shot:

11- After the installation finished, the OS X VM will restart, now change the DVD ISO pointing to see the "darwin_snow.iso" included (As step 6). and restart the VM again.
(Note: you have to point this ISO every time you start the VM), i know it's a bad thing to have but i believe that having OS X VM deserves. :)

12- Now configure your OS X with me :) , my screenshot:

CLR integration is a .NET facility allows you to write .NET code and be called and executed from SQL Servers. Simply it is a CLR hosting in Microsoft SQL Server beginning from SQL Server 2005. You can write SP, user define function, user define Data Types, user-define aggregate in .NET.

How to step into CLR integration:

1- Enable CLR integration in your SQL Server, by run this command:

sp_configure 'clr enabled', 1

GO

RECONFIGURE

GO

2- Write the mentioned code in your IDE:
C# Code:

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;


public partial class StoredProcedures
{
[Microsoft.SqlServer.Server.SqlProcedure]
public static void zaatar()
{
// Put your code here
using (SqlConnection sc =
new SqlConnection("Server=SERVERNAME\INSTANCENAME;Database=DB_Name;Trusted_Connection=True;"))
{
using (SqlCommand cmdupdate = new SqlCommand("update Country set Active = 1"))
{
cmdupdate.Connection = sc;
sc.Open();
cmdupdate.ExecuteNonQuery();
}
sc.Close();
}
}
};

3- Save the file as MyFirstProc.cs in c:\

4- compile it using .NET Frame work 2.0 /3.0 / 3.5 ,(but i preferred 2.0), using this command:

C:\Windows\Microsoft.NET\Framework\v2.0.50727>csc /target:library /output:c:\zaatar.dll c:\zaatar.cs

hints:
-i used CMD under administrator authority
- /output option: to specify the output location.
- /target option: to specify the output type

5- Go to your SQL Server and type this command to create an Assembly inside your DB :

CREATE ASSEMBLY ASS_Update
from 'c:\zaatar.dll' WITH PERMISSION_SET = SAFE
GO


6- After successfully creation the assembly, create a stored procedure to deal with the assembly and just to call the dll, by typing :

CREATE PROCEDURE dbo.UpdateCountryTable
AS
EXTERNAL NAME zaatar.StoredProcedures.zaatar
GO

Hints: After EXTERNAL NANME, there are three names with dot (.) separated
the first : is the dll name.
the second : is the class name in the CS file
and the third is the method defined in the CS file

7- Now you can call the Stored Procedure normally like any SP in the SQL Server.

Problems Hints:

-1- If you receive this error: “create assembly for assembly XYZ failed because assembly XYZ failed verification”

Solution: Try to compile your file or project with Framework 2/3/3.5,if you are working in VS IDE, change the target framework from project prosperities.

-2- If you receive this error: “The server principal "XYZ" is not able to access the database "XYZ" under the current security context”

Solution: Run this command on your DB:

ALTER DATABASE DB_NAME SET TRUSTWORTHY ON

GO

-3- if you are trying to set mode of your Assembly to UNRISTRICTED and you receive this error: “The database owner SID recorded in the master database differs from the database owner SID recorded in database DB_NAME.”

Solution: Run this command on your DB:

--To get owner SID recorded in the master database for the current database

SELECT owner_sid FROM sys.databases WHERE database_id=DB_ID()

--To get the owner SID recorded for the current database owner

SELECT sid FROM sys.database_principals WHERE name=N'dbo'

Each of the SID should be equal, if not run this command:

ALTER AUTHORIZATION ON Database::DB_NAME TO sa

Spare column is a normal column with storage optimized. Simply when the value in the column is NULL , it takes no space. It can be used for columns and filtered indexes (where index will index only the rows with values populated).

There are some SQL Data Types can't be used with Sparse , they are:
- geography
- geometry
- ntext
- text
- image
- timestamp
- varbinary
- user-defined data type

Restrictions about using Sparse Column:
- Sparse Column must be nullabe.
- Sparse Column can't have IDENTITY or ROWGUIDCOL or FILESTREAM or Default value attributes.
- Sparse Column can't be bounded to a rule.
- Sparse Column cant be computed column.
- Sparse Column cant be part of clustered index or PK but can be used in non-clustered index.
- Sparse Column is incompatible with data compression so can't compress a table with sparse column(s).

All of us know the typical three types of SQL Statement which are (DML , DCL and DDL) but they are more categorization:

1- DDL (Data Definition Language)
like Create, Alter.

2- DML (Data Manipulation Language)
like insert , update , delete

3- DCL (Data Control Language)
like : Revoke , Grant

4- DQL (Data Query Language)
Like Select with all clauses.

5- TCL (Transactional Control Language):
like Commit , RollBack

6- System Control Statements
In SQL Server : Set XYZ_OPTION TRUE
in Oracle : only one statement : ALTER SYSTEM

7- Embedded SQL Statements: It is an embedded programming into sql but not a SQL Language but each Vendor implements it in his own way.

In SQL Server: CLR integration
In Oracle: Module

Simply if you have any problems in Microsoft Windows Vista 32 bit , just do these tricky steps :

1- browse to %Windows_Folder%\System32\DriverStore\FileRepository
2- you will find two folder begin with the prefix "usbstor.inf"
3- browse to the most recent of these two folder and copy these two file
- usbstor.pnf
- usbstor.inf
4- paste them in the %Windows_Folder%\inf

Simply add your USB Device and every thing will be fine after updating the driver from the %Windows_Folder%\inf :)


Hope that is helpful