RetiredDBA.com

All things for Microsoft SQL Server

Are your stepping out to the clouds DBAs?

Sep 12, 2019



Webinar review of: Azure Cloud & You: First Steps for the DBA by John Morehouse on 8/7/2019. Morehouse is a consultant with Denny Cherry & Associates Consulting and leader of the Louisville SQL Server / Power BI user group.

The description of the webinar states: “Azure offers up a new world of possibilities for DBAs and we should all strive to learn it…. We will stand up a new Azure virtual machine as well as setup a SQLDB.”

The webinar started out by Morehouse stating “There is no cloud. It’s just someone else’s computer!”. Morehouse then went over details of some wide ranging Microsoft Azure Cloud topics.

Terminology

  • “On Prem”
  • IAAS – Infrastucture as a Service
  • PAAS – Platform as a Service
  • SaaS – Software as a Service
  • AAD – Azure Active Directory
  • ARM – Azure Resource Manager
  • LRS / GRS / ZRS / RA-GRS – Types of storage
  • Resource Groups – Tupperware container of Azure
  • Geograpies/Regions – Aids in getting resources closer to end user

Various ways to use Microsoft Azure cloud

  • VM hosted on IaaS provisions in 15 minutes and grows / shrinks as needed with a reboot.
  • SQLDB is just a database in the cloud that is automatically upgraded, patched, backed up, etc.
  • Managed Instances (MI) – Can’t see OS but can see SQL Server and run SQL agent jobs, etc.

Microsoft Azure cloud command line possiblitilties

  • Powershell
  • Azure powershell
  • Azure command line interface (CLI)

Microsoft Azure cloud mobile app capabilities

  • Start/stop VMS
  • BASH scripts
  • Powershell

Morehouse covers alot of cloud information in the webinar in a short time. I give the webinar ‘Azure Cloud & You’ a thumbs up. Right?

And don’t forget DBAs, here’s a list of several cloud tier trial versions: https://retireddba.com/cloud/


Ad

Whizlabs – 165 Practice Questions for Microsoft Azure Exam AZ 400 | Buy Now

Edureka – DevOps Training by Edureka Gain expertise in various Devops processes and tools like Puppet, Jenkins, Nagios, GIT for automating multiple steps in SDLC, Ansible, SaltStack, Chef. Know More!

Whizlabs – Practice Tests for Exam AZ-400: Microsoft Azure DevOps Solutions

Whizlabs – Online Training for Agile Certified Practitioner (PMI ACP)® Certification Exam | Enroll Now

Edureka – Data Science Training by Edureka Drive Business Insights from Massive Data Sets Utilizing the Power of R Programming, Hadoop, and Machine Learning.

Ed2Go –Intermediate SQL – By the end of this course, you’ll be able to use a wide range of advanced SQL techniques with confidence.



Advertisement

Ally - Get a bonus when you open an eligible Ally Bank account.

Amazon Prime Visa - Get a Amazon Gift Card instantly upon approval of Amazon Prime Visa

Chase Checking - Open your Chase checking account and get a bonus!

Chase Freedom Flex - Earn unlimited cash back with the Chase Freedom Flex credit card.

Chase Freedom Unlimited - Earn cash back with the Chase Freedom Unlimited credit card.

Chase Saphire - Open your Chase Saphire Preferred or Reserve and get bonus points and more!

Discover - Get a bonus when you open an eligible Discover account.

Marriott Bonvoy Credit card - Open your Marriott Bonvoy Credit card and get a new Cardmember bonus!

Rakuten - Sign up for Rakuten and earn cash back on your purchases at 3500+ stores. 20M+ members in the U.S. have earned over $3.2B in Cash Back at their favorite stores.

Schwab - Open a Schwab account and get up to $1,000 depending on your net deposit.

Xfinity - Open an Xfnity mobile or internet account and get a bonus