Over the years I’ve collected many script for SQL, but as I’ve start to broaden into other coding areas like Python and Powershell I thought it was about time to make my github repository open for others to use. https://github.com/DataDoor/Code Hopefully some of these scripts will be of some use to people. Advertisements
Every day is a good day to meditate. https://hdsp.co/e/TdTFYh73vL
Over a year ago Microsoft released a new kind of certification which was different to its usual study and sit an exam type, for this certificate you needed to pass various courses on different subjects which were all related to an over arching subject of Data science. This peaked my interest initially, but this quickly […]
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 […]
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 […]
A new feature in SQL Server 2016 and the Azure SQL database is something called Dynamic data masking. This is essentially used to mask the data from prying eyes and is helpful for blocking some users or DBAs from seeing confidential types of data like account numbers. So let see and example of how this works, […]
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 […]
