Tech Blog

Did you know that in SQL Server 2016 you can now specify the location of the tempdb files during setup?

Did you know that you can use the output clause to return updated or inserted rows without having to select them again?

SQL Server 2016 enters general release today. To mark the occasion, we asked a couple of our SQL Server experts, Head of Microsoft Solutions and Architecture Rob Hawthorne, and Senior Consultant Richa…

This post is based on a presentation by Rob Hawthorne at the Customer 3.1 Conference in Auckland this week.

Most developers know the # preceding a local temporary table very well, as temporary tables are really useful when you need to keep some stuff in a place for a moment while you do something else. But…