DBCC Internals

CHECKDB

- needs consistent view of the db. Needs to do this without locking. In
SQL Server 2000 log analysis is used....

Beyond Relational

I missed this yesterday, but I saw it on the schedule again, and I knew
I had to make this one....

Maintenance in SS2K5

Andrew Kelley from Solid Quality Learning did this one, which was good.
I was worried it would be about maintenance plans,...

SQL Server Always On

Everyone wants 5 9's of uptime, 24x7 support, and instant fixes for
issues with their database server. Never mind that I'd...

SQL Server 2005 Tools

A good talk on the tools from the guy that's responsible for SSMS,
Configuration Manager, Maintenance plans, Surface Area Configuration
Wizard, and...

Reunion

We're not partners anymore in SQLServerCentral.com, but Andy, Brian,
and myself got together last night for dinner. We haven't seen each
other...

Working Afternoon

I ended up driving around Orlando this afternoon to get books. We'd
printed the next version of our Two Minute SQL...

First Session

I dropped into Brian Knight's "Clustering in 60 Minutes" to say hi. If
you've never seen this, it's pretty cool and...

Tech Ed - Keynote

These will get pretty long as I'm kind of wordy, but these are impressions as things are occurring.

Registration is a...

Clustered Index Seek or Key Lookup

When I teach performance tuning I always remind students to be cautious about service packs because things you "know" may...