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


Invoke or BeginInvoke cannot be called on a control until the window handle has been created..

November 21, 2010

If you installing new instance of SQL Server 2008 or adding new features to an existing one and got this error

SQL Server Setup has encountered the following error:
Invoke or BeginInvoke cannot be called on a control until the window handle has been created..

I won’t recommend you to go to http://support.microsoft.com/kb/975055 and waste your time installing SQL Server 2008 SP 1 because it won’t solve the problem.

Close IE\Explorer windows or anything you can open after doing your installation process 🙂 yes that’s it… weird..

SQL Server 2005/2008 errors during installation

June 24, 2010

2 days to install SQL Server 2008\2005 each time I try; It fails with this error

The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, “How to: View SQL Server 2005 Setup Log Files” and “Starting SQL Server Manually.”

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29503&EvtType=sqlsetuplib%5cservice.cpp%40Do_sqlScript%40sqls%3a%3aService%3a%3aStart%40x41d

To solve the problem I had to disable the antivirus (BitDefender -what I’ve-) seems it prevents the windows installer to start any services! to over come this prevention stop your antivirus.

Another error message may appear after you install\uninstall SQL Server due to errors in installations…

SQL Server Setup has encountered the following error: The given key was not present in the dictionary..

although I’ve valid\legal SQL Server serial number I don’t know from where this error comes! what I had to is to install “Windows Install Clean Up” to clean any SQL Server installation. download it from http://support.microsoft.com/kb/290301

After installing SSRS! You can’t manage Reports site

March 31, 2010

It’s just a quick tip after you’ve successfully installed SQL Server Reporting Services on Windows Vista or Windows 7, you go to http://{Server-Name}/reports which redirects you to http://{Server-Name}/reports/Pages/Folder.aspx you find out that you can’t control anything and the site looks like this

Don’t worry what you should do is to, right click on Internet Explorer or your favorite browser then run as administrator and retype your SSRS Reports site URL http://{Server-Name}/reports you’ll find you can manage everything as you see

To not open your browser as administrator everytime you manage your Reports you should add your current user as Content Manager or as you wish. From Properties-> New Role Assignment -> Type the username of current user -> Select role -> OK

Open it without run as administrator it will look like as you want.

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

Business Intelligence Keywords

March 4, 2010

I mainly write this post for novices who need to begin with Business Intelligence and to be aware of the most Business Intelligence keywords thus they could read any Business Intelligence article without any problem.

Business Intelligence: The art of extracting right information in timely manner to right person from raw data, it doesn’t depend on specific technology but very wide of technologies depend on; like Data Mining. It makes the organization realize its resources, potential and give the Big Image* to the status of its goals.

Operational Business Intelligence: Business Intelligence Systems build on the same Business Intelligence process ETL, Analysis then Reporting but they don’t care about KPIs and Measures more than data listing.

Tactical Business Intelligence: Business Intelligence Systems build on the same Business Intelligence process ETL, Analysis then Reporting beside they give a wide solutions to tactical managers who can use them to get the most of KPIs (Profit in dollars, number of CRM tickets, etc) to take their organization step towards its goals.

Strategic Business Intelligence: Business Intelligence Systems build on the same Business Intelligence process ETL, Analysis then Reporting it helps the top management get the status -very brief status- of the organizations and its step towards its goals.

Measure\Fact: What’s the organization looks for, profit in currency, revenue, number of user come to website, number of CRM tickets, etc…

Dimension: How the Measure\Fact measured per, means profit in currency (Measure\Fact) can be measured per time, sales region, sales person, product type, etc.. so we call time, sales region, sales person, product type dimensions. Simply everything you can group by…

Hierarchy dimension: Dimension has self-relationship like time dimension we may see Year, Quarter, Month, Week, Day and may be more deep details. Simply everything with more than one level (deparment employee).

Read the rest of this entry »

Replication Error “SQL Server is unable to connect to server..”

February 25, 2010

If you’re working in SQL Server Replication, you may get this message
SQL Server is unable to connect to server ‘Your server name‘.

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, ‘Another server name‘. (Replication.Utilities)

It always appears as you change the instance name manually or network administrators change the computer name.

Actually your server name still as it’s and not changed with above changes so to avoid getting this message you should write these couple of T-SQL scripts every time you do one or all changes on the instance name

SELECT @@SERVERNAME — you’ll get a strange name, you may didn’t see it before…
sp_dropserver ‘Old server name’ — you got it from pervious select.
sp_addserver ‘SQL server instance name’,’local’ — the name of current instance.
Then, restart the service, and go on you replication work…