Archive for June, 2011
There are times when SQL query blocks or delays operation in an environment and makes it very difficult to track them, there is a query mentioned on Brent’s Blog that may help in Identifying long running blocking queries.
initially I mentioned query here along reference to Brent’s Blog, but on his suggestion I have modified the post.
Lately I am getting more in love with Open Source technologies especially those which are ported to .Net or can be directly used with .Net.
Please Microsoft don’t consider me a REBEL, I am proudly Microsoft Tech Person. The reason is simple we (Tech persons) are open enough to embrace any products or trend which provides performance and stability (and ma cost-effective too).
Generally I am supporting discussion about “Alternate technologies should be explored” while sticking with technological boundaries which in my case are Microsoft one. We all are aware of the fact that looking at better code and concepts can make us better programmer/Developer, reason being clear enough I would say “Look at those good Open Source products if you learn accept it, if you haven’t that means you know better than suggest it”.
Microsoft is also supporting and getting benefits from this CodePlex is biggest example, Microsoft has placed many of it’s packages at CodePlex which gets used and reviewed by community and later become part of different Microsoft Frameworks.
Look at StackoverFlow they are part of Microsoft Bizspark program, even they earned Microsoft Stack Badge on use of Microsoft Products: OS, Database, C#, Visual Studio, and ASP .NET MVC.
But they too are blending with Open Source flavor now:
- Cruise Control .NET
- WMD – Open Source. (contributed by Stackoverflow)
- Mercurial (after a switch from Subversion) – Open Source (Source control)
I used “memcached” as caching layer to cut huge load from SQL Server, it greatly improved response time.
In upcoming articles I will be discussing following Open Source products along their pro and cons:
- Lucene – Open Source full text search engine framework
- SOLR – Open Source search engine with support for Facet search and a lot more
- Redis Server
- memcached (a windows based port is also available)
the list may increase with time depending on my personal findings and inputs.