Database

Question 1

Cosmos Db

Answer 1

Synchronization

Easy with Cosmos:
Traditional databases that were not cloud enabled could be very difficult to setup across multiple regions. Azure take care of all it with cosmos

One click to add regions:
it is very easy to expand to more regions with cosmos Db and have the data stay in sync.

Continued Synchronization:

Cosmos DB stays on top all reads and writes to your data and makes sure data is moved between regions to stay in sync

Latency: cosmos DB promises single digit 0-9milliseconds latency.

Scalability:
Automated: Cosmos DB automatically scales up to meet resource demands

Infinite resources:
Any number of users of your application can be supported

Lowest Price: Even though scaling is automatic, you only for resources you use

Connectivity:
Developers:
Choose from various Software development kits(SDK’s) and API’s
Languages: supports C#, java and node.js
Platforms: Choose from lots of data platforms to integrate with, including SQL, mongoDB, cassandra

Warning: Costs run up quickly, they are expensive

Question 2

Azure SQL

What is Azure SQL?
Usecase/scenarios?
MI in SQL
Benefits

SQL Database bs SQL Managed Instance

Answer 2

Azure SQL is a managed service, Azure take responsibility of hardware and IAAS.
Scenarios:
Migration : you can migrate on-prem sql server to Azure sql , no changes are needed to your on-prem DB

it is friction less process
cost saving
Lower total cost of ownership

Built in machine learning:

Optimization: Suggestions on how to optimize and improve performance on Azure Sql instances

Warnings: you will get warnings of degrading instances and if anything out of ordinary is happening

Benefits:
scalability: you can scale your azure sql instances and get high availability as well

Space: Manage huge databases upto 100Tb

security: benefit from built in security features of the azure cloud platform.

Azure SQL database:
Most like traditional SQL server

Azure SQL managed instance: Aimed at migrating from on-prem to Azure SQL DB

Question 3

Azure database for MYSQL

Features
Advantages
usecases

Answer 3

MySQL features
Open Source: MySQL is an opensource project where any member of the community can contribute.

Relational Database:
Data in the database is connected through relations in the data itself

Mature and Stable:
Millions of applications and websites uses MySQL. it is both a mature and stable product.

Advantages:
Platform as a service: The service infrastructure is managed by Azure

Development focus: Focus on developing your business strengths instead of managing servers and n/w

Choice of language: Use the language and framework of your choice, such as PHP and wordpress.

High Availability: Cloud glitter can provide high availability and scalability with ease. this means MYSQL can handle an increasing number of users

Azure security features: you get all the high standard Azure security features included

Cloud capabilities: All the cloud PAAS features such as patches, upgrades, automatic backups and monitoring are included in pricing

Use cases:

Web-applications
e-commerce
mobile apps
digital marketing
Finance management
gaming

Question 4

PostgreSQL

Features
Advantages
Use cases

Answer 4

1. Open source Database : it is open source relational database like mysql
2. The name though: it came “post” the database Ingres, so the name became postgres
3. Free and stable: it is free and very stable. Constantly improved from 1996

Features:

Extensions: use a large number of extensions such as JSONB, geospatial functions, indexing, integrating with tools and much more

Horizontal scaling: use very high performant access to distributed data sets. in other words use data faster across hundreds of data sets

Performance recommendations: get recommendations on how to make your database perform better. Get notifications for disruptive events

Fully managed: Azure give you automatic patching, automatic built in backups and monitoring included.

Use cases:
Financial Applications
Government
Manufacturing

Question 5

Database migration service

Answer 5

there is a dedicated tool to migrate database from on-prem to Azure

Single tool:
one step migration for Microsoft SQL to Azure SQL

Documentation:
Comprehensive step-by-step guide and documentation for helping to migrate

Guides for non-ms
Very detailed guides for migrating from non-MS databases

Question 6

Read the summary

Answer 6

watch the class