SQL Server 2008 CTP5 on Friday
It looks like SQL Server 2008 CTP5 should be available for download on Friday. It's already in Connect for certain testing groups.…
Login Events include Pooled Connections
Every now and then I stumble across something and say "I know I knew this before!" In Profiler, the Audit Login event includes regular logins and connection pooling reuse. If you run a trace and see a large number of logins you'll need to include the…
Read90Trace coming soon!
Bob Ward announced in his PASS pre-conference session that Microsoft will be releasing a SQL Server 2005 version of Read80Trace in roughly 30 days. It's currently going through a security review. They're planning to call it ReadTrace instead of Read90Trace though. I don't know…
Viewing Database Updates through ODBC using Profiler
I just finished writing a small data update utility to copy a single row of data from a custom written application into a piece of packaged software. Usually when I do this I turn on Profiler, watch the packaged software insert a row and then copy what they did. This…
Upgrading to SAS drives
We were having some disk drive performance issues at a client recently. They have a 6 drive array running RAID 10. We spent some time running SQLIO [http://www.microsoft.com/downloads/details.aspx?familyid=9a8b005b-84e4-4f24-8d65-cb53442d9e19&displaylang=en] against the array. Our standard test was an 8KB random read…
SQL Server 2005 SP2 Build 3054
The joy that is SP2 just keeps on giving. Microsoft released a hotfix (KB934458 [http://support.microsoft.com/kb/934458]) to bring it up to 3054: > FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances…
SQL Server 2005 SP2 Available
And it is available today. Microsoft released SQL Server 2005 SP2 [http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx] .…
ClearTrace Video
I created a small video [http://www.cleardata.biz/cleartrace/ClearTraceDemo.wmv] to demo ClearTrace [http://www.cleardata.biz/cleartrace/default.aspx]. It's only about two minutes long. This is also the technology we're planning to use at the PASS Conference to capture presentations.…
Yet Another ClearTrace Update
These titles seem to be getting repetitive. I updated ClearTrace [http://www.cleardata.biz/cleartrace/default.aspx] again. I'm also back to using a ClickOnce installer. Unfortunately if you switch from an unsigned to a signed ClickOnce installation the existing people can't upgrade. How annoying! That…
ClearTrace Updated
Since I last posted here I've updated ClearTrace. You can download it here [http://www.cleardata.biz/cleartrace/download.aspx]. There's also a ClickOnce installation if you just want to use the GUI version. ClearTrace now supports moving the trace files to an archive directory after…