Once in a while, I log in to MyBlogLog (It’s the social network site for bloggers). In my profile, I put “Sticks and stones love, I saved your life and you saved mine, we’re square” … oops .. 😛 … I mean “If you add me, I will add you”, or something like that …

After quite sometime my list of contacts grows until 299. I have around 5 people that have added me to their contact, but MyBlogLog didn’t allow me to return the favour by adding them into my contact. I forgot when exactly this thing happened, maybe roughly 2-3 months ago? After trying for 1 or two days, I stopped trying.

So today I login again to MyBlogLog and found there are 35 people who have added me. Without any intention or expectation, I clicked the add to contact button.. Whoa.. I can now add more people into my contact list. Since when did this happen?

To all MyBlogLog-gers, I offer you my humble apology for not keeping my word of adding you into my contact list. I will definitely return the favour.

I am looking for a code (or command line software) that able to format/tidy-up SQL string to make it readable and doesn’t irritate the eyes. So far I have found:

1. SQLinForm
   It’s quite handy, you can run it on your browser and download the offline version which is packaged into one single Java Jar file. Unfortunately, I’m looking for something with with command line or open source. At least with command line support I can invoke it from my .NET program to process the temporary file.
2. SQL Online Formatter
   Still without the programmability support.
3. SQL Review
   With command line support. Unfortunately It’s throwing error on one of my stored procedure, but it still gives you the output.
4. Pl/Sql Tidy
   This program is only available in command line. Unfortunately, it never able to process my stored procedure. I not so sure whether it’s still maintained.
5. Using Flex Script.
   This page is pure inspirational. It immediately opened up my eyes for the possibility of using Flex or Regular Expression. I think will stick to this solution.

Although I have made up my mind, I will provide the output of each program in the next posting. Hopefully once I am be able to port VS. Babu’s lex script (or make my own regular expression code), I will share it with you all.

Credits:

1. Carson McDonald

Almost losing sleep because of my colleague’s question, I posted the question in .NET Groups where I frequently hang out.

One contributor suggested me to use DataTable.Rows.Find(), especially when we are searching by the Index column of that DataTable. I never heard of this, so I keep it noted as an additional advise to my colleague.

After much thinking, I somehow became doubting that DataTable.Select() is the actual source of the bottleneck. So this morning I asked her to run the profiler to check the performance of her program. The profiler’s result proven my doubt. The bottleneck was caused by multiple calling of Web Services.

All this time I already have a little discomfort with Web Service. I thought the overhead of transmitting data by text XML is too much, especially when you have thousands of records transmitted at an instance. So I spent a little time to googling for opinions that against Web Service (Web Service here refers to those web services that commonly implemented using SOAP). Eventually, I stumbled to this page. I highly recommend it. It’s funny, it’s witty and you might want to use it as an argument when debating against SOAP proponents 🙂

Talking about Profiler, she is using ANTS Profiler. It’s not free 🙂 But you could download the 14-days trial. And of course you can always ask Google for a help.