Masrawy 3ala Tool

2010-07-13T14:57:00.000-07:00

What IT Certification do I need?

This the question in my mind currently. If you have seen my last blog , I feel in a deep need to get certification in all the fields that I'm involved in. So I decided to List down all of this fields for better investigation in the best internationally recongnized certifcates.

I will try to mention all the certification that I found worth getting beside each field:

Database Management : Oracle DBA , I also need the Performance Tuning Certificate.
Requirement Analysis: TBD
Design: ITIL
Data warehousing.
Management: PMP for sure.

2010-07-13T14:28:00.000-07:00

Certify Your Experience

During my first day in the BSF in Riyadh, I had to deal with database problem that needs SQL tuning. I thought at the beginning it needs some simple tuning like EXISTS and query hints, but preferred to see how a certified DBA will deal with that query.

Originally the query was taking round 1 minutes , but the performance issue was reported the query was taking around 9 minutes to return. When the DBA started to deal with it, he identified one or two things that could cause that issue, one of them was the extensive use of the CASE statement since it force the ORACLE DBMS to perform some processing on the retrieved data after the query return the Dataset, and this appeared clearly when we saw the query plan and the number of temp views created by the DBMS to process the CASE statements.

Meanwhile I was working to solve these issues, he asked me to try to run the original query again, amazingly the query was taking 5 seconds to end. That time he applied some database procedure that tunes the tables involved into this query to run faster, this procedure called Histogram.

The thing that came to my mind is that I'm experience in many software fields either technical or analytical, but I did not get any certifications to support this experience and fill the gaps of knowledge.

الأخبار - تقارير وحوارات - زيارة سليمان لإسرائيل.. لماذا؟

2009-12-21T02:38:00.000-08:00

الأخبار - تقارير وحوارات - زيارة سليمان لإسرائيل.. لماذا؟
أغلب محتويات الخبر عبارة عن نقل من الصحف الاسرائيلية مع نية مبيته من كاتب المقال انه يظهر عمر سليمان بمظهر الخائن العميل.يعني الأسرائيلين بيلعبوا بالمسلمين عن طريق ظهور مثل تلك الأخبار فى صحفهم و نحن نقرأها و نبني عليها استنتاجاتانا شخصيا لا يعجبني نهج الخكومة المصرية فى الشأن الفلسطيني خصوصا مع حماس .لكن واضح ان الجزيرة دخلت طرف ثالث فى تلك العلاقة و ليس لوجه الله.
الملاحظ على قناة الجزيرة فيما يتعلق بالشأن المصري هو المبالغة فى أشياء و التقليل فى أشياء أخري حسب احتياج أطراف اخري تخدمها القناة

Lazer Beams: Learning Morals from an Ant

2009-08-06T12:43:00.000-07:00

Lazer Beams: Learning Morals from an Ant:
I liked this article about the destiny of the liar in the ant world. This world is amazing they are organizaed and social advanced than we were thinking.
check this section:
"In bright sunlight, we don't see any ants crawling around. If we were to cast a shadow over the mound, a leader ant would peek his head out of the main entrance and walk around freely in the shade. Then, he'd return to the edge of the hole to call his buddies to come outside and join him. Meanwhile, if we were to remove the object that cast the shadow, and the emerging ants would not find shade, they'd kill the leader ant for lying to them. Ants don't tolerate the slightest form of dishonesty."

2009-07-02T04:57:00.000-07:00

قراءات من صحيح البخاري مع شرحها

الشيخ ده بسمعه كل يوم الصبح و انا رايح الشغل على اذاعة القرأن الكريم فى الرياض بجد روعة بيحلل الأحاديث تحليل يدرس لدرجة انه بيحلل طريقة البخاري فى اختيار الحديث ويشرح معانيها

ممكن تحمل الحلقات على أيبود أو أم بي ثري بلاير و تسمعها و فى اي وقت لأن أغلب الناس مفيش عندها وقت تقرا

Internet Archive: Free Download: قراءات من صحيح البخاري مع شرحها_01

2009-07-01T12:58:00.001-07:00

Using Multi Node in XPDL Workflow

Introduction:

This document describes how to implement a workflow that calls a subworkflows, the notes mentioned here are captured during the implementing workfows using together workflow as an editor and tomcat as a server.

