Most of my work is supporting and troubleshooting production environments and very often developers I work with say “We are having some performance issues in our website and we believe the bottleneck is in SQL Server. We have collected some profilers...

Sometime ago I had to troubleshoot a problem in Biztalk Server 2004. I was told that Biztalk Server 2004 apparently stopped working and the only way to get it back on track would be to restart the instances and we didn´t had errors reported. After that...