Tag: Azure SQL

Azure Arc enabled Data services video series

Azure Arc enabled Data services video series

With Azure Arc we are not just allowing you to use the Azure control plane to manage resources like servers and Kubernetes clusters outside for Azure, we are also bringing Azure services to the customer hybrid locations on-premises, at the edge, or even other cloud providers. In a video series, I had the chance to talk with Travis Wright (Principal Group Engineering Manager at Microsoft) and Dhananjay Mahajan (Principal Program Manager at Microsoft) about Azure arc enabled data services.

What are Azure Arc-enabled data services?

Azure Arc makes it possible to run Azure data services on-premises, at the edge, and in public clouds using Kubernetes and the infrastructure of your choice. Currently, the following Azure Arc-enabled data services are available:

  • SQL Managed Instance
  • PostgreSQL Hyperscale (preview)

You can learn more about Azure Arc-enabled data services on Microsoft Docs.

Azure Arc-enabled SQL Managed Instance

Azure Arc-enabled SQL Managed Instance has near 100% compatibility with the latest SQL Server database engine, and enables existing SQL Server customers to lift and shift their applications to Azure Arc data services with minimal application and database changes while maintaining data sovereignty. At the same time, SQL Managed Instance includes built-in management capabilities that drastically reduce management overhead.

You can learn more about Azure Arc-enabled SQL Managed Instance on Microsoft Docs.

Choose the right data solution for your hybrid environment

Learn how to understand your hybrid environment and set up the right solution for success. This session covers use cases for Azure Arc – enabled data services in both connected and disconnected scenarios.

Azure Arc – enabled data services in connected mode

Get an overview of the end-to-end experience for deploying Azure Arc – enabled data services in connected mode. This session also covers aspects like high availability, scalability, and monitoring.

Azure Arc – enabled data services in disconnected mode

In this session, you’ll explore the end-to-end experience of deploying Azure Arc – enabled data services in disconnected mode. You’ll also learn about the tools available for managing and monitoring your local environment.

Azure Arc – enabled data services with Azure Stack HCI and Azure Kubernetes Service (AKS)

Explore the comprehensive Azure hybrid solution and how Azure Arc – enabled data services run on top of Azure Stack HCI and AKS.

Learn more:

I hope the Azure Arc enabled Data Services video series was helpful. If you have any questions, feel free to leave a comment below.



Azure Hybrid Cloud Deep Dive Sessions

Azure Hybrid Cloud Deep Dive Sessions

As mentioned before, our team created a virtual free event called ITOps Talks – All Things Hybrid.  ITOps Talks – All Things Hybrid is an initiative of our Cloud Advocacy AzOps team, to bring you Azure Hybrid Cloud deep dive sessions from your favorite speakers and program managers at Microsoft. You can learn directly from the people behind the products how you can make your on-premises environment better using build-in technologies in Windows Server, Microsoft Azure, and many more! ☁

I am happy to let you know that the Azure Hybrid Cloud deep dive sessions from our ITOps Talks All Things Hybrid event are now available! You can find the full list of sessions from our team here on YouTube. 📺

I had the chance to work with some top Program Managers within Microsoft, to create some Hybrid Cloud deep-dive sessions. So I am happy to share my list of sessions directly embedded here for you. ⚡

OPS109 – Getting started with Azure Kubernetes Service (AKS) on Azure Stack HCI

with Matt McSpirit (@mattmcspirit) – Senior Program Manager

In this session, you’ll learn about the new Azure Kubernetes Service on Azure Stack HCI, how you can use it to run your containerized Windows and Linux apps, how it integrates with Azure, and how it provides the best platform to run additional Azure services, including Arc-enabled Data Services. This will help you to modernize your existing applications on our Azure Stack HCI Hybrid Cloud Platform.

This session includes:

0:00 Introduction
2:00 Azure Hybrid Overview
5:10 Kubernetes on Azure
8:39 What is Azure Kubernetes Service (AKS) on Azure Stack HCI
15:34 High-Level Architecture
18:51 Architecture AKS-HCI Components
21:21 Demo: Deployment
33:19 Demo: Deploy Worker Nodes
43:41 Demo: Deploy an Application
59:27 How to evaluate the new AKS on Azure Stack HCI
1:00:58 Wrap up

Learn More

OPS111 – Learn the 5 key areas to consider for your hybrid workloads

with David Kurth (@TheDaveKurth) – Senior Product Marketing Manager

In this whiteboard session (after a few slides for context), we will discuss the 5 key areas of any hybrid cloud workload, connectivity, application, data, identity, security & management.

This session includes:

0:00 Introduction
0:55 About Dave
3:56 Why Hybrid
11:38 Azure Hybrid Overview
19:08 Whiteboard Session Hybrid areas
30:15 Wrap up

Learn More

OPS112 – Azure Stack HCI Hybrid is built-in: How does it really work?

with Kerim Hanif (@kerimhanif) – Senior Program Manager

