SQL Azure DW – What is it? How it works?

Azure DW what is it? Is it the same as SQL Azure but bigger? No. It is kind of…different. It is a full Cloud Service from Microsoft in the Microsoft Cloud (PaaS), multi-tenant, cloud-based data warehouse ‘Platform as a Service’ offering which elastically scales on demand. Separates storage and compute for elastic scale requirements regardless…


Set your PowerShell session to automatically log into Azure

[Edit 18 July 2017] – A recent update in the PowerShell command line tools for Azure has broken my previous scripts.  I’ve now updated the post with the updated commands.  Note you should update your version of the Azure Command Line Tools before configuring this on your own machine.   I’ve been working in Azure…

5

How To: Use the Azure Key Vault to Manage the Key for a TDE enabled Database

There are many posts available showing the steps to create an Azure Key Vault and to use it for TDE, but I’ve not found a good post which helps detail the end to end steps required to do this “smoothly” – so here goes…   In this post I’ll go through: Creating the “custom” application…

0