Microsoft continues to push the envelope on feature capabilities with every release of SQL Server. 

One of the more prominent features that was released with Microsoft SQL Server 2019 is the ability to resume or throttle certain index operations.

Have you ever want to just stop and then resume an index operation picking up where it left off?  Now you can! This feature alone magnifies the data professionals ability to have deeper granular control on how index operations affect their ecosystem as well as their work-life balance.  In this episode, John Morehouse gives a high-level look at how this feature works and how it can be applied seamlessly to your environment.

Resources:
Jupyter Notebooks are best known as tools for Data Scientists to display Python, Spark or R scripts. 
A Jupyter Notebook enables you to share words, images, code AND code results.  .NET interactive Jupyter notebooks add c sharp, F# and PowerShell core to the mix.
In this episode, Rob Sewell will introduce Jupyter Notebooks and show you how useful they could be for you in your daily work-life for Incident Resolution, Repeatable Tasks, and Demoing New Features.

Video index:

  • [01:04] Why use notebooks
  • [02:01] Demo
  • [04:15] Display notebooks in GitHub
  • [04:52] Get your own .NET Interactive notebook
  • [05:26] Edit .NET Interactive notebooks in Azure Data Studio
  • [07:37] SQL Instance Permissions
Resources:

One of the major benefits of Azure SQL Database is that the Azure platform provides additional protection for your database against SQL Injection attacks and Data Exfiltration, amongst other threats.

Join Joey D’Antoni as he shows you how to configure Advanced Threat Protection, and some of the protections it offers.

Video index:

  • [01:37] What is Advanced Threat Protection?
  • [02:46] Microsoft Azure Configuration
  • [03:36] Advanced Threat Protection types
  • [04:48] Enable auditing
  • [05:19] Tracking alerts

Continuing from part 1, learn why Azure SQL is the best database in the cloud for developers, dive deeper into architectures, and review customer case studies to truly understand how Azure SQL really shines. Click here to watch part one.

Video index:

  • [01:05] Data architectures applied with Azure SQL
  • [03:00] Hyperscale
  • [04:00] Demand analytics, forecasting, recommendation
  • [06:00] Easy setup
  • [07:15] Detection & security customer studies

Additional Resources:
JSON Samples
10 Reasons why Azure SQL is the Best Database for Developers
Big Red Cloud Case Study
Bing Ads Technical Blog Post
DevOps for Azure SQL Intro
Sync Mobile Apps with Azure Using Change Tracking API

Azure SQL has a lot of built-in features that make it the best database in the cloud for developers. In this first part of this two-part series, we’ll discuss what those features are and which kinds of customers can benefit most from them.

Video index:

  • [01:30] Why customers choose Azure SQL
  • [02:21] Security
  • [02:30] Scale-out
  • [03:15] Advanced analytical processing
  • [03:42] High-concurrency optimizations
  • [04:10] Development experience
  • [05:02] Geospatial support
  • [05:30] Multi-model capabilities
  • [07:00] Start-up example using Azure SQL
  • [08:38] Enterprise example using Azure SQL
  • [10:45] Web Applications

Additional Resources:
JSON Samples
10 Reasons why Azure SQL is the Best Database for Developers
Big Red Cloud Case Study
Bing Ads Technical Blog Post
DevOps for Azure SQL Intro
Sync Mobile Apps with Azure Using Change Tracking API

Join Ben Weissman and Anna Hoffman on a tour through the possibilities of Big Data Clusters (BDC).

He will give a brief overview about the general architecture and components of a BDC, followed by a demo where he will integrate data from external and internal sources using the same connection for python and T-SQL, and lastly come up with a real-world analytics scenario that will show you how easy it is to use them.

You may not even need petabytes of data to leverage what they have to offer!

Video index:

  • [01:30] It’s not your Grandpa’s SQL Server
  • [02:00] Big Data Clusters Architecture
  • [04:30] Big Data Clusters Real-World Example
  • [06:30] Demo in Azure Data Studio

In the second part of this two-part video series, Kate Smith discusses what two things you should understand before beginning with Azure SQL Database Elastic Jobs: Idempotence, and Credentials.

Content index:

  • [01:00] Intro to two fundamental concepts
  • [01:11] Idempotence
  • [01:50] Credentials
  • [03:43] Setting up Credentials
  • [05:42] The Refresh Credential
  • [07:15] The Job Credential

In this video, Emily Lisa and Anna Hoffman discuss how to make a database zone redundant in Azure SQL, and the High Availability benefits of the zone redundant configuration.

Content index:

  • [00:47] What is an availability zone?
  • [01:25] How does it relate to Azure SQL?
  • [02:14] Regions that support Availability Zones
  • [03:10] Demo to Enable Zone Redundant Configuration
  • [04:10] How it affects SLAs

In the second part of this two-part video segment, Rohit Nayak dives deeper into the new capabilities for Azure SQL Database for Private Endpoints.

Be sure to watch the first episode to understand what Private Endpoint for Azure SQL Database.

Time index:

  • [01:09] Set-up
  • [02:00] Demo: How to connect from Public IP Address to Private Endpoint
  • [08:36] Connecting Client VM to SQL Database with a Private Endpoint
  • [10:45] How to check your deployment succeeded
  • [14:08] Now that you created a Private IP Address, can you login to the IP Address itself?
  • [15:50] Double-checking on another machine
  • [16:30] 3 key takeaways