Showing posts from May, 2017

Creating Users in Azure SQL

I have been working quite a lot in Azure recently and have done some work with SQL Azure PaaS databases. I am not an SQL DBA by any stretch of the imagination, so some tasks have taken a bit of Googling to conquer! There are some key differences between a full SQL install and Azure SQL .  One of the main differences with Azure SQL Azure PaaS databases is that you need to do so much more through Transact-SQL.  My limited experience of SQL has all been based through GUI prompts, so this initially proved a problem for me. One of the tasks which I have had to complete a fair amount recently is to create database users.  In the Azure Portal you can create administrator accounts for the whole server, but this doesn't match the requirements of the business in most occasions. I came across these blog posts on the Microsoft website