Ready to deploy Azure Stack HCI, the new hyperconverged infrastructure operating system delivered as an Azure service? Join this session to learn everything you need to know about how Azure Stack HCI’s hybrid connectivity works. Is it hard to register? (Hint: no.) Is there an agent? (Hint: no.) Does Azure see my VMs and their data? (Hint: no.) Do I need to open my firewall to freely allow Internet traffic? (Hint: no.) All these answers and more.

This session includes:

0:00 Introduction
1:50 What is Azure Stack HCI?
5:55 Azure Stack HCI as a Hybrid services
8:30 Native OS-level integration with Azure
11:20 Demo: Azure Stack HCI
14:10 Registering with Azure
20:19 Demo: How to register
25:21 What happens in the background in Azure?
37:06 Azure Stack HCI Connectivity requirements
44:00 Data privacy
49:36 How can I see the diagnostic data myself?
51:39 Just the foundation more to come!
58:10 Wrap Up

Learn More

OPS113 – From WS2008 to Azure with containers – An Ops view on how to modernize existing applications with Windows Admin Center

with Vinicius Apolinario (@vrapolinario) – Senior Program Manager

ITPros around the globe are trying to figure out how to modernize existing applications. End of Support for Windows Server 2008, how to move applications to the cloud, and how to leverage new technologies such as Kubernetes have become a daunting process for Ops teams. In this session, we will cover how to containerize existing applications from the perspective of an ITPro. We will use tools that you are used to – such as Windows Admin Center to jumpstart your modernization process and show how to move an application from Windows Server 2008 to Azure Kubernetes Service.

This session includes:

0:00 Introduction
3:33 What are containers?
5:35 Windows Server 2008 and 2008 R2 End of Life
9:56 The benefits of using containers
17:25 Demo: IIS Application to be containerized
24:14 Demo: Windows Admin Center Container Management
29:50 Demo: Create a Container Image using Windows Admin Center
36:40 Demo: Run Container Image on Windows Server Container Host
41:25 Demo: Push Container Image to Container Registry (ACR)
47:01 Demo: Create Azure Kubernetes Service Cluster
52:37 Demo: Deploy Container to AKS cluster
59:15 Wrap Up

Learn More

OPS114 – Governing baselines such as STIG in hybrid server environments using Azure Policy Guest Configuration

with Michael Greene (@migreene) – Principal Program Manager

Learn to use services in Azure to audit the state of servers across private and public clouds and upcoming plans to expand capabilities in this area.

This session includes:

0:00 Introduction
3:40 Providing Feedback and Community
5:10 Hybrid solution using Azure Arc
8:30 Demo using Azure Policy Guest Configuration
18:39 Demo How to set up Azure Policy Guest Configuration for Azure Arc machines
23:19 Azure Arc enabled servers
27:33 What is next for Azure Policy Guest Configuration
31:13 Wrap up

Learn More

OPS119 – Databases are cattle too! Running highly available databases consistently on any infrastructure using Arc data services

with Travis Wright (@radtravis) – Principal Group Program Manager

Have you heard people say ‘containers or Kubernetes is not for databases’? Let me show you how that is definitely not the case in 2021. Kubernetes provides an abstraction layer over any infrastructure and an orchestration engine that powers Arc enabled data services so DevOps, DBAs, and developers can provision and manage highly available SQL and PostgreSQL database instances on any infrastructure – on-prem, AWS, or Google. In this session, I’ll dive deep into the technical weeds with nearly 100% demos that show you exactly how it all works and you can manage it all with GUI, CLI, Azure-native tools, or Kubernetes-native tools.

This session includes:

0:00 Introduction
0:45 Databases are cattle
3:36 Are databases cattle or pets?
06:41 Database cow wannabes
07:47 Database cows
11:12 Traditional Always On
11:50 Azure SQL
12:18 Azure Arc enabled data services
17:35 Built-In, Automated High Availability
18:03 Standard HA
19:46 Premium HA
21:38 Demo: Databases are cattle too!
47:48 Wrap Up

Learn More

OPS121 – Modernize how you manage hybrid servers with Azure Arc

with Ryan Puffer – Senior Program Manager

Think the cloud is just for things that are…in the cloud? Come learn how you can use Azure Arc to simplify IT operations across your entire fleet, no matter where your servers run. We’ll start with a deep dive into the architecture and benefits of Azure Arc followed by a demonstration of how Azure Arc can help you monitor, secure, and simplify the management of a multi-tier on-premises application.

This session includes:

0:00 Introduction
1:25 Agenda
2:25 What is Azure Arc
4:18 Azure and Azure Arc Architecture
12:58 Demo: Management of Azure VMs
14:39 Azure Arc enabled servers architecture
25:01 Demo: Extensions
26:46 Demo: Azure Arc enabled server and how to add a server
33:51 Demo: How to manage an Azure Arc enabled server
49:49 Demo: Update Management
59:44 Demo: Access Control and RBAC
1:01:28 Demo: Azure Monitoring for hybrid servers
1:06:38 Wrap Up

Learn More

