I perform some deeper testing on triggers, showing that INSTEAD OF triggers are worth a look.

Tip : Validate the contents of large dynamic SQL strings in SQL Server

I talk about SQL Server 2014 Standard Edition and a couple of little carrots that might make this upgrade more compelling than SQL Server 2012.

Tip : Handle conversion between time zones in SQL Server – part 2

Tip : Handle conversion between time zones in SQL Server – part 1