Eshant Garg
Azure Data Engineer, Architect, Advisor
eshant.garg@gmail.com
Learning Objectives
• You will be able to create a Azure subscription
• You will be very familiar with Azure portal
• You will have high level understanding of Azure Services categories
• You will be able to create and manage resources through recourse groups.
• You will have good hierarchal understanding of Resource management.
• You will be able to create Tags for billing and other purpose
• You will be able to give role based access to other users.
• And at the end you will provision brand new SQL Database service, and connect it through SSMS
and make sure it is ready to start working.
Azure Free Subscription
What if I exceed my $200 limit?
• Email message is sent to subscription owner.
• Deployed resources are disabled until next billing cycle.
• Database and storage account become read only.
• Subscription can be upgraded to Pay-as-you-go
Azure Services Overview
Cloud solution offers lot of benefits
Variety of options provided
Hybrid options can also be considered
Azure Services
Azure Portal
• Azure Portal is primary graphical user interface (GUI) for controlling Microsoft Azure.
• Alternatively you can do everything using command line tool
• Azure portal is designed in a way to provide continuous availability.
• When you open portal, it get loads from closest location
• Portal continuously maintain behind scene and requires no downtime
Managed and unmanaged Data Service
• Services are grouped in to Managed and Unmanaged
• Considerations
• Operational responsibility (Patching, monitoring, backing up etc.)
• Security responsibility (firewalls, auditing, ACL’s etc)
• Compliance and regulatory adherence responsibility
• Focus on ownership
• Shared responsibility
• Conclusion – Prefer managed service as much as possible
Application resources
Application
Enterprise divisions
Business Unit Geographic
Consumer Electronics Medical US East Europe
Resource Group Rules
Resources in a resource group should share the same lifecycle
Each resource can only exist in one resource group
Resources can be added to or removed from a resource group at any time
Resources can be moved from one resource group to another
Resources group can contain resources that resides in different regions
Resources can interact with resources in other resource group.
Resource Provider
Many common
Resource providers get
resource providers are
registered with the
registered
subscription
automatically
This requires
E.g permissions from
Microsoft.Compute either the contributor
or owner roles
Why Tag Resources
• Tags are additional metadata associated with Microsoft Azure ARM resources.
• Organized deployed Azure resources
• Search by tag
• Facilitates viewing related resources
• Facilitates billing and cost management
Role Based Access Control (RBAC)
• Roles are applied to a scope
• Management groups
• Subscription
• Resource group
• Individual resource
• Roles are assigned to
• Users
• Groups
• Service Principal
Role Inheritance
User is assigned the
Virtual Machine
Contributor role at
the subscription level
User inherits the role User inherits the role
for Resource Group 1 for Resource Group 1
Quiz
• How much you invested to provision new database?
• How long it took you to get it ready?
• Tomorrow if you have more business and you want to scale it,
how long it will take?
• Can you estimate how much you have to pay?
• And what about if you have customers in other part of the
world?
Learning Outcome
• You created a free Azure subscription
• You should be familiar with Azure portal
• You have high level understanding of Azure Services categories
• You know how to create hierarchy of Resource Management, subscription, and resource group
• You can create and filter Tags
• You know how to setup role based access control
• And by now you can create SQL Server on Azure cloud, connect it with your SSMS and play around it.
