posts - 230, comments - 423, trackbacks - 27

My Links



Follow billgraziano on Twitter

Article Categories


Post Categories


SQL Server

May 2009 Blog Posts

ClearTrace 2008.34

It seems like all I post anymore is ClearTrace releases.  I guess that’s not a bad thing. The next build is available. This is the full release of the multi-user functionality.  In earlier versions all I cared about was performance.  I did everything I could to make it as fast as possible.  I had just discovered SqlBulkCopy and it was my new hammer.  And all of ClearTrace looked like a nail.  The application would use SqlBulkCopy to load a summary of each trace file as it was read into memory.  All the dimensions I created (application, login, SQL statement,...

posted @ Wednesday, May 27, 2009 7:04 AM | Feedback (3) | Filed Under [ ClearTrace ]

SQL Server sites I visit

Google Reader just introduced functionality to create “bundles” of feeds.  I subscribe to roughly 60 SQL Server blogs that I read on a regular basis.  You can download an OPML file of these.  More interestingly you can just subscribe to the individual RSS feeds of these sites.  If you subscribe to it in Google Reader it will create create a new tag labeled “SQL Server feeds” which is what I named my bundle.  You will be subscribed to each of the individual feeds in my bundle.  If you are already subscribed to one of the feeds it will...

posted @ Friday, May 22, 2009 7:16 AM | Feedback (0) | Filed Under [ SQL Server Stuff ]

Tips for Writing PASS Abstracts

I’ve really enjoyed reading the blog posts and tweets from people that are reviewing the PASS abstracts for the Summit this fall.  I was involved in that process for four years and still have fond memories of it.  It’s a tremendous amount of work to review each abstract and give it the attention it deserves.  And the process of actually selecting sessions was very painful.  There are always deserving abstracts that don’t get selected.  I commend the program committee volunteers for the time they take to read through the hundreds of abstracts and make the tough choices they do. ...

posted @ Wednesday, May 20, 2009 9:49 AM | Feedback (0) | Filed Under [ PASS ]

Using Trace Groups in ClearTrace

I originally started writing ClearTrace because Microsoft hadn’t released Read80Trace for SQL Server 2005.  They finally did release it but by then I had a pretty handy little utility.  Because I was writing it for myself I made some “interesting” design decisions along the way.  One of these is now called a “Trace Group”. I do a lot of SQL Server performance tuning for for my clients.  I was struggling with a way to organize the traces I collect.  At various times I want to categorize by client, application, server and/or whatever I happen to be tracing at that...

posted @ Tuesday, May 19, 2009 6:59 AM | Feedback (0) |

ClearTrace Multi-User Beta

I originally envisioned ClearTrace as a service that could run in the background and process trace files.  As I wrote more and more code the service and command-line versions weren’t kept up to date.  I kept adding more and more caching to improve performance.  That had the unfortunate side effect of not working if two copies of ClearTrace were processing against the same database.  With the return of the command-line version I finally had to fix this. You can download a beta of ClearTrace build 32 and test the fix.  The ZIP file includes both the GUI and command-line...

posted @ Monday, May 18, 2009 7:13 AM | Feedback (0) | Filed Under [ ClearTrace ]

ClearTrace now available with a command-line version

This is the first release of the command-line version.  If you have any feedback, please post in the ClearTrace support forum on This provides all the trace loading features of the GUI.  You’ll still need the GUI in order to query the results though.

posted @ Friday, May 15, 2009 10:07 AM | Feedback (0) | Filed Under [ ClearTrace ]

Why am I being forced to learn PowerShell?

I spent an annoying afternoon with SQL Server 2008 today.  When we installed it on our cluster it created a job called “syspolicy_purge_history”.  I assume it does this in most installations but I haven’t checked.  The job was generating an error every time it ran.  A quick Google search turned up an article on the problems with syspolicy_purge_history and clusters.  Now all I needed was to figure out the PowerShell syntax to correctly refer to this instance.  PowerShell?  Oh yes.  They couldn’t just call a stored procedure.  Oh no.  Rather than giving me the choice to...

posted @ Tuesday, May 12, 2009 7:41 PM | Feedback (4) | Filed Under [ SQL Server Stuff ]

Storing My Files in the Cloud

(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’ve done in hopes of getting even better ideas or helping someone else out. Live Mesh My main working computer is a laptop.  I have a small server here but it’s only used for testing.  I have a few folders in “My Documents” where I store the bulk of my non-development...

posted @ Monday, May 04, 2009 7:17 AM | Feedback (3) | Filed Under [ Miscellaneous Utilities ]

Powered by:
Powered By Subtext Powered By ASP.NET