Christopher H. Laco

This is the second in a series of posts about Siphon, a set of data monitoring utilities for .NET under the MIT license. The source code can be found on GitHub.

More…

If you’re using connection strings on the web, set Application Name to the domain name. If you’re using connection strings with an executable, set Application Name to the executable name. If you have to use SQL Profiler to diagnose performance issues, it will be easier to filter out a specific application or web site.

<connectionStrings>
  <add name="LocalSqlServer" connectionString="... Application Name=mywebsite.com;" />
  <add name="LocalSqlServer" connectionString="... Application Name=myapp.exe" />
</connectionStrings>

Here’s a fun way to waste 2 hours of your life. I was writing a custom config section, and trying to figure out why this wasn’t throwing a duplicate key error:
More…