Managing Azure SQL Server Database Performance

Managing and tuning SQL database performance requires expertise and can be time-consuming. This course will explain to you how you can leverage Azure services and features to perform these tasks in a smooth, effortless, and easy way.
Course info
Rating
(27)
Level
Advanced
Updated
Dec 11, 2019
Duration
1h 31m
Table of contents
Description
Course info
Rating
(27)
Level
Advanced
Updated
Dec 11, 2019
Duration
1h 31m
Description

When we talk about managing and tuning database performance, we know that these tasks used to require expertise and used to be time-consuming. Sometimes we would not achieve the best results in our first, or even second, or third attempt to fix the performance issue. In this course, Managing Azure SQL Server Database Performance, you will gain the ability to leverage Azure services and features to help you to manage and tune the performance of your Azure SQL databases without requiring expertise and significant efforts from you. These services and features are leveraging Azure Engineers team and artificial intelligence to perform these tasks for you and remove the responsibility from you to perform them. First, you will discover the different hosting options you have available in Azure to host your SQL databases. Next, you will learn the different services and features you have available to allow you to monitor and troubleshoot issues in your databases. Finally, you will explore how to use features, such as Performance Recommendations and Automatic Tuning. When you’re finished with this course, you will have the skills and knowledge of using Azure services and features to manage and tune the performance of your Azure SQL databases.

About the author
About the author

Hugo is a Sr. Software Engineer with expertise in Software Development, developing applications based on the Microsoft Stack while leveraging the Open Source technologies. He is a passionate professional for Cloud Systems and Technologies, specifically all Microsoft Azure related. He is Microsoft Certified Professional with Microsoft Certifications in Web/App Development (MCSA - Web Applications, MCSD - App Builder) and Azure (Azure Developer Associate and Azure Solutions Architect).

More from the author
Power Platform: Getting Started
Beginner
2h 1m
Jul 2, 2020
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Hugo Barona, and welcome to my course, Managing Azure SQL Server Database Performance. I am an independent contractor and Azure Solutions Architect with a passion for Azure. In this course, we are going to see how we can leverage Azure services and features to manage the performance of your Azure SQL database in a smooth and easy way. Some of the major topics that we will cover include options you have available towards your SQL database in Azure, using Query Performance Insight for basic performance monitoring, using Azure SQL Analytics for advanced performance monitoring, and leveraging automatic tuning to ensure the best performance of your database. By the end of this course, you will understand which service and features you can leverage to tune the performance of your database. Also, you will understand how you can use automatic tuning to ensure the best performance of your database in an effortless manner. Before beginning the course, you should be familiar with the different options and methods you have available to tune the performance of your SQL database authored in SQL Server. I hope you will join me on this journey to learn more about these amazing Azure services and features to ensure the best performance for your Azure SQL database, with the Managing Azure SQL Server Database Performance course, at Pluralsight.