2010 in review

January 2, 2011

The stats helper monkeys at WordPress.com mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health:

Healthy blog!

The Blog-Health-o-Meter™ reads Wow.

Crunchy numbers

Featured image

A Boeing 747-400 passenger jet can hold 416 passengers. This blog was viewed about 10,000 times in 2010. That’s about 24 full 747s.

In 2010, there were 6 new posts, growing the total archive of this blog to 55 posts. There were 4 pictures uploaded, taking up a total of 84kb.

The busiest day of the year was March 5th with 255 views. The most popular post that day was 10 to 11.

Where did they come from?

The top referring sites in 2010 were daniweb.com, codeproject.com, twitter.com, facebook.com, and networkedblogs.com.

Some visitors came searching, mostly for ramy mahrous, business intelligence performance elearning, “ramy mahrous”, bi c#, and business intelligence keywords.

Attractions in 2010

These are the posts and pages that got the most views in 2010.


10 to 11 March 2010


Building ASP.NET Reporting OLAP-Based Application Part-1 April 2009


Building ASP.NET Reporting OLAP-Based Application Part-2 April 2009


About | Ramy A. Mahrous April 2009


Building ASP.NET Reporting OLAP-Based Application Part-3 April 2009


10 to 11

March 5, 2010

Excuse me, this post not related to BI which my blog talks about!

UPDATE (Sunday, Mar 7, 2010 at 2:39 am)
1- NOW 10 to 11 supports numbers with country code format +20 and 0020
2- NOW 10 to 11 supports migrating numbers with any known format.

After the decision of The Egyptian Agency for Telecommunications to change cell phone numbers 11 numbers instead of 10 http://www.masrawy.com/News/Egypt/Politics/2010/march/4/mobinil_vodafon_etisalat.aspx , I found it too tough to change your contacts number manually so I’ve developed this application to do that for you. 

Simply my application 10 to 11 (thank you my mother, she suggested this name) iterates all outlook contacts not SIM contacts and modify the mobile phone number of your contacts to the new format\schema which The Egyptian Agency for Telecommunication announced earlier. 

Download it http://cid-3e2288e7a8e55f56.skydrive.live.com/self.aspx/Public%20folder/10%20to%2011%20setup.zip

010 => 0100
016 => 0106
019 => 0109 

012 => 0122
017 => 0127
018 => 0128 

011 => 0111
014 => 0114 

And you can choose what to change to the new format….

I prefer to backup you contacts by using this program PPCPimBackup get it from http://tinyurl.com/l8wh5a

I’ve windows 6.1; I tried it and it works like champ 🙂

Download it http://cid-3e2288e7a8e55f56.skydrive.live.com/self.aspx/Public%20folder/10%20to%2011%20setup.zip

SSIS insert bulk of data into remote table with trigger

November 4, 2009

hmmm, nice we have SSIS it makes life easier but it usually comes with non-understood problems like

“SQL Server Destination” (2185) failed with error code 0xC0202071 it means when you insert data into table in remote SQL Server don’t use SQL Server Destination component however use OLE DB Destination component, thank you SQL Server Central

Anyway I used OLE DB Destination component and everything went well but I found the trigger which updates something doesn’t fire simply because I do bulk insert and I should tell the BIDS please fire it.

So, right click on OLE DB Destination component then Show Advanced Editor… Component properties FastLoadOptions write FIRE_TRIGGERS

ssis postThank you Piotr Rodak