Journey of a Software Developer
On Threading

I’m reading parts of CLR via C# 3rd Edition by Jeffrey Richter, mostly threading part.

I think it’s one of the most insightful books on threading in Windows, he has an intense knowledge of threading implementation details, patterns and anti-patterns on Windows and CLR. 

I recommend it to all who wants to have a profound practical knowledge of threading in .NET .

Information Visualization : SSL Session Illustrated Clearly

Although this Article depicts a simplified version of protocol, it will help you to grasp the main point very quickly and remember it more easily, the more detailed version can be found on Wikipedia

Recent Readings, Technical Part

Ruby, Javascript, HTML5 Weekly Newsletters by Peter Cooper

I have subscribed to Ruby, Javascript and HTML5 Weekly Newsletters by Peter Cooper since a few months ago.

Volume of content, topics and organization of content and short mostly single line description are all very well thought out, I did not found any better newsletter in past.

I try to not miss reading them every week.

On Learning Ruby and Rails
Learning Ruby was and is a lot of fun for me.

It introduced me a whole new world and ecosystem.

I tried different development environments and finally setup a Hackintosh on my Dell Latitude D830 laptop, installed the latest OS X from Apple, Mountain Lion and the lovely editor TextMate.

I appreciate the passion of Open Source Software Development in Ruby and Rails community.

And most important, I discovered new ways and paradigms for programming.

Now I can understand better Dave Thomas and Martin Fowler writings on picking the Ruby as the right tools for doing agile. 

What I’m reading now

Recent Readings

Below is the titles which I’ve read in recent months:

Reading List, Organized

I want to write down stuff that’ve kept my mind busy for a long time.
It’s all topics I should read about in coming years,

It ranges from technical and academics to more general and humanities subjects:
Let get started:

Tech Stuff:
  • SOA (Implementation in different ecosystems like .NET, Java, and more agile langs like Python or Ruby)
  • Computer Langs, Programming Paradigms and Compilers 
    • Scala 
    • Java
    • Python
    • Ruby
    • JavaScript
    • HTML5 & CSS3 
  • OS (Linux & Windows)
  • Network Programming
  • Parallel and Concurrent Programming
  • Transaction Management
Academics:
  • Algorithms
  • Computer Architecture, Hardware and Organization
  • Networking (TCP/IP and network in general) 
  • CS Math
  • Stats
  • AI & Data Mining 
  • Security and Cryptography
And Last but not least, general subjects that makes me more likely to be human rather than a robot:
  • Philosophy
  • Psychology
  • Economy
  • History
  • Astronomy
So I must start planing to get things done.
I will come back with reports.

A flexible way to delete duplicate rows in Sql


A few days ago, I found a better solution for deleting duplicate rows in a table and what make me think, is that i caught on to this solution when I’m under pressure of time limit.
When I was playing around with ROW_NUMBER function, incidentally I found out that this pretty useful function could be employed for deleting duplicate rows without getting into trouble with GROUP BY clause.
And here is the script:

with duplicates as
(select *, ROW_NUMBER() over(partition by SerialNumber, FirstName, Surname 
                      order by SerialNumber,FirstName,Surname,RegDate desc) rownum 
 from Person)
delete from duplicates where rownum > 1

script delete duplicate rows with same SerialNumber,FirstName and Surname but the row with max RegDate stands still.
NHibernate : Invalid Index N for this SqlParameterCollection or OracleParameterCollection with Count=N

Figuring out what’s happening in nasty *.hbm files to cause this err is overwhelming.
The solution that works great for me is that I manually insert a record in database and try to call Load function on the same object and a more informative error message I’ve got that lead me to solution.

That’s the point!