SQL Server 2012

#BackToBasics: DATEFROMPARTS

I continue my #EntryLevel challenge, discussing DATEFROMPARTS() and similar functions introduced in SQL Server 2012.

Announcing SQL Server 2012 R2 and R3!

Microsoft announced today that their next two major releases, each of which contains a major performance-related feature, will follow a naming strategy similar to the 2008 -> 2008 R2 story. Read on for more…

Will you use EOMONTH?

When EOMONTH was first announced, I questioned its value, and thought BOMONTH would have been more useful.

Exploring THROW

I take a look at THROW, new error handling functionality in SQL Server 2012.

SQL Server 2012: Books Online

I highlight some issues with the 2012 release of Books Online, the documentation set for SQL Server.

Pagination with OFFSET

SQL Server 2012 introduces OFFSET and FETCH NEXT clause to help simplify pagination.