Chapter 17. Administrative Transact-SQL

Thinking is the hardest work there is, which is probably the reason so few engage in it.

—Henry Ford

While database administration itself is beyond the scope of this book, we can still delve into administrative Transact-SQL in some depth. In many shops, the line between database programmer and database administrator is a gray one indeed, so, regardless of whether you're a DBA, it's handy to have a working knowledge of administrative Transact-SQL commands and syntax.