1 / 45

Putting Your Head in the Cloud

This guide explores cloud computing basics, Azure SQL, and benefits/limitations. Learn about service tiers, backups, high availability, and more.

benford
Download Presentation

Putting Your Head in the Cloud

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Putting Your Head in the Cloud A Beginner’s Guide to Cloud Computing and Azure SQL Database David Postlethwaite David Postlethwaite

  2. Our Sponsors Platinum Sponsors Bronze Sponsor Silver Sponsors David Postlethwaite

  3. About Me • David Postlethwaite • Liverpool Victoria LV= • SQL and Oracle DBA • MCSE 2012 Data Platform • MCITP 2008, 2005 • Oracle OCA • 25 years IT Experience • 7 years as DBA • david@clunyweb.co.uk • Blog: gethynellis.com 3 | David Postlethwaite

  4. Introduction Putting Your Head in the Cloud What is cloud computing? Where did it come from? What Types of Cloud Computing are there? Why might I want to use it? Why might I NOT want to use it? Microsoft Azure SQL Azure 4 | David Postlethwaite

  5. Free E-Book Sign up at www.gethynellis.com David Postlethwaite

  6. Who is using the Cloud now? For Business use? For Personal use? David Postlethwaite

  7. Why the Cloud? (IBM archive) “Why do we need to buy and maintain our own servers and spend our lives upgrading and fixing them?” “Why do we need an expensive DR site that sits idle most of the time?” “Why can’t I just rent a file server or a database server or a webserver or even an application and pay someone else to manage it?” David Postlethwaite

  8. What is Cloud Computing? Wikipedia cloud computing noun: cloud computing; The practice of using a network of remote servers hosted on theInternet to store, manage and process data, rather than a local serveror a personal computer. David Postlethwaite

  9. Examples SoftwareOffice 365Skype for WebAdobe Creative Cloud - PhotoShop OnlineQuickBooks Online Visual Studio Online HostingMicrosoft Azure Oracle CloudAmazon Web Services Google Cloud Platform + many other smaller providers Web Emailgmail Hotmail Storage Microsoft One Drive Google Drive Apple iCloud Amazon Cloud Drive Drop Box David Postlethwaite

  10. Cloud Service Models Traditional on-premises Infrastructure as a Service (IaaS) Platform as a Service (PaaS) Software as a Service (SaaS) Application Application Application Application Servers to Rent Apps to Rent Hardware to Rent Data Data Data Data Runtime Runtime Runtime Runtime Middleware Middleware Middleware Middleware Operating System Operating System Operating System Operating System Virtualisation Virtualisation Virtualisation Virtualisation Servers Servers Servers Servers Storage Storage Storage Storage Networking Networking Networking Networking Managed By Client Managed By Vendor David Postlethwaite

  11. Advantages of the Cloud Quick Setup Scalability Cost Efficient Backup and High Availability Mobility Environmentally Friendly Innovation Security David Postlethwaite

  12. Disadvantages of the Cloud Security and Privacy Dependency Loss of Control Reliability and Vulnerability Government Interference David Postlethwaite

  13. Microsoft Azure David Postlethwaite

  14. Microsoft Azure Data Centres Dublin Data Centre Chicago Data Centre technet.com www.digitalsignage.net/ Dublin 581,000 square feet - 54,000 m^2 – 4 football pitches Chicago 700,000 square feet - 65,000 m^2 Iowa 11.2 million square feet - 10,000 m^2 David Postlethwaite

  15. Inside the Azure Data Centres 1,800 -2,500 servers 100 Containers 220,000 servers David Postlethwaite

  16. Power Usage Effectiveness PUE Industry Average 2.0 Azure Data Centre 1.25 Power usage effectiveness (PUE) is a measure of how efficiently a computer data centreuses energy; How much energy is used by the computing equipment compared to the energy used for cooling and other overheads). David Postlethwaite

  17. Demo Microsoft Azure http://azure.Microsoft.com David Postlethwaite

  18. Windows Azure Portal David Postlethwaite

  19. Windows Azure Classic Portal David Postlethwaite

  20. Azure SQL Database David Postlethwaite

  21. Create an Azure SQL Database David Postlethwaite

  22. Create Azure Database - Source David Postlethwaite

  23. Create Azure Database - Tier David Postlethwaite

  24. Create Azure Database David Postlethwaite

  25. Allowing Access to Azure DB David Postlethwaite

  26. Azure Connection Strings David Postlethwaite

  27. Connecting to Azure SQL Database David Postlethwaite

  28. Using SSMS Limited GUI with SSMS 2012 or SSMS 2014 RTM SSMS 2014 SP1 and 2016 gives better support Need to write code Need the azure syntax Can’t use “USE” New commands to manage firewall rules Sp_set_database_firewall_rule sp_set_firewall_rule David Postlethwaite

  29. Limitations of Azure SQL Database Unsupported Features Extended Properties Anything to do with Agent and msdb Features related to database file placement, size etc. Many DBCC commands  Filestream Global temporary tables Linked Servers SHUTDOWN https://msdn.microsoft.com/library/azure/ee336281.aspx David Postlethwaite

  30. Azure Database Service Tiers David Postlethwaite

  31. Service Tiers and Performance Levels * Prices as at 21/04/2016 David Postlethwaite

  32. Backups and High Availability Full database backup once a week, Differential database backup once a day, Transaction log backup every 5 minutes. Full and differential backups are copied to another region Retention: Basic 7 Days, Standard 14 Days, Premium 35 Days Three database replicas on different physical hardwareone primary replica two secondary replicas. GEO Replication Standard: one read only secondary in different data centre Premium: four read only secondaries in different data centres David Postlethwaite

  33. SQL Database Restore David Postlethwaite

  34. DACPAC and BACPAC SSMS 2012+ BACPAC Export Data Tier Application – schema + data DACPAC Extract Data Tier Application - schema Azure currently only supports BACPAC Validates the schema before creating the file Save to local disk Copy BACPAC to Azure storage for Import from the Management Portal Or Export straight to new database on Azure Server David Postlethwaite

  35. Standard Geo-Replication David Postlethwaite

  36. Active Geo-Replication David Postlethwaite

  37. SQL Database Monitor David Postlethwaite

  38. SQL Database Monitor David Postlethwaite

  39. Automated Export David Postlethwaite

  40. SQL Database Auditing and Security David Postlethwaite

  41. Azure Virtual Machine David Postlethwaite

  42. New Features Azure Elastic Database Share DTUs between a pool of databases Automatic power changes Azure Data Warehouse A database for massive volumes of relational and non-relational data Uses massive parallel processing (MPP) architecture Azure Data Lake A hyper-scale repository for big data analytics workloads Hadoop Distributed File System Unstructured and structured data in their native format David Postlethwaite

  43. Grammar – short for premises – a proposition or assumption – a building or property Prem Premise Premises David Postlethwaite

  44. Any Questions Conclusion Hopefully you now have a better understanding of SQL Azure Q & A david@clunyweb.co.uk Blog: gethynellis.com https://www.linkedin.com/in/davidpostlethwaite David Postlethwaite

  45. Thank You David Postlethwaite

More Related