Logging down dead locks in SQL Server 2000

CK Chin (eBworx) taught me this before but after spent 2 years in Oracle development I forgotten this trick. Thanks to soonyu in SPAN who remind me.

– add the -T1204 and the -T3605 startup parameters to SQL Server and restart sqlserver services


– from query analyzer
dbcc traceon(1204,3605,-1)
dbcc tracestatus(-1)

Microsoft: The SOA road less traveled

there is an article in SearchWebServices.com which talks about Microsoft’s approach to SOA. They talk about how Microsoft is different in everyway in the SOA implementation whereby instead of creating a whole SOA suite, MS is leveraging on Biztalk, WCF and Windows Workflow Foundation to provide a SOA platform. Having said that, SOA as its name suggest, is an architecture after all. So I guess this is why MS is not coming out with a totally new SOA product like the other vendors did. This strategy work well for MS because they have matured products like Windows, Office and Biztalk which just need to be enhanced to provide an end to end experience for developing and deploying SOA applications. The new Office Business Architecture (OCA) seems to aim at this vision where Sharepoint and Office (which almost everyone is familar with) provides a frontend to the backend processes such as workflow, business inteligence and legacy system; benefits is end user will have a single sign on experience to access corporate information under one shop. On the developer side .NET framework provides a common paradigm for OBA to develop application is all kinds of platform as we see more and more Microsoft products being .NET enabled (meaning there is a .NET API available whether or not the product is coded in C++ or managed code).

SOA is abstract as an architecture so this opens up opportunities for vendors to develop their own implementation and innovate on it. Qouting from the article, “Microsoft has an ecosystem and they have a value proposition that’s very solid for that ecosystem. What Microsoft has for what it’s doing is very good. It is what it is.”

Windows Home Server Blog : Building Add-ins

Just installed Windows Home Server April 07 CTP today. There is something new with this CTP known as an addin. According to Home Server blog, building addin is like developing Windows based application. However bear in mind that Home Server serves as only a server with no user session. Meaning this whatever addin must be able to run as a Windows service. After constant bombard of SOA architecture at the enterprise app space, I would have immediate thought of a few applications or services that would should have made it as a Windows Home Server addins:

  1. VOIP. Skype and VOIP services is becoming something we take for granted in the enterprise and SOHO alike. I can imagine I just need to dial a number on my local land phone, and some service sitting elsewhere (in this case, mostly in WHS) would be able to determine whether a VOIP gateway is available for me to connect to that number.
  2. Remote downloading services, this is a feature I found in Flashget downloader whereby I am able to install a service at my home PC and hook it online 24/7. Then from anywhere I can send a command or URL to my home PC to download a particular file. This is useful when I don’t have immediate access to fast and constant Internet connection.
  3. Expression Media is one application I would like to see able to make it as an server based application where we have AJAX based interface to manage our digital assets. I can also share it with anyone such as my customer my photograph portfolios.

Link to Windows Home Server Blog : Building Add-ins