I released ClearTrace 2.0.9. You can find the information here [http://www.cleardata.biz/cleartrace/default.aspx]. I moved the download to my corporate site so I can keep a static page up for information. I'm pretty happy with this version. It seems to be very…
You can download the PowerPoint file and demo script from my webcast here [http://www.sqlteam.com/downloads/sql2005webcast.zip]. I'll post a link to the recorded presentation when they post it. You can view the recorded webcast by registering here [http://ad.doubleclick.net/clk;26540591;12550611;…
I've made some pretty significant changes to this tool. * It now writes to multiple tables instead of a single table. This greatly reduces the space required and the import time. It creates the objects it needs in the database specified. All the objects have a CT prefix in…
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…
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…
The downside of having a blog and SQLTeam.com is that I feel like I have to post some things in both places. And this is one of those things. The Developer Edition of SQL Server 2005 is "available" on MSDN. MSDN is swamped so good luck getting…
Of all the presentations that MS submitted for the PASS Conference, this was the one that intrigued me the most. It's on Wednesday at 1:30PM and is being delivered by Alan Griver [http://ew.sqlpass.org/ew/pass/displaymod/detailevent.cfm?conference_id=11&event_id=…
From the Visual Studio Data Team blog [http://blogs.msdn.com/vsdata/archive/2005/09/12/Announcing_Linq.aspx] ... At the PDC Microsoft announced LINQ (Language Independant Query) Framework. This gives you the ability to use a SQL-like language on your collections (anything IEnumerable). The example from the blog is:…
I've updated my NAnt tasks to 0.94 (source [http://www.sqlteam.com/downloads/ClearData.NAntTasks-0.94-src.zip] and binary [http://www.sqlteam.com/downloads/ClearData.NAntTasks-0.94.zip]). I've added three new tasks. The first is a task to load an Excel spreadsheet into a…