Last Thursday, I presented a session in Orlando about hidden Transact-SQL features in SQL Server 2000.

It is surprising to see how, more than 4 years after SQL Server 2000 was released, we still find surprising features in SQL Server Books Online. Features such as application locks, extended properties, or SQL-NS (I’m not referring to Notification Services here) are still unknown to many SQL Server developers, and these features have been documented since day one.

I know we are all busy trying to meet our deadlines, and solving our day to day problems, but a quick review of the Books Online index would give us a very interesting overview of what is available in this old and still exciting release of SQL Server.