SQL SATURDAY – NASHVILLE Cloudy with a Chance of Data John

SQL SATURDAY - NASHVILLE Cloudy with a Chance of Data John Deardurff Website: ThatAwesomeTrainer.com Twitter: @John Deardurff Email: [email protected]

Cloudy with a Chance of Data SQL Saturday – Nashville Iaa Paa S SaaS S What is Azure? Cloud Models On-Premises vs Cloud Managing Azure January 13th, 2018 Cloud Data Platform

What is the Cloud? Is it just someone else’s computer? Who controls the cloud? What is useful about cloud computing? Create new apps and services Store, Backup, and Recover data Host Websites and Blogs Stream audio and video Deliver software on demand Analyze data patterns Create predictive models

What is Microsoft Azure? Global Datacenters Rapid Elasticit y Reduced Capital Expense s Improved Agility Measured Services Manage d Services

Cloud Computing Models A private cloud is a privately owned and managed cloud that offers benefits similar to those of a public cloud, but is designed and secured for use by a single organization. A hybrid cloud is a technology that binds two separate clouds— public and private— together for the specific purpose of obtaining resources from either of them. A public cloud is an infrastructure, platform, or application service that a cloud service provider delivers for access and consumption by the public.

On-Premises vs Cloud Windows Server System Center (Server Platform) Physical Virtual Microsoft Azure IaaS PaaS SaaS

On-Premise or On-Premises VS Premise An Idea Premises A

Cloud Models

Pizza as a Service

Services Manager vs Resource Manager Azure Services Manager Retired 1/8/2018 Azure Resources Manager www.Portal.Azure.Co m

The Azure portal

Other Client tools Windows PowerShell with Azure PowerShell modules: Run commands and scripts to manage Azure from Windows, Linux, OS X Azure CLI: Run commands and scripts to manage Azure from Windows, Linux, OS X Visual Studio with Azure SDK for .NET: Build solutions targeting Azure Azure Cloud Shell: Use command line interactively directly from within the Azure portal

Microsoft Azure Documentation https://docs.microsoft.com/en-us/azure/sql-datab ase/

Cloud data offerings SQL Server in Azure VM Azure SQL Database Azure SQL Data Warehouse Azure Storage Options SQL Server in Azure VM Azure Data Lake Store Azure Data Factory Azure HDInsight

Cloud data offerings SQL Server in Azure VM Azure SQL Database Azure SQL Data Warehouse Azure Storage Options Azure SQL Database Azure Data Lake Store Azure Data Factory Azure HDInsight

Cloud data offerings SQL Server in Azure VM Azure SQL Database Azure SQL Data Warehouse Massive Parallel Processing Azure SQL Data Warehouse Azure Storage Options Azure Data Lake Store Azure Data Factory Azure HDInsight

Cloud data offerings SQL Server in Azure VM Azure SQL Database Azure SQL Data Warehouse Azure Storage Options Azure Storage Options Azure Data Lake Store Azure Data Factory Azure HDInsight

https://azure.microsoft.com/en-us/features/storage-expl orer/

Cloud data offerings SQL Server in Azure VM Azure SQL Database Azure SQL Data Warehouse Azure Storage Options Azure Data Lake Store Azure Data Lake Store Azure Data Factory Azure HDInsight

Cloud data offerings SQL Server in Azure VM Azure SQL Database Azure SQL Data Warehouse Azure Storage Options Azure Data Factory Azure Data Lake Store Azure Data Factory Azure HDInsight

Cloud data offerings SQL Server in Azure VM Azure SQL Database Azure HDInsight Map Reduce, Pig, Hive, Hbase, Storm, Spark Azure SQL Data Warehouse Azure Storage Options Azure Data Lake Store Azure Data Factory Azure HDInsight

Cloud data offerings Event Hub Stream Analytics Azure Data Lake Analytics Azure Machine Learning

Cortana Analytics Suite Information Management Big Data Stores Machine Learning and Analytics Business apps Azure Machine Learning Azure Data Factory Azure Data Lake Custom apps Azure Data Catalog Azure SQL Data Warehouse Azure Event Hub DATA INTELLIGENCE Power BI Personal Digital Assistant Cortana Azure HDInsight (Hadoop) Azure Stream Analytics Azure Data Lake Analytics Sensors and devices Dashboards and Visualizations People Perceptual Intelligence Face, vision Speech, text Business Scenarios Recommendations, customer churn, forecasting, etc. Automate d Systems ACTION

Good Luck Introducing Cloud Data Platform Services

2016 Microsoft Corporation. All rights reserved.