Threat Detection in Azure SQL Database Hits GA

Threat Detection is now generally available in Azure SQL Database. Video how DSVM in Microsoft Azure enables key end-to-end data analytics scenarios. Power BI Desktop May feature release.

Share online:

Threat Detection leverages machine learning to provide an additional layer of security built into the SQL Database service, enabling SQL Database customers to protect their databases within minutes without needing to be an expert in database security—is now generally available in Azure SQL Database, too.

It works around the clock to profile and alert of anomalous activities on your databases, including potential vulnerabilities and SQL injection attacks, as well as anomalous database access patterns. Security officers or other designated administrators get email notification once a threat is detected on the database.

Threat detection alerts can also be viewed from Azure Security Center and provide details of suspicious activity and recommend action on how to investigate and mitigate the threat.

Microsoft's Data Science Virtual Machine (DSVM) is a family of popular VM images in Windows Server & Linux flavors that are published on the Microsoft Azure Marketplace. In a recent webinar, Microsoft highlight some of the most popular end-to-end scenarios enabled by DSVM, and to demonstrate a few of these scenarios in detail.

The webinar also covered the DSVM roadmap, watch the video below:

Scenarios covered in the webinar include:

  • Using SQL Server R Services, for the Dev>Train>Test>Deploy>Score cycle.
  • Using the Local Spark 2.0 instance on the DSVM for Dev & Test.
  • Training and Deploying Deep Learning Models on GPU based Azure VMs. This features the Deep Learning Toolkit for DSVM.
  • Querying and wrangling across platforms, featuring Apache Drill and Microsoft Power BI.

In addition, in May update to Power BI Desktop, the features,including an upgrade to tables to add new matrix, two new quick measures, and a new way to create bins are released.

Additionally, you'll be able to take advantage of a new slicer type that filter reports down to relative dates, such as last 3 months.

Here's the complete list of Desktop May updates:

Report view

  • Relative date slicer (preview)
  • New table visual (preview)
  • Combo chart data label enhancements
  • More URL support in table & matrix
  • Mailto links in textbox

Analytics

  • Report level measures for live connections to Analysis Services tabular models & Power BI service datasets
  • 2 new quick measures (preview): Total for category & Rolling average
  • Bin by count

Data connectivity

  • New connector: Dynamics 365 for Customer Insights
  • Combine files – ability to reference "First File" as example

Query editing

  • Two new transforms:
    • Extract text before/after/between delimiters
    • Unpivot only selected columns

For a summary of the updates, watch the following video: