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

You want to implement a fast parse of...

Beyond Relational

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

Consider the following batch of T-SQL:

EXEC('SELECT CONVERT(int, ''abc'')')
PRINT...

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