SQL Server Backups to Azure Storage

Since SQL Server 2014 we’ve had the capability to  backup databases directly onto azure storage, before you’re able to do this however there are a few steps which need to be setup first via Azure and in SQL Server itself. CREATE STORAGE ACCOUNT, KEYS AND CONTAINER Firstly, logon to your Azure account, if you don’t […]

JSON (Extract & Query)

A new feature in SQL Server 2016 (also available in Azure SQL database) is the ability to create and query  JSON (Javascript object notation) documents, which have now become a common alternative to XML. Lets look at some examples, I’ll be using tables from the new sample database for SQL Server 2016 WorldWideImporters which you […]

CONCAT() The forgotten T-SQL function

We’ve all been in a situation before where you’re attempting to concatenate a string and integer values together and been presented with the below error. Msg 245, Level 16, State 1, Line 13 Conversion failed when converting the varchar value [VALUE] to data type int. which is usually greeted by a loud sigh. Let me […]