Microsoft Azure and other certification path for DBA

• ebooklub

  Hall of Fame

  Points: 3905

  More actions

  November 16, 2018 at 8:17 am

  #416497

  Hi, 
   few months ago  I started working with projects involving data migration to Azure cloud 

   A lot of time you have correctly present cloud idea to people who will be paying for it....
  by experience I found 

   1.If you communicate with MS directly you might get DEV environment for  low cost (it  is not 30 day trial)
   2. MS Azure pricing calculator is very basic (it like buying car)
   3. Be ready wait for 4 hrs for 400 GB db restore  to point in time  (DB will be restored then backup backup will be created , only then db become available ),  I suspect it could be faster if you choose different pricing plan
   4. You managed instance inside virtual network could be 'hacked' 
        I got an alert  "Azure Database: An unfamiliar principal successfully logged on to SQL server myserver01"
  Activity details
  Severity    Medium
  Subscription ID    ******
  Subscription name    Microsoft Azure
  Server    my-dev-database
  Database    msdb
  Resource type    SQL Managed Instance
  Principal name    DB*****
  IP address    ******
  Location    N/A, N/A
  Application    SQLAgent - Schedule Saver
  Date    November 14, 2018 23:28 UTC
  Potential causes    New user, unauthorized access, privilege abuse.
  Investigation steps    For a full investigation experience, Auditing should be enabled.
  Remediation steps    Revoke unnecessary permissions following the principle of ‘least privilege’.

  So I need to add  "SQL Database Threat Detection "  (https://azure.microsoft.com/en-ca/blog/azure-sql-database-threat-detection-general-availability-in-spring-2017/ )

  Question 
    To get more from Azure I want to pass certifications
    from you experience what is Azure certification path for DBA?