Hyperscale is a new tier for Azure SQL Database. In this video Anna Thomas and Jeroen ter Heerdt cover how to switch an existing Azure SQL Database to this new, scalable, tier. More information about Hyperscale: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tier-hyperscale. Note that for data warehousing some people are looking for MPP architectures rather than SMP. Hyperscale is based on SMP architecture. If you are looking for an MPP architecture database service, have a look at SQL Data Warehouse.

Overview of the new documentation on Azure SQL Database Machine Learning Services (Preview). More resources: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-quickstart-r-create-script and https://docs.microsoft.com/en-us/azure/sql-database/sql-database-tutorial-predictive-model-prepare-data.

This session does a deep dive into one of the network access controls for Sql Database i.e. setting up Vnet firewall rules to restrict access from a specific Vnet and subnet. Read more about Vnet Firewall Rules: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-vnet-service-endpoint-rule-overview.

The new centralized experience brings together SQL Server offerings inside of Azure, including databases, managed instances, and SQL VMs. We now have a centralized location for discovering, creating, and managing all of these resources as well as guidance to help you select and create the right resource for your needs.

This session explains the basics of how connectivity works for SQL Database and how you can use network access controls to securely access SQL Database. Note: At 7:33 during the video, it is said that "Allow Access to Azure services" restricts traffic to resources within the subscription - which is incorrect. Setting Allow access to Azure services button on the Portal (Firewall settings page) to ON shall allow traffic to/from resources ( e.g. Azure VM) or PaaS services( e.g. Web App) hosted inside Azure - within same subscription or from another subscription. Read more at the following links: Connectivity Architecture: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-architectureImpact of removing Allow Access to Azure Services: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-vnet-service-endpoint-rule-overview#impact-of-removing-allow-azure-services-to-access-serverIP Based Firewall: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configureVnet Firewall Rules: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-vnet-service-endpoint-rule-overview

When data is the lifeblood of your business, you want to ensure your databases are reliable, secure and available when called upon to perform. Service level agreements (SLA) set an expectation for uptime and performance and are a key input for designing systems to meet business needs. This conversation will help discuss the key SLA metrics and how you can leverage them for the most critical applications. For more information read this blog HERE.

In this demo, we will show how you can explode a Bill of Materials using Graph Shortest Path function, introduced with SQL Server 2019 CTP3.1, to find out which BOMs/assemblies a given product/part belongs to. This information can be useful for reporting or product recall scenarios. We will explore the Shortest Path function and try to understand different ways in which it can be used. More information: SQL Server Graph official documentation: https://docs.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-overview, https://docs.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-architecture and https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/20/graph-data-processing-with-sql-server-2017/Bulk Insert Best Practices: https://github.com/Microsoft/sql-server-samples/tree/master/samples/features/sql-graphRecommendation System: https://blogs.msdn.microsoft.com/sqlcat/2017/04/21/build-a-recommendation-system-with-the-support-for-graph-data-in-sql-server-2017-and-azure-sql-db/Product Recommendations in WideWorldImporters using SQL Graph: https://github.com/Microsoft/sql-server-samples/tree/master/samples/demos/sql-graph/recommendation-systemEdge Constraints: https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/09/28/public-preview-of-graph-edge-constraints-on-sql-server-2019/Using Derived Tables or Views in graph match: https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/11/07/public-preview-of-derived-tables-and-views-on-graph-tables-in-match-queries/, https://github.com/microsoft/sql-server-samples/tree/master/samples/features/sql-graph/DerivedTablesAndViewsInGraphMatchSHORTEST_PATH function: https://techcommunity.microsoft.com/t5/SQL-Server/Public-Preview-of-Shortest-Path-on-SQL-Server-2019/ba-p/721240, https://github.com/microsoft/sql-server-samples/tree/master/samples/features/sql-graph/ShortestPathAdvanced Graph Algorithms: https://github.com/shkale-msft/GraphRecursiveQueriesFollow Shreya Verma and Jeroen ter Heer

Learn how you can leverage our Data Migration Assistant tool to get the Azure SQL Database readiness at scale.More information: https://docs.microsoft.com/en-us/sql/dma/dma-assess-sql-data-estate-to-sqldb and https://docs.microsoft.com/en-us/sql/dma/dma-overview.

Understand the cloud migration journey, strategy, Leverage Data migration tools and Azure Database Migration Service for successful database migrations to Azure Data.More information:Database Migration Guide - Which provides a step-by-step guidance for any sort of Database migrations: https://datamigration.microsoft.com/.Azure Database Migration Service: https://docs.microsoft.com/en-us/azure/dms/.

In this episode we talk to Yatharth Gupta, Principal Program Manager for Azure Databricks, about the newly introduced integration with R Studio. For data scientists looking at scaling out R-based computing to big data, Azure Databricks provides the best way scale out their R models with Spark, that is easy to setup and integrates with the most popular R tools and frameworks. Data scientists can use Azure Databricks and R Studio to easily create analytics models, quickly access and prepare high quality data sets, and automatically run R workloads at unprecedented scale. Create a Free Account (Azure): https://aka.ms/azft-sql