In this episode of Data Exposed with Tolga Tekin, learn about the ability to deploy Azure Arc Data services via Kubernetes to any hardware platform.

Time stamps:

  • [00:55] What is Azure Arc
  • [02:20] Azure data services anywhere at a glance
  • [03:28] On-premises vs Azure
  • [04:02] Azure Arc-enabled data services architecture
  • [06:07] Management capabilities comparison by deployment model
  • [08:22] Customer scenarios with Azure Arc
  • [09:53] Example – managing different infrastructures at different locations
  • [11:51] Getting started
Resources:

Linked servers enable the SQL Server and Azure SQL Database Managed Instance to read data from remote data sources and execute commands against the remote database servers.

In this video, Anna Thomas and Colin Murphy go over configuring linked servers in Azure SQL Database Managed Instance.

At the end, Anna briefly mentions creating a linked server to the readable secondary replica for read-heavy workloads.

In this episode with Drew Skwiers-Koballa, you will be introduced to a new experience for database development with the SQL Database Projects extension for Azure Data Studio. 

Whether you are familiar with SQL Server Data Tools (SSDT) or new to SQL projects, you can start editing and building SQL projects in Azure Data Studio on Windows, macOS, and Linux.

Related links:

Capacity planning plays a critical role in migrating an existing application or designing a new one. In the final part of this three-part series with Silvano Coriani, we’ll review various Azure SQL capacity planning scenarios, as well as review best practices and recommendations on what to use when. 

Time index:

  • 0:00 Introduction
  • 1:26 Greenfield development scenario
  • 5:42 Existing applications on-prem or other clouds scenario
  • 7:42 On-prem demo
  • 12:01 Changes in existing Azure SQL DB apps scenario

To provide customers with an easier network configuration, all newly created virtual clusters will be enabled for access over global virtual network peering connections, now in general availability.

This enables customers to pair managed instances in failover group configuration, in an easy and performant way, by simply connecting virtual networks in different regions. By utilizing global virtual network peering for your managed instances, you will save time through easy network configuration and offload your gateways from database replication traffic.

Review this new feature and more in this episode with Srdan Bozovic.

Time Index:

  • [00:42] Why Global VNet Peering Support is Important
  • [01:39] Auto-failover group connectivity architecture
  • [03:52] Take advantage of Global VNet Peering Support

Resources:

In the first part of this two-part series with Hamish Watson, we will look at the various methods available to deploy an Azure SQL database including PowerShell, Azure CLI and Terraform. Creating resources has never been easier or more standard than what we have now.

Related Links:

  • 0:00 Introduction
  • 1:55 A Match Made in the Cloud Overview
  • 4:42 Demo
  • 7:10 Other ways to deploy into Azure
  • 8:22 Continuation of demo
  • 8:56 CI CD Pipeline

In the conclusion to this two-part series with Allan Hirt, learn how Azure can be used to create disaster recovery solutions for your on premises Microsoft SQL Server instances and databases through the use of built-in availability features of SQL Server. 

Index:

  • 0:00 Introduction
  • 1:22 Built in hybrid disaster recovery options overview
  • 2:22 Hybrid Log Shipping
  • 4:27 Hybrid “Normal” Availability Group
  • 7:34 Hybrid Distributed Availability Group
  • 11:55 Hybrid Failover Cluster Instance

In this video,  Rohit Nayak and Ann Hoffman will cover the Deny Public Network Access setting for SQL Database.

Customers can use this setting to block all public access via firewall rules and exclusively rely on private endpoint connections.

Chapters:
  • [01:03] How to shut down public connectivity to my databases
  • [01:44] Deny public network access demo
  • [04:06] Private endpoint connections demo
Resources:

Containers are taking over, changing the way systems are developed and deployed.

Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, using containers! In this session, we’ll get your started on your container journey learning how to deploy SQL Server in Containers.

Resources:

About Anthony Nocentino:

Anthony is the Founder and President of Centino Systems as well as a Pluralsight Author and a Microsoft Data Platform MVP, Linux Expert, and Corporate Problem Solver. Anthony designs solutions, deploys the technology and provides expertise on business system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science with research publications in high performance/low latency data access algorithms and spatial database systems.