Azure VM Security Considerations

By Ashwin Venugopal -

 


Azure VM Security 

If you want to encrypt Azure VM disks, you can use Azure Disk Encryption which uses the BitLocker feature of Windows and DM-Script for Linux to provide volume encryption for the operating system as well as data disks. This solution also works with Azure Key Vault which in turn helps you to control as well as manage the disk encryption keys and secrets. However, it is recommended to use SAP HANA native encryption technology for SAP HANA data-at-rest encryption. 

Note- You should not use the HANA data-at-rest encryption with Azure Disk encryption on the same server, instead use only HANA data encryption for HANA.

SQL Server Transparent Data Encryption (TDE)

The SQL server TDE functionality is fully supported by SAP.

Applying SQL Server TDE

If you want to perform a heterogeneous migration from another DBMS, running on-premise, to Windows/SQL Server running in Azure, you can create your empty target database in SQL server before time. After that, you can easily apply SQL server TDE functionality, while you are still running your production system on-premise. You have to do it this way because the process of encrypting the empty database can take some time.

If you want to move SAP SQL Server databases from on-premises into Azure, then it is recommended to test that on which infrastructure you can get the encryption applied fastest by considering the following points;

  • You can't define how many threads are used to apply data encryption to the database as the number of threads mainly depends on the number of disk volumes the SQL server data and log files are distributed over i.e. the more distinct volumes, the more threads will be engaged in parallel to perform the encryption. A configuration with smaller number of volumes will lead to a small number of threads executing the encryption which results in the moderate load on the transaction log.

  • In older SQL server releases, backup compressio9n did not get efficiency anymore when you encrypted your SQL Server database. This behavior could develop into an issue when your plan was to encrypt your SQL Server database on-premises and then copy a backup into Azure to restore your data in it. Server backup compression usually achieves a compression ratio of factor 4.

  • SQL server introduced anew functionality with the SQL Server 2016 that allows compressing SQL databases also in an efficient manner.

  • If you treat the application of TDE encryption with no to little SAP workload only, then you have to test in your specific configuration if it is better to apply TDE to your SAP database on-premises or to do so in Azure which certainly offers more flexibility in terms of over-provisioning infrastructure and shrink the infrastructure after TDE got applied. 

Using Azure Key Vault

Azure generally offers a service of Key Vault to store encryption keys, while SQL Server offers a connector to leverage Azure Key Vault as store for the TDE certificates.









Comments

Post a Comment

Popular posts from this blog

Deployment (Part 3)

By Ashwin Venugopal -
Image
  To read part 1, please click  here To read part 2, please click  here Microsoft Monitoring Agent (MMA) MMA is used across multiple Microsoft solutions and has undergone a few name changes as its features and functionality have evolved. If it is being considered to be used, then following areas should be covered during a Microsoft Sentinel deployment project: Consider the timelines and the strategy for a migration to AMA (Azure Monitor Agent) before the MMA end-of-life.  Consider the central deployment and management methodology for MMA. Determine which endpoints are in scope for deployment as these affect the log ingestion volume significantly.  Azure Monitor Agent (AMA) Organizations with MMA as the main Microsoft Sentinel agent should start planning the migration to AMA as soon as possible to avoid a rushed migration. One of the main advantages of AMA is the ability to control the log collection policy centrally and apply different policies against different...
Read more

Deployment (Part 1)

By Ashwin Venugopal -
Image
  To read part 2, please click  here To read part 3, please click  here Azure Resources Microsoft Sentinel needs following resources to be created: Subscription (if a dedicated subscription(s) will be used) Resource group(s) Log Analytics workspace(s) Automation rules/playbook Alert rules Workbooks Microsoft Sentinel offers hundreds of alert rules, workbooks, and automation playbook templates along with hunting scripts. The templates can be used to activate/deploy schedule alerts, create customized dashboards, create automation playbooks and perform threat-hunting activities. Generally, once deployed, the resources created have to be adjusted to match the existing environment, configure local credentials, etc. Methods of deployment: Manual- Administrator can manually configures the Microsoft Sentinel resources with the help of Azure portal. Any manual process has the inherent risks of human operator error, lack of compliance with potential change control procedures, and u...
Read more

Project Resourcing (Part 2)

By Ashwin Venugopal -
Image
  To read part 1, please click  here Engineering - SIEM The SIEM engineers configures Microsoft Sentinel, including Log Analytics, Logic Apps, workbooks, and playbooks. They are also responsible for the following high-level tasks: Initial configuration of Azure tenant, including provisioning required resources, assigning access roles, and configuring workspace parameters like log retention, resource tagging, and blueprints.  Deployment and configuration of syslog/CEF log collection agents in appropriate locations to collect logs from on-premises devices. Generally, it will be joint effort of both system engineer and SIEM engineer, involving configuration and potential troubleshooting.  Working with system owners to enable log forwarding and configuring any required parsing of log data in Log Analytics.  Working with security operations to create and deploy KQL analytic rules to offer detections for SOC/Computer Security Incident Response Team (CSRIT) use. Tuning...
Read more