Managing Azure SQL Database for the SQL Server DBA

سرفصل های دوره

01 Introduction

001 Course Introduction

002 Prerequisites

02 What Is Azure SQL Database

001 Introduction to What Is Azure SQL Database

002 What Is Azure SQL Database

003 Azure SQL Database documentation.txt

003 Azure SQL Database pricing page.txt

003 Service Cost and Value

004 Azure SQL Database documentation.txt

004 Azure SQL Database pricing page.txt

004 Getting Started

005 Demo Creating an Azure SQL Database

006 Section Summary

1669840693509-2022-11-16 - 1206 S02 L05 Newdb.txt

03 Connecting and Managing Azure SQL Database

001 Introduction

002 Networking Firewalls and Authentication

003 Demo Connecting to the Database

004 Security Features

005 Differences with SQL Server

006 Demo Management Differences

007 Section Summary

1669895997387-1206 - S03-L03 Database Firewall.txt

1669896019681-1206 - S03-L06 XEvent Trace.txt

1669916135011-1206 - S03-L06 Logging Views.txt

04 Understanding the Service Tiers

001 Introduction

002 Service Tiers Fundamentals

003 Core-Based Tiers

004 Demo Scaling Up the Service Tier

004 SQLQueryStress Github Repo.txt

004 VCore tiers names and specifications page.txt

005 Azure SQL Database Optional Modes

005 Elastic Database .txt

005 Elastic Jobs.txt

005 Elastic Query.txt

006 Demo Creating a Database Elastic Pool

007 Section Summary

1672776876741-1206 - S04-L04 ScaleUpDatabase.txt

1672776901650-1206 - S04-L04 SqlQueryStressQuery.txt

1672776921343-1206 - S04-L04 t1 bacpac.zip

1672776944863-1206 - S04-L04 WhichDbTier.txt

05 Recovery in Azure SQL Database

001 Introduction

002 Backup Capabilities

003 Performing Restores

004 Demo Restoring a Database

005 High Availability and Disaster Recovery

006 Demo Configuring an Auto-Failover Group

007 Section Summary

06 Migrating to and from Azure SQL Database

001 Introduction

002 Migration Methodology

003 Azure Database Migration Service.txt

003 Azure Data Studio SQL Migration Extension.txt

003 Microsoft Data Migration Assistant.txt

003 Migration Tools

003 SQL Server Transactional Replication.txt

004 AdventureWorksLT.txt

004 Demo Migrating with the Microsoft Data Migration Assistant

005 Demo Migrating with SQL Server Transactional Replication

006 Moving Back to SQL Server

007 Demo Migrating Back to SQL Server

007 SQLPackage.txt

008 Section Summary

07 Monitoring and Tuning Azure SQL Database

001 Introduction

002 Azure Metrics Alerts

003 Demo Creating Database Alerts

004 Performance System Views

005 Demo Tracking Performance with System Views

006 Azure Performance Tools

007 Demo Reviewing Performance and Recommendations in the Portal

008 Section Summary

1677687917449-1206 - S07-L07 - AdventureWorksLT-Recommendations-Query.txt

1677694112527-1206 - S07-L03 - PowerShell Alert.txt

08 Conclusion

001 Course Summary

002 Conclusion and Whats Next

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: A Cloud Guru