Dropping support for ancient versions

I've stopped supporting ancient versions of SQL Server, and you should, too. I've cleaned up a lot of old, no longer relevant information.

Partitioning on a budget

I walk through a solution that allows you to achieve some of the benefits of partitioning, without the Enterprise Edition price tag.

Follow-up on cursor options

I add a few tidbits to follow up on a popular post on default cursor options in SQL Server.

I have an aversion to @@VERSION

I suggest a different approach to providing more data about service packs and cumulative updates than messing with @@VERSION.

FORMAT is nice and all, but…

I compare multiple date formatting techniques, demonstrating again that FORMAT() is not worth the convenience.

SQL Server 2016: JSON support

I walk through some of the new JSON-related Transact-SQL functionality that will be available in SQL Server 2016.