Part 1: Subworkflow Creation

In this section we will go through the process of creating new workflow to the pakage.

Select Package> Insert New Process
Right Click the new created process and click properties
Select the general tab and rename the process ID
Go to the Formal Parameter tab and add the necessary parameters. for instance add a parameter name PRCD which correspond to the product code
GO to the application tab and add the necessary applications
save and close the properties tab
insert the participants for the new process

Part 2: Main workflow changes

Go to the main process and select the properties

go to the General tab, ProcessScript section and add the following script:

public String[] distinct(String[] a) {
return (String[]) new TreeSet(Arrays.asList(a)).toArray(new String[0]);
}

public Collection distinctPR(NodeList nodes) {
HashMap map = new HashMap() ;
for (int i=0; i < nodes.getLength(); i++) {
String sKey = ((Element)nodes.item(i)).getAttribute("BAAPID") + "___" + ((Element)nodes.item(i)).getAttribute("PRCD") ;
map.put(sKey, nodes.item(i)) ;
}
return map.values();
}

Insert Multi Node in the workflow graph
select the properties of the multinode
select the general>ListExpression and add the following express:
distinctPR(evalListCredApp("/PPCA/PPCM[@LKTY='P']"))
this expression uses the distinctRR script that we have just added in step #2, and it calls the function evalListCredApp. the evalListCredApp is depenet on the system you are using you might have different set of functions
Go to the type tab and make sure that the type is SubFlow
Select the subworkfow -in the ID dropdown list- that you have created in part 1 of this guide
In the formal parameters section, add the PRCD formal parameter
in the actuall parameters section, add the following:
((Element)__element__).getAttribute("PRCD")

2009-07-01T02:22:00.000-07:00

Adding a vertical line to an excel XY chart

Excellent article about how to add a vertical line to an excel xy chart using the error bar

View folder size in Vista - Tech Support Forum

2009-04-23T14:53:00.000-07:00

Disk space in Vista
yesterday I have downloaded kaspersky and started to scan my computer for threats, but faced a very strange situation where drive C has lost 12 GB disk space. so I uninstalled kaspersky but I could not recover this disk space. I have to know where the space is gone, I searched the web for an application to get the sizes of each folder in my HD, I found this application TreeSize Free which was recommended in this post
View folder size in Vista - Tech Support Forum
My last conclusion is that there is a folder of size 5 GB in the Windows folder c:\windows\tmp so I deleted the contents of this folder. and one last thing I did is to delete the windows restore points which freed up around 7 GB and I returned my lost 12 GB.

2009-03-08T04:22:00.000-07:00

How to uninstall IE8 | Browsers | Tech-Recipes:
for unknown reason I cant find IE8 in the add/remove programs in the control panel. there are some compatibility issues in IE8 with some web applications that I'm working on currently.
run c:\WINDOWS\ie8\spuninst\spuninst.exe

Digg - Ancient Language of Universal Symbols Discovered

2009-03-03T05:58:00.000-08:00

Digg - Ancient Language of Universal Symbols Discovered
so our ancestors has reach a high level in communications and traveling than we expect

2009-01-18T12:09:00.000-08:00

عندما كنا صغار كنا نتمنى ان نصبح اطباء أو مهندسين أو ضباط شرطة بل ان بعضنا كان يتمنى ان يكون ضابط مرور لما يشعر به من فحر و هو يرى ضابط المرور يتحكم فى سير السيارات و يسجل السيارات المخالفة , حتى اننا كنا نشفق عليهم من هذه الوقفة فى الشمس -اتضح بعدها انه عسكري.

ماذا حدث لتلك الصورة لقد صرنا نهاب اليوم الذي نضطرة فيه للتعامل مع الشرطة للحصول على أحدى حقوقنا, هم يتعاملون معك كأنك مجرم حتى انك لا تستطيع ان تسير أمام قسم شرطة لتضطر ان عبر للجهة الأخرى من الشارع ثم تعود لتكمل طريقك -أتحدث هنا عن قسم شركة المنتزه من ثلاث سنوات-

و يتمنى الأب فى الأسرة المصرية البسيطة ان يكون أحد ابنائه ضابطا فى الشرطة أو حتى امين شرطة لكي يوفر حماية للأسرة فى مجتمعنا القاسي.