April 2009 Blog Posts
I posted a quick update from the PASS European Conference on the PASS Blog. And it include a picture of our Executive Vice-President Rushabh Mehta. With Hair. I’m so jealous!
I was recently interviewed on RunAs Radio. We spent quite a bit of time talking about performance tuning. I’m spending quite a bit of time lately looking at how things get into and out of the query cache and we touched on that a bit. We also spent some time talking about ClearTrace and what it can do for you. Take a listen and try not to laugh at a “voice made for print”. I was also interviewed on Greg Low’s SQL Down Under a few years back. That show is in the SQL Down Under archive (show #13).
Or my alternate SEO-friendly title, “Dynamically load the proper SQL Server SMO Trace library in C#”. I just posted a version of ClearTrace that will determine whether you have SQL Server 2005 or SQL Server 2008 installed and dynamically load the proper SMO library. Previously I had one version of ClearTrace for each version of SQL Server (YUCK!). I’m pretty happy with how this works even though I’m not very happy with SMO. The method names are the same between the two versions of SMO but they aren’t both derived from the same interface. That...