Katmai Manageability

The database manages itself. Not totally, but close to it. It was an
analogy made by Dan Jones with cars. Auto...

Southern BBQ

Last night I went out with Tony Davis of Simple Talk and Alan White, a
longtime author for both here and...

SQL Server 2005 Security

It's a similar theme, off by default if it makes sense, minimize surface area.

Recommendations: for new installs, leave stuff off...

Beyond Relational

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

DBCC Internals

CHECKDB

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

Maintenance in SS2K5

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

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...

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...

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...

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...