February 2006 Blog Posts
I previously wrote a utility called ClearTrace that monitored trace files and automatically loaded them into SQL Server. I've started a similar program for SQL Server 2005. Right now this utility doesn't automatically import trace files on rollover. That functionality should come soon though. I wasn't planning on releasing the tool but it looks like we're not going to see Read90Trace anytime soon. This utility does normalize SQL statements in a way similar to Read80Trace. For example it takes this SQL:
select topic_id
from forum_topics
where topic_id = 3467
and normalizes it to:
SELECT TOPIC_ID FROM FORUM_TOPICS WHERE TOPIC_ID = {##}
It should handle dynamic...
It's 4:40AM in Barcelona and I can't sleep. I never seem to figure out jet lag. I'm sure I'll be sleeping just fine by the time I leave to come home on Saturday.
Every year at the PASS Conference I find one idea that pays for the cost of the conference. One tip or shortcut that saves me so much time it justifies attending the conference. I think this year that idea is going to be automating Read80Trace. It is a fantastic little tool that aggregates and summarizes performance data on your SQL Server.
The...
Our European Conference kicked off this morning in Barcelona. Ken Henderson, Bob Ward and Bart Duncan are all part of the PSS team. They are doing a day long pre-conference session on SQL Server internals. I think after being in Europe for five days now I'm finally over my jet lag.
The call for speakers for the Seattle Summit is up. You've got until April 28th to submit your abstracts.
Well that was a little embarressing. When you told Scriptio to use a SQL Server account it used it to get the list of objects but not to do the actual scripting. That's fixed (0.5.4). Scriptio Install Page And on a lighter note I'm writing this from Rome. I came over a few days early to visit a friend. Of course, he had travel issues and couldn't make it back from Milan. Grrrr. I very much dislike the weather some days.
Update: Most recent install and source code: http://weblogs.sqlteam.com/billg/archive/2006/06/13/10208.aspx
Scriptio is updated to allow the scripting of assemblies and permissions on the objects it scripts. Scriptio Install Page
Update: Most recent install and source code: http://weblogs.sqlteam.com/billg/archive/2006/06/13/10208.aspx