Read80Trace generates an XML file as its result and a series of HTML files that can be used to view the XML file. I've updated ClearTrace so it can produce a nearly identical XML file for SQL Server 2005 traces. * It only generates the batch duration, batch CPU,…
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&…
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…
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…
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 [http://www.sqlteam.com/publish/scriptio/] And on…
Scriptio is updated to allow the scripting of assemblies and permissions on the objects it scripts. Scriptio Install Page [http://www.sqlteam.com/publish/scriptio/] Update: Most recent install and source code: http://weblogs.sqlteam.com/billg/archive/2006/06/13/10208.aspx…
Pablo Castro, the Program Manager of the ADO.NET team, posted some great code samples from his PDC presentation [http://blogs.msdn.com/dataaccess/archive/2006/01/09/510083.aspx]. There are a variety of demos available. The one I spent the most time playing with was the one that…
Scriptio [http://www.sqlteam.com/publish/scriptio/] is updated to 0.5.2. This version offers better support when switching servers. It also provides a friendly error message if you choose a SQL Server 2000 server. Update: Most recent install and source code: http://weblogs.sqlteam.com/billg/archive/2006/…
I posted the source code [http://www.sqlteam.com/downloads/scriptio.0.5.1.0.zip] for my SQL Server 2005 object scripting tool. The code reads like something I threw together to see if I could really do this. Because that's what it is. You can read…
After working with SQL Server 2005 I've discovered that I can't script out one object per file and include both the DROP and CREATE in the same file. Which is driving me absolutely crazy! So I wrote a little utility and thought I'd share…