Azure Defender for SQL is now available on the SQL Virtual Machine blade.

Published Jul 27 2021 09:40 AM 3,697 Views

Running SQL Server on Azure VM comes with many benefits such as 

  • Lower the cost to run SQL Server on Azure with Azure-only pricing offers. 
  • Easily bring your SQL Server to the cloud and enjoy versatile and powerful virtual machines. 
  • Automatic security updates and simplified configuration management 

All the above features are powered by SQL Server IaaS Agent extension. SQL Server IaaS Agent extension (SqlIaasExtension) runs on SQL Server on Azure Virtual Machines (VMs) to automate management and administration tasks.  

 

As we work on adding more features to SQL Server IaaS Agent extension and SQL VM blade, we are more than excited to bring Azure Defender for SQL VM experience right from the SQL VM blade. Customers previously had to go through multiple steps to get to Azure Security Center to view and manage best practices of security for databases on SQL Server Virtual Machines. We made this experience easy for all customers who are registered to SQL IaaS Agent extension. Now you can access the entire Azure Defender suite from the same place you manage other SQL VM features such as automated backup, licensing, and security configurations like Azure Key Vault integration (learn more about the other benefits of running your SQL Server in an Azure Virtual Machine here). 

 

The prerequisite of enabling this feature at the subscription level remains the same ( How to set up Azure Defender for SQL | Microsoft Docs). 

 

Following is the experience in SQL Virtual machine blade, please note that there is a new Security tab and all the previous Security tab options are now available in Security Configuration. 

Aditya_Badramraju_0-1627401059035.png

 

 

You can learn more about Azure Security Center and how to use it here (How to set up Azure Defender for SQL | Microsoft Docs). 

