Tuesday, November 14, 2006

Playing with Terabytes :-D

I am working on an ODS project, ETLing millions of records, I just realized that we’ll end up (when going live) ETLing almost 2 Terabytes of data, It feels soo good, for me it is like bungee jumping, no matter how good you are prepared for it, and how safe and calculated it is, it is still an experience that will make you feel raw adrenalin pumping through your veins!

Sunday, November 12, 2006

SSIS DataReader Source Task

SSIS ETLers,

If you‘re looking for a way to assign an expression to the SQLCommand property of the DataReader Source task , you can do that from the properties of the Data Flow task that contains the DataReader (Not the DataReader itself)

I wanted to share coz it was painful for me to figure it out!

Thursday, November 09, 2006

This makes me laugh soo much:

Natasha: drop table X.
SQL server: Cannot drop the table ‘X’, because it does not exist or you do not have permission.

Natasha : create table X( x int).
SQL server : There is already an object named ‘X’ in the database.

Natasha : ok sweety, drop table X.
SQL server: Command(s) completed successfully.

Natasha: :-) No matter how stupid you can be sometime, I still love you :-)

Wednesday, November 08, 2006

Two Jordanian developers having a “Technical” conversation:

Ahmad1: Esmaaa3, fata7et 3al Aazmen, laget el XML file maojuud u faye3, bas mish gabel yisamsem!

Ahmad2: HaDDa hu nafso bikun M6oget3

Tuesday, November 07, 2006