Chapter 10

Database Features

Learning Objectives

By the end of this lesson, you will be able to:

  • Implement SQL Data Sync to sync an Azure SQL database with an on-premises database
  • Use SQL graph queries create and query graph tables
  • Implement SQL graph enhancements
  • Create a model to predict future sales using the Azure Machine Learning service

This lesson talks about improving performance using in-memory technologies, online and resumable DDL operations and also talks about SQL Graph queries and improvements.

This lesson also covers the machine learning feature to execute in-database R scripts.


This lesson talks about the important database features available in an Azure SQL database. The lesson talks about SQL Data Sync ...

Get Professional Azure SQL Database Administration - Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.