patternsqlMinor
Equivalent to Azure SQL Threat Detection for on-premise database
Viewed 0 times
equivalentsqlthreatdatabaseazurefordetectionpremise
Problem
Due to GDPR, we are seeking a way to help identify malicious activity or data breaches from our production SQL Server.
It seems if we were using Azure, this is a flick of a switch.
What is available for on-premise servers?
It seems if we were using Azure, this is a flick of a switch.
What is available for on-premise servers?
Solution
Azure Security Center already monitors the security posture of non-Azure computers by on boarding VMs and computers running on-premises by simply installing the Microsoft Monitoring Agent on these machines.
Currently this offering includes OS Advanced Threat Detection using behavioral analytics and machine learning to identify attacks and zero-day exploits on the Windows Operation System layer. As part of our road-map we plan to add SQL Advanced Threat Detection, which will detect anomalous database activities indicating unusual and potentially harmful attempts to breach or exploit SQL severs.
Azure Security Center's advanced data security in public preview for SQL machines protects SQL servers hosted in Azure,in on-premises machines or in other cloud environments, and even on-premises machines. This extends the protections for your Azure-native SQL Servers to fully support hybrid environments.
This preview feature includes functionality for identifying and mitigating potential database vulnerabilities and detecting anomalous activities that could indicate threats to your SQL Server.
Azure Defender for SQL is now generally available for use with SQL Server on premises, in multicloud deployments on Amazon Web Services (AWS), and Google Cloud Platform (GCP), and in virtual machines on Azure. Azure Defender for SQL constantly monitors your SQL Server for known vulnerabilities and threats. Microsoft recommends that customers protect their production instances of SQL with Azure Defender for SQL as part of their overall security strategy.
https://www.microsoft.com/security/blog/2020/12/02/protect-your-sql-server-on-premises-in-azure-and-in-multi-cloud/
Currently this offering includes OS Advanced Threat Detection using behavioral analytics and machine learning to identify attacks and zero-day exploits on the Windows Operation System layer. As part of our road-map we plan to add SQL Advanced Threat Detection, which will detect anomalous database activities indicating unusual and potentially harmful attempts to breach or exploit SQL severs.
Azure Security Center's advanced data security in public preview for SQL machines protects SQL servers hosted in Azure,in on-premises machines or in other cloud environments, and even on-premises machines. This extends the protections for your Azure-native SQL Servers to fully support hybrid environments.
This preview feature includes functionality for identifying and mitigating potential database vulnerabilities and detecting anomalous activities that could indicate threats to your SQL Server.
Azure Defender for SQL is now generally available for use with SQL Server on premises, in multicloud deployments on Amazon Web Services (AWS), and Google Cloud Platform (GCP), and in virtual machines on Azure. Azure Defender for SQL constantly monitors your SQL Server for known vulnerabilities and threats. Microsoft recommends that customers protect their production instances of SQL with Azure Defender for SQL as part of their overall security strategy.
https://www.microsoft.com/security/blog/2020/12/02/protect-your-sql-server-on-premises-in-azure-and-in-multi-cloud/
Context
StackExchange Database Administrators Q#196804, answer score: 7
Revisions (0)
No revisions yet.