I show DDL commands in Azure SQL Database that can now run as online operations instead of blocking, size-of-data operations.

I address a popular theory that NOLOCK can substantially reduce locking overhead against #temp tables.

Tip : Give SQL Server users access to Extended Events

I talk about a couple of subtleties of THROW, and how to avoid frustrating bouts of troubleshooting.