ITOps Talks – Azure Hybrid Cloud Deep Dive sessions

I hope you will enjoy these Azure Hybrid Cloud Deep Dive sessions. If you have any questions, feel free to leave a comment or ping us with a tweet using the #AzOps hashtag on Twitter. I hope you will enjoy ITOps Talks All Things Hybrid!



DP-300 Exam Study Guide Microsoft Azure Database Administrator

DP-300 Study Guide Azure Database Administrator

I am currently preparing for the new Microsoft exam DP-300 Administering Relational Databases on Microsoft Azure. That is why I want to share my new updated DP-300 Microsoft Azure Database Administrator Certification Exam Study Guide with you.  If you are passing the DP-300 exam, you will earn the Microsoft Certified Azure Database Administrator Associate certification, which you understand how to implement and manage the operational aspects of cloud-native and hybrid data platform solutions built with Microsoft SQL Server and Microsoft Azure Data Services. The Azure Database Administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.

To learn and prepare for the exam, I usually use a couple of online resources, mainly Microsoft Docs and Microsoft Learn, which I am going to share with you. You can find more information about how I prepare for a Microsoft Certification exam on my blog post: How to prepare and pass Microsoft Certification Exam.

Also, check out other Microsoft Azure Certification Exam Study Guides:

Here is my DP-300 Azure Database Administrator Associate Certification Exam Study Guide

It is essential to get familiar with the exam objectives and skills measured first. That is why I recommend reading the description of the exam and the skills measured.

Exam DP-300 Administering Relational Databases on Microsoft Azure

Candidates for this exam are database administrators and data management specialists that manage on-premises and cloud relational databases built with Microsoft SQL Server and Microsoft Azure Data Services.

The Azure Database Administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on Azure Data Services and SQL Server. The Azure Database Administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.

This role is responsible for management, availability, security and performance monitoring and optimization of modern relational database solutions. This role works with the Azure Data Engineer role to manage operational aspects of data platform solutions.

The high-level view of the skills measured in the exam:

  • Plan and implement data platform resources (15-20%)
  • Implement a secure environment (15-20%)
  • Monitor and optimize operational resources (15-20%)
  • Optimize query performance (5-10%)
  • Perform automation of tasks (10-15%)
  • Plan and implement a High Availability and Disaster Recovery (HADR) environment (15-20%)
  • Perform administration by using T-SQL (10-15%)

You can find more information on the exam website.

Free Online Microsoft Learn DP-300 Exam Study Guide resources

Microsoft Learn provides you with free online training and learning paths for different Microsoft technologies. They not just offer reading material, but also control questions and free online labs. Here are some relevant Microsoft Learn modules and learning paths for the DP-300 Administering Relational Databases on Microsoft Azure Certification Exam. Microsoft Learn is an important part of my DP-300 Azure Database Administrator exam study guide.

The team also just made it easier to prepare with the new DP-300 related learning paths on Microsoft Learn. I highly recommend that you take these for your DP-300 exam preparation.

Microsoft Docs DP-300 Azure Database Administrator study guide resources

One thing I always used to prepare for my Microsoft exams is Microsoft Docs. Here are the relevant Microsoft Docs which I used to prepare and study for the DP-300 exam.



Azure Arc enabled SQL Server

Azure Arc enabled SQL Server Preview is now available

As you know, I do a lot of work on Hybrid Cloud topics like Azure Arc, which allows you to extend Azure management and Azure services to any infrastructure. I talk a lot about how you can use Microsoft Azure to manage your servers running on-premises or at other cloud providers, or how you can connect and manage Kubernetes clusters. The Azure Data services team at Microsoft Ignite 2019 also announced the private preview of Azure Arc Data services, which allow you to deploy services like Azure SQL on any infrastructure. This week they had another news to share, and it is the private preview of Azure Arc enabled SQL Server. With Azure Arc enabled SQL Server, you can use the Azure Portal to register and track the inventory of your SQL Server instances across on-premises, edge sites, and multi-cloud in a single view. You can also take advantage of Azure security services, such as Azure Security Center and Azure Sentinel.

Onboarding SQL Server to Azure Arc

Onboarding SQL Server to Azure Arc

The preview of Azure Arc enabled SQL Server Preview includes the following features:

  • Use the Azure Portal to register and track the inventory of your SQL Server instances across on-premises, edge sites, and multi-cloud in a single view.
  • Use Azure Security Center to produce a comprehensive report of vulnerabilities in SQL Servers and get advanced, real-time security alerts for threats to SQL Servers and the OS.
  • Investigate threats in SQL Servers using Azure Sentinel.

Azure Security Center assessment of on-premises SQL Server

Azure Security Center assessment of on-premises SQL Server

You can register any Windows or Linux based SQL Server to track your inventory. Azure Security Center’s advanced data security works on Windows-based SQL Server version 2012 or higher, running on physical or virtual machines and hosted on any infrastructure outside of Azure.

If you are interested in participating in this preview, check out the official blog post. If you have any questions, feel free to leave a comment.