Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Azure Cloud Journey Of The DBA

David Cobb
September 15, 2020

Azure Cloud Journey Of The DBA

DBAs losing their jobs to the cloud? WRONG! You are all about data, and so is the cloud! As the database administrator, you have a unique skill set that maps effectively to the cloud and gives you a jump start on learning the skills for the most interesting and in-demand cloud roles. Coming from a DBA role into learning and working in the cloud has been a challenging but rewarding journey. I'll share what I've learned, explain the most promising learning and career paths for data professionals in the cloud, and help you plan your own cloud journey of the DBA.

David Cobb

September 15, 2020
Tweet

More Decks by David Cobb

Other Decks in Technology

Transcript

  1. TODAY'S TALK - The Azure Cloud Journey of the DBA

    Abstract: DBAs losing their jobs to the cloud? WRONG! You are all about data, and so is the cloud! As the database administrator, you have a unique skill set that maps effectively to the cloud and gives you a jump start on learning the skills for the most interesting and in-demand cloud roles. Coming from a DBA role into learning and working in the cloud has been a challenging but rewarding journey. I'll share what I've learned, explain the most promising learning and career paths for data professionals in the cloud, and help you plan your own cloud journey of the DBA.
  2. Goals for this talk Explain how DBA skills map to

    the Azure cloud. Inspire database pros to pursue cloud knowledge via certification paths. Share approaches & habits that have worked for me & others.
  3. About Dave 25 Career in I.T. Past Roles: Tech Support

    -> Helpdesk -> Web Dev -> DBA -> System Admin MCT Since 2002 I.T. Generalist with focus on SQL & PowerShell. A year ago (Sept 2019) I learned I'd no longer have full time employment. I have taken the plunge, learning all I can about Azure
  4. Current Roles: Freelance consulting & technical instructor SQL DBA PowerShell

    / Scripting / Automation Azure Ideal role today: Cloud Engineer Ideal role tomorrow: Cloud Architect Motto: Learn, Do, Teach, Repeat.
  5. MCTs take a lot of tests In 2002 I started

    the Microsoft certification process passing 4 exams to earn an MCDBA cert. I have passed over 10 Azure exams since October 2019 I have failed tests too, including DP-100 (I'll take it again this year) and AZ-204 ( I retook after preparation and passed) Let me share what I've learned to help you learn and work in the Azure cloud. Lets Go!
  6. Monday morning meeting with your boss! Our company is migrating

    to the cloud. We need you to help make a plan for the data! What tools do we use to migrate? Should we use IaaS or PaaS? Should we use SQL VMs, Azure SQL Managed Instances, or Azure SQL Database? Do we need Azure Data Factory? Do we need CosmosDB? Do we need Azure Synapse? It's your job as the DBA to help your company move their applications' data in the cloud. What do you advise? Where do you start?
  7. What's a DBA Do? Understand the organization's data Protect the

    data Move data, import, export Support organization's use of data (applications, reporting, insights)
  8. What does that look like in the cloud? The skills

    of managing and manipulating data will stay largely the same. However, you’ll find yourself doing less patching, maintenance, and administration—and more optimization, experimentation, and high-level data architecture. -The Essential Guide to Data in the Cloud: A Handbook for DBAs
  9. Why Certifications Mattter Certifications set a north star, a direction

    for learning. Provides the foundational knowledge used to gain experience. Validation of knowledge to a degree. Provides an on-ramp. Structured learning. Used as Keywords on Social and your resume. -Josh Duffney (duffney.io)
  10. Fundamentals Optional exams, intended for beginners. Useful for role based

    certifications by not required for them. Master the basics of Microsoft Azure—cloud, data, and AI AZ-900 - Azure Fundamentals ( Exam Page ) DP-900 - Azure Data Fundamentals ( Exam Page ) AI-900 - Azure AI Fundamentals ( Exam Page )
  11. Azure Administrator Optional, but recommended AZ-104 - Microsoft Azure Administrator

    (Exam Page) Focus on core administration tasks of network, storage & compute. ...at least six months of hands-on experience administering Azure, along with a strong understanding of core Azure services, Azure workloads, security, and governance. In addition, this role should have experience using PowerShell, Azure CLI, Azure portal, and Azure Resource Manager templates.
  12. Data Engineer Associate - Exam 1 of 2 DP-200 -

    Implementing an Azure Data Solution ( Exam Page - Skills Measured ) Focus on deploying & configuring the individual technologies ...implement data solutions that use Azure data services. ...tasks that include provisioning data storage services, ingesting streaming and batch data, transforming data, implementing security requirements, implementing data retention policies, identifying performance bottlenecks, and accessing external data sources. ...use the following Azure services: Azure Cosmos DB, Azure SQL Database, Azure Synapse Analytics (formerly Azure SQL DW), Azure Data Lake Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, and Azure Blob storage.
  13. Data Engineer Associate - Exam 2 of 2 DP-201 -

    Designing an Azure Data Solution ( Exam Page - Skills Measured ) Focus on design choices how to use the technologies together ... design data solutions that use Azure data services. ...use relational and non-relational data stores, batch and real-time data processing solutions, and data security and compliance solutions. ...use the following Azure services: Azure Cosmos DB, Azure Synapse Analytics, Azure Data Lake Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, and Azure Blob storage.
  14. Data Engineer Associate - Azure Services Covered Azure Cosmos DB

    ( Docs ) Azure SQL Database ( Docs ) Azure Synapse Analytics ( Docs ) Azure Data Lake Storage ( Docs ) Azure Data Factory ( Docs ) Azure Stream Analytics ( Docs ) Azure Databricks ( Docs ) Azure Blob storage ( Docs )
  15. Data Services - Useful Links Cloud Data Decision Tree Common

    Database Scenarios Architecture - Azure data platform end-to-end Data Store Decision Tree
  16. Database Administrator Associate DP-300 - Administering Relational Databases on Microsoft

    Azure (Exam Page - Skill Measured) ...manage on-premises and cloud relational databases built with Microsoft SQL Server and Microsoft Azure Data Services ...operational aspects of cloud-native and hybrid data platform solutions built with Azure Data Services and SQL Server. ...responsible for management, availability, security, and performance monitoring and optimization
  17. Learning Azure SQL Bob Ward & Anna Hoffman content https://www.linkedin.com/in/bobwardms/detail/recent-

    activity/posts/#learnazuresql https://www.linkedin.com/pulse/learn-azure-sql-security-performance-availability- bob-ward/ https://aka.ms/azuresqlfundamentals https://aka.ms/azuresql4beginners https://aka.ms/sqlworkshops Compare SQL Database to SQL Managed Instance
  18. Preceding exams were focus on the DBA / Data Engineer

    role in Azure Next exams are promising growth paths for the Cloud DBA
  19. DP-100 - Data Scientist Associate ( Exam Page - Skills

    Measured) aka.ms/AzureDataScientistLearn Azure Machine Learning Docs Microsoft Machine Learning Technology Comparision Azure Machine Learning Algorithm Cheat Sheet
  20. AI-100 - AI Engineer Associate ( Exam Page - AI-100

    Skills Measured ) aka.ms/AzureAIEngLearning Choosing a Microsoft cognitive services technology
  21. Certification Study General Approach Review Skills Measured Review Study Guides

    that point to MS Learn Docs Review the Learning Path Quickstarts & Tutorials Do the hands-on work early, avoid just reading about theory, get hands on. Bias to action! Research the options you don't understand, tying the practice back to the theory Practice Exams Whizlabs (recommended), MeasureUp, Udemy
  22. Tim Warner's Cert Study Pyramid ( timw.info ) 3 Interdependent

    Aspects Theoretical Knowledge Practical Application Practice Exam Drilling (Whizlabs recommended) Tim explains on YouTube
  23. 80/20 rule to focus your study on the skills measured.

    Most exam questions address the same aspects for any Azure Service How do I provision it? How do I manage it? (Using Azure Portal, Azure Cloud Shell, PowerShell, Azure CLI, ARM) How do I monitor it? (All roads lead to Azure Monitor) How do I secure it from outside access? (VNet, NSG, Private Endpoint) How do I grant access to the intended users? What are the relevant RBAC roles? How do I grant access to Azure AD Users, Groups, Identities? What are the pricing tiers (SKUs)? What features require choosing a more expensive SKU over a cheaper one? How do I scale it up and down? How do I make it highly available (HA) within the datacenter, in multiple availability zones, and in multiple regions?
  24. 1.IMAGINE. If you want to achieve the goal, you HAVE

    TO use your imagination to see yourself differently. Willpower alone won’t do it. Dr Benjamin Hardy - Future Self
  25. 2. COMMIT, then act every day Build your confidence with

    evidence Every action you take is a vote for the type of person you wish to become. No single instance will transform your beliefs, but as the votes build up, so does the evidence of your new identity. ― James Clear
  26. 3. Small habits, compounding results Success is the product of

    daily habits—not once-in-a-lifetime transformations. James Clear
  27. 4. Conquer fear with action It’s hard to fear a

    problem when you are making progress on it—even if progress is imperfect and slow. Action relieves anxiety. Working on a problem reduces the fear of it. James Clear
  28. 5. Deal with distractions, make focus time for learning Nir

    Eyal - Indistractable (Book) (Articles)
  29. 6. Continuous Improvement This is the secret sauce for success

    in the cloud. Each win builds confidence. Each quickstart, lab, tutorial, each passed exam, each small Azure project has built my confidence and enabled that next step. True long-term thinking is goal-less thinking. It’s not about any single accomplishment. It is about the cycle of endless refinement and continuous improvement. Ultimately, it is your commitment to the process that will determine your progress.” ― James Clear
  30. 8. Community Support Active participation in your user group community

    pays off! Knowledge, encouragement, support, accountability as we progress on our cloud journey Ask how you can help our local user groups like Data & AI Club!
  31. 9. Take Action Now What will you do today (and

    every day) for your career future? DM me on twitter
  32. Resources 1 Guides The Essential Guide to Data in the

    Cloud: A Handbook for DBAs Azure Whitepapers on SQL Microsoft training and certifications Cloud data services for database administrators Azure Study Map
  33. Resources 2 Articles Microsoft to help 25 million people gain

    digital skills Cloud Data Enginner Salaray - ZipRecruiter Books James Clean - Atomic Habits Nir Eyal - Indistractable
  34. Misconceptions & Reality MISCONCEPTION: Each exam is a whole new

    topic where I need to start at square one. REALITY: Thes exams overlap one another. The more exams you take, the less new material there is to learn. MISCONCEPTION: I must master all these new products and services to the same depth I have mastered SQL Server. REALITY: Mastery is NOT required. Only competency. Basic competency can be earned by investing 20-40 hours in a technology. Can choose mastery later when we decide our focus. Rapid change discounts the value of mastery, increases the value of rapid learning.