Companies Home Search Profile

Managing Azure SQL Server Database Performance

Focused View

Hugo Barona

1:31:58

33 View
  • 0. Course Overview.mp4
    01:39
  • 0. Introduction.mp4
    01:12
  • 1. Hosting Options for SQL Databases.mp4
    05:46
  • 2. Factors to Consider When Choosing the Data Offering.mp4
    02:29
  • 3. Demo- Create Azure SQL Database.mp4
    05:29
  • 4. Migration Options.mp4
    04:40
  • 5. Demo- Migrate SQL Database to Azure Using Data Migration Assistant.mp4
    07:24
  • 6. Overview.mp4
    00:54
  • 0. Introduction.mp4
    00:57
  • 1. On-premises vs. PaaS Model for Database Monitoring and Troubleshooting.mp4
    03:09
  • 2. Metrics and Diagnostics Logging.mp4
    07:20
  • 3. Using Query Performance Insight for Basic Monitoring.mp4
    01:57
  • 4. Demo- Using Query Performance Insights.mp4
    02:57
  • 5. Using Azure SQL Analytics for Advanced Monitoring.mp4
    06:08
  • 6. Demo- Using Azure SQL Analytics.mp4
    06:16
  • 7. Overview.mp4
    00:51
  • 0. Introduction.mp4
    00:48
  • 1. Before Starting to Manually Tune Your Database.mp4
    02:54
  • 2. Performance Recommendations.mp4
    02:54
  • 3. Demo- Using Performance Recommendations.mp4
    05:05
  • 4. Manual Tune Azure SQL Database.mp4
    04:05
  • 5. Overview.mp4
    00:55
  • 0. Introduction.mp4
    01:05
  • 1. Exploring Automatic Tuning.mp4
    03:05
  • 2. Benefits of Using Automatic Tuning When Compared to Other Performance Tuning Options.mp4
    02:55
  • 3. Options to Enable Automatic Tuning.mp4
    04:02
  • 4. Demo- Enable and Configure Automatic Tuning.mp4
    04:14
  • 5. Overview.mp4
    00:48
  • Description


    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.

    What You'll Learn?


      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.

    More details


    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    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). But Love is more than only loving our profession and work, so Hugo loves to travel, meet new people and new cultures and seize and tries to get the most out of life by always seizing the moment.
    Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.
    • language english
    • Training sessions 28
    • duration 1:31:58
    • level advanced
    • Release Date 2023/10/20