December 2004 - Posts

Help fix Google Groups

Any regular user of Google Groups has now had to suffer through the pain of using their new "beta" system. Basically, it sucks. They've ruined a totally perfect system.

So I'd like to ask everyone to please tell them about it!

I'm hoping that if we get enough requests in, they'll at least fix some of the more obvious problems:

A) Brought to my attention by Steve Kass is this little issue caused by their attempt at thwarting e-mail address harvesting... If you post this code block:

return cast(@x%@two_32_N*@two_N + @x/@two_32_N as binary(4))

... and then search for the message, this is what you'll see:

return cast(@x...@two_32...@two_N + @x...@two_32_N as binary(4))

That totally ruins any old code (that has variables) in the SQL Server group archives. Very annoying.

B) A smaller issue that I've noticed is that their new UI includes very little indication of where one message ends and the next begins when viewing a thread. The old system had a large horizontal rule between messages. I'm sure their designers think that the new, tiny headers are "cleaner" looking, but instead they've ruined usability of scrolling through longer threads.

C) Search just doesn't seem to work as well anymore. I seem to be getting a lot more unrelated hits than I used to.

Other problems people are having? Please leave them in the comments so we can all send nice big lists to Google...

Code Camp III

I've been totally remiss in my duties -- and have forgotten to blog about Code Camp III, which was announced by Thom Robbins over two weeks ago!

I attended Code Camp II and it was a great free conference with some very useful talks. But the data track was incredibly light. So this is my own call to anyone in the New England area who's data-centric to submit an abstract! There is no reason that the data track should have only four or five talks. I think we all know what an important area it is.

December 17th, already?

It's been an incredibly busy month (I guess December usually is), and I've totally dropped the ball on regular posts. I've been working non-stop both at my day job (this is our busy season, as we are in the retail sector), and off hours (I'm working on a few SQL Server 2005 chapters, about DBA topics and SQLCLR). And on top of that, I came into possession of a couple of certification vouchers that are going to expire on the 31st, so this weekend I'm planning to take 70-228 (SQL Server 2000 Admin) and 70-019 (SQL Server 7.0 Data Warehousing).

But that doesn't mean I haven't also been working on lots of content for this blog...

I have a list going that currently has around 20 topics I'll be discussing in coming months. On the short list for the coming days or weeks (whenever I have time to finish these things), expect content on:

  • T-SQL Queuing systems (Pre-Service Broker)
  • Stored procedure execution plans and recompilation
  • More info on batching data modifications
  • Triggers and data auditing
  • SQL Server 2005 exception handling / TRY-CATCH syntax
  • ... and a bunch of performance related topics

I have most of the content half-written and am running lots of tests to make sure I don't post (too much) faulty information. So stay tuned, and if you don't hear from me before then have a great holiday season and happy New Year!