(Written on my snappy new Windows 7 RC installation. Operating systems are so much faster before they get those pesky applications installed.) I’ve been gradually transitioning all my file storage and backup to online services, aka “The Cloud”. I’m nearly done and thought I’d share what I’…
I posted a quick update from the PASS European Conference [http://www.sqlpass.org/Community/PASSBlog/articleType/ArticleView/articleId/71/PASS-Europe-2009.aspx] 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 [http://www.runasradio.com/default.aspx?showNum=103]. 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…
Or my alternate SEO-friendly title, “Dynamically load the proper SQL Server SMO Trace library in C#”. I just posted a version of ClearTrace [http://www.cleardata.biz/cleartrace/default.aspx] that will determine whether you have SQL Server 2005 or SQL Server 2008 installed and dynamically load the proper SMO…
It was a long time coming but I finally updated ClearTrace [http://www.cleardata.biz/cleartrace/default.aspx] to read SQL Server 2008 trace files. This requires SQL Server 2008 to be installed on the computer where ClearTrace is running. ClearTrace will process traces created in SQL Server 2000, SQL…
[http://summit2009.sqlpass.org/ ] PASS launched the web site for the PASS Summit Unite 2009 [http://summit2009.sqlpass.org/] today. Lots of fantastic information about the conference. A couple of key points: * The conference is expanding from 144 to 168 technical sessions. * The call for speakers is open [http://summit2009.…
The purpose of making a backup is to be able to restore it at some point. Many of the companies I visit do regular backups but haven't ever restored one of them. If you really want to be safe, test the process to pull a SQL Server backup…
The annual elections for the Board of Directors [http://www.sqlpass.org/CallforNominations.aspx] is coming up. The nomination process is open right now. Serving on the Board is a very rewarding experience. I've had the chance to meet a number of great people and be part of…
Many times when running a trace against SQL Server you'll see RPC:Completed events that look like this: exec sp_execute 66,4,4 Unfortunately this statement was the one causing me a performance problem and I had no idea what it was doing. The 66 is the…
I wanted to congratulate Derek Comingore [http://weblogs.sqlteam.com/derekc/] on being named an MVP. He's a regular blogger here on SQLTeam.com on Business Intelligence topics. It's great to see community participation acknowledged by Microsoft.…