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…
The world needs more SQL injection comics [http://xkcd.com/327/].…
The Code To Live [http://channel9.msdn.com/shows/Code_To_Live] video starts with an All-Girl AC/DC cover band. I'm not really sure what else you need to know. Steve Loethen [http://geekswithblogs.net/thesenator/] is a Developer Evangelist for Microsoft here in Kansas City (or…
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…
If you're reading this post on the actual SQLTeam.com Weblogs [../../../../] homepage you'll notice that the count of posts now says 1,000. I'm happy to say that 90% of those posts have come from other people. Three weeks from now is the four…
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…
If you visit the blogs of Jeff Smith [http://weblogs.sqlteam.com/jeffs/] and Mladen Prajdić [http://weblogs.sqlteam.com/mladenp/] you'll notice they are now running the same ads as the main site. They were both running generic Google ads prior to this. We were able to…
I posted another version of ClearTrace just a minute ago. This should process 64-bit trace files on either x86 or x64 machines. If you have trouble please post in theClearTrace Support Forum [http://www.sqlteam.com/forums/forum.asp?FORUM_ID=27]. Please visit the ClearTrace download [http://www.cleardata.…
Back when I actually had time to work on ClearTrace [http://www.cleardata.biz/cleartrace/default.aspx] I had visions of selling the software. I don't think that's going to happen anytime soon. I don't have time and there's a bug in…
I'm finally doing a little work on ClearTrace [http://www.cleardata.biz/cleartrace/default.aspx]. The only visible result of this so far is that you can download a ZIP file of the executable instead of using the ClickOnce. This should make it easier for non-Internet Explorer users.…