If you haven't already read it, Kalen has another great editorial in the latest copy of the SQL Mag e-newsletter. What I love about this is not just pointing out some behaviours that others may not be aware of (she focus an database recovery issues, near and dear to my heart), but in what she is really trying to say with the post. MS gets tons of requests for more information (and we see them on newsgroup posts all the time) for information not just on when someone has done something wrong, but a warning before they do it. I know that's true. The more I think about it, my reaction is - what the hell????
If you were an Oracle DBA (ohoh, I said the O word), you are expected (or at least were from versions 9i back) to truly understand the platform. And if you weren't sure about something, you would invoke support. There is still this common mindset out there that SQL Server is this simple database platform where you really don't need a DBA, nor really understand the platform. I've seen it over and over again. I know most of you have too. I think MS is partly to blame for this, with marketing approaches (SQL 7 - it tunes itself!) to gearing the primary user of SQL Server to be Visual Studio. But it is also a fundamental problem with those that manage SQL Servers. Yes, I know a lot of you are DBAs by default. What everyone must understand is that SQL Server is a complex system, and if there's a way to make a mistake, you can do it without the system conveniently popping up to say "Danger Will Robinson!". Education is a never-ending thing - there isn't one person out there that can't learn something from someone else. And for pete's sake, if you aren't sure what is going to happen, FIND OUT first. Let's step up people. Take some personal responsibility rather than blame MS for everything. SQL Server isn't a TV you can simply turn on and off, and adjust the volume, or change the channel...and it never will be.
Kudos Kalen, another great editorial.
BTW, for those of you that don't have it, Kalen has some intense training DVDs out there for unbelieable prices - check her posts to get the address (sorry Kalen, I don't have it off hand).
And for those that might be offended by my position - tough. This is reality. Expecting all the answers to come from someone else without you lifting a finger is, well, irresponsible.