Managed Identities for Azure Resources can be leveraged to provide applications running on Azure Services with password-free access to Azure SQL databases and simplifying aspects like credential rotation and secrets management. In this episode of Data Exposed with Silvano Coriani, we’ll look at how it works and will see it in action

Resources:

The Basic, Standard, and Premium service tiers fulfill a lot of customers’ needs.

For some customers, though, the General Purpose, Business Critical, and Hyperscale service tiers offer additional performance and ability that is required for certain workloads.

Even if you don’t require those abilities, the technology and infrastructure behind these are worth learning.

In this episode with Matt Gordon, we’ll discuss those service tiers as well as discussing the differences between Provisioned and Serverless deployments on the General Purpose tier. Come learn how to ramp up your Azure SQL Database experience!

Resources:

In this episode of Data Exposed with Sasha Nosov, learn how Azure Arc allows you to leverage Azure Services for your existing database applications hosted on-premises or in other public clouds, without changing or even stopping them.

Content & Time Stamps:

  • 0:00 Introduction
  • 0:45 What is Azure Arc
  • 2:30 About Azure Arc Enabled SQL Server
  • 3:03 Architecture of Azure Arc Enabled SQL Server (Public Preview)
  • 8:09 Environment Health Demo
  • 13:18 Azure Arc Enabled Data Services vs Azure Arc Enabled SQL Server
  • 17:00 What versions of SQL Server are supported
  • 17:45 Getting started & registering for Azure Arc enabled SQL Server

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.

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.

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:

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

In the first part of this two-part video segment, Rohit Nayak explains what Private Endpoint for Azure SQL Database is and how it relates to the overall connectivity story for Azure SQL.

You can learn more about Private Link in Azure SQL Database here https://docs.microsoft.com/en-us/azure/sql-database/sql-database-private-endpoint-overview?WT.mc_id=dataexposed-c9-niner , and Private Link generally for Azure here https://docs.microsoft.com/en-us/azure/private-link/private-endpoint-overview?WT.mc_id=dataexposed-c9-niner.

At the beginning, Rohit mentions a playlist with other videos you should review to get more background on the topic. You can see the playlist here: https://www.youtube.com/playlist?list=PL3EZ3A8mHh0xtbf4Cr2yR4-xsUtELwPjw?WT.mc_id=dataexposed-c9-niner

Time Index

  • [00:46] Connectivity architecture for public endpoint
  • [01:46] Private Link overview
  • [03:55] Why Private Link?
  • [05:08] How does Private Endpoint work?
  • [06:55] Client connectivity scenarios to Private Endpoint
  • [09:05] Summary and what’s next

Are you looking to gain more control of the costs of operating your growing Azure HDInsight clusters?

Are you interested in driving higher utilization of your Azure HDInsight clusters?

If yes, then you should definitely watch this video to learn about how to leverage Azure HDInsight Autoscale feature to help you achieve higher cost efficiency.

Time Index:

  • [00:33] Introduction
  • [01:00] Customer challenge
  • [01:55] Static clusters
  • [03:40] Solution is HDInsightAutoscale
  • [06:00] Demo of deployment
  • [09:05] Demo of load-balanced scaling
  • [10:00] Demo of scheduled scaling
  • [11:20] Validating cluster size

In this video, Anna Hoffman and Jeroen ter Heerdt discuss and show PowerShell notebooks and Azure SQL inside Azure Data Studio. Learn how you can leverage PowerShell notebooks and other CLI tools in them to manage your Azure SQL Databases and Managed Instances.

Time index:

  • [00:00] Intro
  • [00:32] Notebooks in Azure Data Studio
  • [01:20] PowerShell kernel for notebooks
  • [02:20] Setting up Azure (Az) module for PowerShell in your notebook
  • [03:17] Running interactive commands in the integrated terminal in Azure Data Studio
  • [04:21] Resources
  • [04:53] Wrap-up

More Data Exposed videos:

https://www.youtube.com/playlist?list=PLlrxD0HtieHieV7Jls72yFPSKyGqycbZR&WT.mc_id=dataexposed-c9-niner