posts - 220, comments - 411, trackbacks - 27

My Links

Advertisement

News

Follow billgraziano on Twitter

Article Categories

Archives

Post Categories

Consulting

SQL Server

February 2006 Blog Posts

Importing SQL Server 2005 Trace Files

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...

posted @ Sunday, February 26, 2006 8:04 PM | Feedback (5) | Filed Under [ ClearTrace ]

Using Read80Trace in a batch file

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...

posted @ Wednesday, February 22, 2006 9:45 PM | Feedback (3) | Filed Under [ Utilities ]

PASS in Barcelona

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.

posted @ Wednesday, February 22, 2006 3:51 AM | Feedback (1) | Filed Under [ Events PASS ]

Scriptio Update - Actually uses the SQL Server account

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

posted @ Friday, February 17, 2006 1:23 PM | Feedback (2) | Filed Under [ Utilities ]

Scriptio Updated - Assemblies and Permissions

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

posted @ Sunday, February 12, 2006 5:30 PM | Feedback (2) | Filed Under [ Utilities ]

Powered by:
Powered By Subtext Powered By ASP.NET