How to create Azure SQL Database and Parameters

Saturday , 10, June 2023 dfirst Microsoft Azure

Azure SQL Database is one of the most popular Relational Database Management System provided by Microsoft Azure. Azure SQL Database is Platform as a service for relational database management system. Users create Azure resources by Database. Azure SQL Database has high scalability and elastic options and it can be deployed quickly when users want to use. Basically, users manage database layer.

 

Demo for creating Azure SQL Database

Parameters

  • Basic
    • Project details
      • Subscription
      • Resource group
    • Database details
      • Database name
        • Specify SQL Database name.
      • Server
        • Need to create new Server, If Server has not been created.
      • Want to use SQL elastic pool ?
        • Select "Yes" or "No".
        • if "Yes", need to select an elastic pool.
      • Workload environment
        • Select "Development" or "Production".
      • Compute + storage
        • Select "Service tier"
          • vCore-based purchasing model
            • General Purpose (Scalable compute and storage options)
            • Hyperscale (On-demand scalable storage)
            • Business Critical (High transaction rate and high resiliency)
          • DTU-based purchasing model
            • Basic (For less demanding workloads)
            • Standard (For workloads with typical performance requirements)
            • Premium (For IO-intensive workloads)



    • Backup storage redundancy
      • Backup storage redundancy
        • Choose how your PITR (Point in time recovery) and LTR (Long-term-retention) backups are replicated.
          • Locally-redundant backup storage
          • Zone-redundant backup storage
          • Geo-redundant backup storage

             

  • Networking
    • Network Connectivity
      • Connectivity method
        • Select "Connectivity method" from options below.
          • No access
          • Public endpoint
          • Private endpoint
    • Firewall rules
      • Allow Azure services and resources to access this server
        • If "Public endpoint" has been selected, select "Yes" or "No".
      • Add current client IP address
        • If "Public endpoint" has been selected, specify IP address allowed to access this server.
    • Private endpoints
      • Only if "Public endpoint" has been selected.
      • If needed, specify Private endpoint connections are associated with a private IP address within a Virtual Network.
    • Connection policy
      • Connection policy
        • Select from options below.
          • Default - Uses Redirect policy for all client connections originating inside of Azure and Proxy for all client connections originating outside Azure
          • Proxy - All connections are proxied via the Azure SQL Database gateways
          • Redirect - Clients establish connections directly to the node hosting the database
    • Encrypted connections
      • Minimum TLS version
        • Default value is TLS 1.2

 

  • Security
    • Microsoft Defender for SQL
      • Enable Microsoft Defender for SQL
        • Select "Start free trial" or "Not now".
    • Ledger
      • Ledger
        • If needed, configure ledger.
    • Identity
      • If needed, create "User assigned managed identity". (Preview as of Aug 2022)
    • Transparent data encryption
      • If needed, set "Transparent data encryption" options.

 

  • Additional Settings
    • Data source
      • Use existing data
        • Specify data source for this database.
          • None
          • Backup
          • Sample
    • Database collation
      • Collation
        • Specify a database collation for this database.
          • CI (Case Insensitive)
          • CS (Case Sensitive)
          • AI (Accent Insensitive)
          • AS (Accent Sensitive)
          • KS (Kana Sensitive)
          • WS (Width Sensitive)
          • BIN (Binary)
    • Maintenance window
      • Select "Maintenance window".