%3CLINGO-SUB%20id%3D%22lingo-sub-2591879%22%20slang%3D%22en-US%22%3EAzure%20Defender%20for%20SQL%20is%20now%20available%20on%20the%20SQL%20Virtual%20Machine%20blade.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2591879%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3ERunning%20SQL%20Server%20on%20Azure%26nbsp%3BVM%20comes%26nbsp%3Bwith%26nbsp%3Bmany%20benefits%20such%20as%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%20data-leveltext%3D%22%251.%22%20data-font%3D%22Calibri%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%221%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ELower%20the%20cost%20to%20run%20SQL%20Server%20on%20Azure%20with%20Azure-only%20pricing%26nbsp%3Boffers.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CLI%20data-leveltext%3D%22%251.%22%20data-font%3D%22Calibri%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%222%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EEasily%20bring%20your%20SQL%20Server%20to%20the%20cloud%20and%20enjoy%20versatile%20and%20powerful%20virtual%26nbsp%3Bmachines.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CLI%20data-leveltext%3D%22%251.%22%20data-font%3D%22Calibri%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EAutomatic%20security%20updates%20and%20simplified%20configuration%20management%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CLI%20data-leveltext%3D%22%251.%22%20data-font%3D%22Calibri%22%20data-listid%3D%221%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%224%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EUtilize%20free%20HA%2FDR%20license%26nbsp%3Bbenefits%20with%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsql-server%2Foptimize-tco-with-new-sql-server-software-assurance-benefits-for%2Fba-p%2F1123731%22%20target%3D%22_blank%22%3EAzure%20Hybrid%20Benefit%3C%2FA%3E.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EAll%26nbsp%3Bthe%20above%20features%20are%26nbsp%3Bpowered%20by%26nbsp%3BSQL%20Server%20IaaS%20Agent%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eextension.%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3BSQL%20Server%20IaaS%20Agent%20extension%20(SqlIaasExtension)%20runs%20on%20SQL%20Server%20on%20Azure%20Virtual%20Machines%20(VMs)%20to%20automate%20management%20and%20administration%20tasks.%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAs%26nbsp%3Bwe%26nbsp%3Bwork%26nbsp%3Bon%20adding%20more%20features%20to%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fazure-sql%2Fvirtual-machines%2Fwindows%2Fsql-server-iaas-agent-extension-automate-management%3Ftabs%3Dazure-powershell%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ESQL%20Server%20IaaS%20Agent%20extension%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3Band%26nbsp%3BSQL%20VM%20blade%2C%20we%20are%20more%20than%20excited%20to%20bring%20Azure%20Defender%20for%20SQL%20VM%20experience%20right%20from%26nbsp%3Bthe%26nbsp%3BSQL%20VM%20blade.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3ECustomers%20previously%20had%20to%20go%20through%20multiple%26nbsp%3Bsteps%26nbsp%3Bto%20get%20to%26nbsp%3BAzure%26nbsp%3BSecurity%26nbsp%3BCenter%26nbsp%3Bto%20view%20and%20manage%26nbsp%3Bbest%20practices%20of%20security%20for%20databases%20on%20SQL%20Server%20Virtual%20Machines.%20We%20made%20this%20experience%20easy%20for%20all%20customers%20who%20are%20registered%20to%20SQL%20IaaS%26nbsp%3BAgent%26nbsp%3Bextension.%26nbsp%3BNow%20you%26nbsp%3Bcan%20access%26nbsp%3Bthe%26nbsp%3Bentire%26nbsp%3BAzure%26nbsp%3BDefender%20suite%20from%20the%20same%20place%26nbsp%3Byou%26nbsp%3Bmanage%20other%20SQL%20VM%20features%20such%20as%20automated%20backup%2C%20licensing%2C%20and%20security%20configurations%20like%20Azure%20Key%20Vault%20integration%26nbsp%3B(learn%20more%20about%20the%20other%20benefits%20of%20running%20your%20SQL%20Server%20in%20an%20Azure%20Virtual%20Machine%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsql-server%2Frehost-your-sql-server-to-azure-virtual-machines-for%2Fba-p%2F1698452%22%20target%3D%22_blank%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Ehere%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E).%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThe%20prerequisite%20of%26nbsp%3Benabling%20this%20feature%20at%20the%20subscription%20level%26nbsp%3Bremains%20the%20same%26nbsp%3B(%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsecurity-center%2Fdefender-for-sql-usage%23step-3-enable-the-optional-plan-in-security-centers-pricing-and-settings-page%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EHow%20to%20set%20up%20Azure%20Defender%20for%20SQL%20%7C%20Microsoft%20Docs%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E).%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EFollowing%20is%20the%20experience%26nbsp%3Bin%20SQL%20Virtual%20machine%20blade%2C%20please%20note%20that%20there%20is%20a%20new%26nbsp%3BSecurity%20tab%20and%20all%20the%20previous%26nbsp%3BSecurity%20tab%20options%20are%20now%20available%20in%20Security%20Configuration.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Aditya_Badramraju_0-1627401059035.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298713i34AD39B34E90A0AB%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Aditya_Badramraju_0-1627401059035.png%22%20alt%3D%22Aditya_Badramraju_0-1627401059035.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EYou%20can%20learn%20more%20about%26nbsp%3BAzure%20Security%26nbsp%3BCenter%20and%20how%20to%20use%20it%20here%20(%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsecurity-center%2Fdefender-for-sql-usage%23explore-and-investigate-security-alerts%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EHow%20to%20set%20up%20Azure%20Defender%20for%20SQL%20%7C%20Microsoft%20Docs%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E).%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2591879%22%20slang%3D%22en-US%22%3E%3CP%3ENow%2C%20customers%20can%20configure%20Azure%20defender%20for%20SQL%20Server%20on%20Azure%20Virtual%20Machines%20from%20SQL%20VM%20blade.%20This%20addresses%20the%20complexity%20of%20configuring%20the%20Security%20Center%20which%20used%20to%20take%20multiple%20steps.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2591879%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerAzureVM%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Jul 27 2021 09:38 AM
Updated by: