Tuesday, January 12, 2010

Things I hate about my Mac

The Mac is a very good machine. I am like the Paul of the Mac machine formerly Saul of PC - prosecuting the Mac System and stoning Mac users (not literarily) if you happen to have read the bible at all or heard from those that have read (like I did).

I find the Mac incomparable with the PC. The Spec of My Mac Book Air is about the Spec of my previously owned PCs I bought 2 years ago but much faster than my last PC with far better Spec. Believe me, you won't be comparing "Apple" to "Apple" comparing the Mac and PC.

I could hear someone whispering "That's cos u were running Windows". Wrong!! I have Windows 7 running on my Mac too and it's Blazing fast.

My conclusion is that I will like to believe this is due to some sluggish defect in the PC design.

Spoken by a recent Mac user ....

However, I hate a few stuffs about my Mac.

1. My MacBook Air has just one USB slot. This is no problem with Mac but on the other hand it is. I could have chosen other model other than the Air you would say, but then I had the option of a USB hub you would also suggest. Wrong! The Mac work's better with powered USB so I could not have my network running and still have my drive on. Solution - Buy a powered USB hub - $35

2. NTFS drives are loaded as readonly. Just wondered why Apply had to make this the default option in Mac. OS X reads NTFS pretty well and should also write if you ask me.
Solution - Include UUID in /etc/fstab file (tiresome and often require restart) or buy a NTFS Manager like Paragon NTFS for mac $40

3. Mac is too pretty. I find it hard to imagine the future of my Mac with faded keyboards and trackpads. Think I need the Wireless keyboard and mouse - mouse I say, I want the Magic Mouse $70+$70 = $140

4. Can't get Mail to work with Exchange Server used in most enterprise. Solution - Buy Mac Entourage bundled with Microsoft Office for Mac. $150

5. Miss Visual Studio So bad. Wish their a version of that the works on the Mac. Mac offers XCode, plus I got Eclipse working (even though they confused on Carbon or Cocoa) and MonoDevelop works great too. Solution is buy CrossOver or Install Windows 7 on your bootcamp and run from VM Fusion with Unity Mode. - average cost - $70 (cross over) + $80 /2 = $75

6. Can't upgrade my MacBook Air RAM beyond 2GB as it has no drive-bays. The RAM is soldered unto the board. I run quite a lot of VMs and 2GB would not be enough. These days my system locks up when I boot up my bootcamp Windows from VM fusion. Solution is buy a Mac Mini and moves task to it. $600

At the end of the day, I have $1040 worth of hatred for my Mac but despite that, I still LOVE IT...

Monday, January 11, 2010

Fixing Ghosted File

Just a few weeks old on the Mac and I already experienced a peculiar situation twice. It's been fun configuring the Mac and getting it as close as possible to my previous Windows dexterity as possible though it's been a lot of distractions too.

On moving files sometimes especially unto a destination NTFS partition, I realised some of the files moved are ghosted. I investigated and discovered this is due to incomplete copy operation. In my situation, the copy process probably did not clean up successfully after the copy. Why will this happen? I already lost files to this previously as I am left with no choice but to delete such files.

This time I had to make sure these files these files are recovered. On googl(e)ing, I learn about undisplayed file attributes of Unix and Mac files. Also learn that tools like RixStep ACP XFiles tools help with controlling such attributes. A single use license cost about $59.

Later I learn about the SetFile tool bundled with the XCode tools. An accompanying GetFileInfo tool will give

$ GetFileInfo [file name]


Screen shot 2010-01-11 at 14.55.48.png


this is what's shown for Normal files. In my case I had "brok" as type and "MACS" as creator.

This can be corrected by using Send File as below

$ SetFile -c "" -t "" [file name]


Knowing myself not to be able to remember this months down the line, I added this to my .profile file under the unghostfile alias.

SSIS vs Informatica

In a recent outing, I met with a product vendor wanting to do ETL for a Siebel CRM product from Oracle database.

Trust me, I was quick to recommend SSIS which I am very familiar and very recently just had a laudable success extracting and Migration of Billing Information from a Legacy ENDAN (SQL Server based) application to Singl.eView from Intec.

On further discussion with the vendor, he would prefer the use of Informatica (first time getting to know this). I was able to show him lots of cool features SSIS have to offer.

Afterwards, I decided to know more about Informatica and found this on the net

Informatica does not have an equivalent of SSIS’s UNION component . This is a big problem for what I’m trying to do because a lot of the logs that I’m trying to load are in different folders (to represent the different web servers). Informatica requires 2 pipelines (see #3 below) to extract this data whereas SSIS can just have 2 source adapters in the same data-flow and UNION the data together.

SSIS’s method of loading multiple files (i.e. the "Multiple Flat Files Source Adapter") is a lot better than Informatica's. With Informatica you have to, externally to Informatica, build a list of files to process and then pass that list back into Informatica. To make this dynamic at runtime you would have to shell out to an external process to produce the file list. This is not pleasant – especially compared to SSIS’s very simple method of just specifying “*.log” in the source adapter.

I have a pipeline (built in both SSIS & INFA) that filters out all comment lines from the web logs, extracts all the individual fields (e.g. Timestamp, ClientIP address, URI, Referrer etc...), and inserts into a SQL Server table. The SSIS pipeline is working on ~150000 rows and completes in ~23 seconds. The Informatica method (which uses 2 pipelines cos of #1 above) takes ~45 seconds. Even 1 Informatica pipeline on its own (working on about half the records) took ~27 seconds. Bear in mind also that the SSIS pipeline was run from BIDS and as I have previously mentioned, BIDS places a large overhead on the execution of a package. I would suppose that Informatica does not have the same restriction. In short, SSIS seems a lot quicker!

SSIS’s method of dynamically setting the destination at runtime (i.e. configurations) is a lot better than the Informatica equivalent. With Informatica you have to configure each task to use the dynamic value, and setting up the value itself is a manual process because you have to manually handcraft what is termed a parameter list. SSIS does this using the configuration wizard. Let me say again, EVERY Informatica task that uses an external connection has to have a dynamic configuration set up using this method; with SSIS you do it in one place, on the Connection Manager.




This even has more indept comparison
http://download.microsoft.com/download/1/0/3/103fd39e-3ca4-4db7-a087-1263dc6ed0b1/CompIntTools.pdf

Monday, January 04, 2010

Happy New Year!

It's a New Year! Happy New Year to all you guyz and Hope 2010 holds so much great Software Experience ...


Photo on 2010-12-31 at 10.07.jpg