See why you might be getting unexpected syntax errors when using builtins within table-valued function calls.

See a quick metadata script that finds all tables, across all user databases, without a primary key.

Learn why you shouldn't use BETWEEN for date range queries, even with the date data type.

On older versions of SQL Server, it was tedious work tying DBCC INPUTBUFFER output to active requests. See one way we used to do this.

For this month's T-SQL Tuesday, I talk about EXCEPT (and INTERSECT) as possible replacements for clunky join syntax.

I talk about a couple of minor changes to Policy-Based Management in SQL Server 2012.