Название: Azure SQL Fundamentals: Learn to Configure, Secure, Monitor, and Troubleshoot Azure SQL - Companion Guide: First Edition - 2022
Автор: IPSpecialist
Издательство: IPSpecialist
Год: 2022
Страниц: 367
Язык: английский
Формат: epub
Размер: 13.9 MB

Companion Guides are portable desk guides for the IPSpecialist course materials that users (students, professionals, and experts) can access at any time and from any location. Companion Guides are intended to supplement online course material by assisting users in concentrating on key ideas and planning their study time for quizzes and examinations.

Many businesses still use outdated or inadequately developed data platform strategies. There has been a noticeable trend toward dumping some on-premises costs, shifting existing systems to the cloud, and swiftly developing new applications using the cloud. You must have a strategy in place for moving some workloads to the cloud. You also need to know how to organize your business for success. Additionally, you need to comprehend how the job of a database administrator (DBA) or data professional will evolve and how it will remain the same. You will begin this subject with a brief overview of how and why Microsoft created Azure SQL. The many deployment choices and service tiers will then be covered, along with information on when to employ each for your organization. These choices include SQL Server running inside an Azure virtual machine, Azure SQL Managed Instance, and Azure SQL Database. When you go to the cloud, it will be easier for you to comprehend what platform as a service (PaaS) entails and how it differs from a conventional SQL Server installation.

SQL has been a significant component of Azure from the start. SQL Azure offers a version of SQL Server that is hosted in the cloud. Later, Windows Azure and SQL Azure were rebranded to Microsoft Azure and Azure SQL, respectively, and both have subsequently significantly increased their service offerings.

Microsoft's Azure cloud computing platform includes Azure SQL, a cloud database service. For Azure SQL, unlike other editions of SQL Server, Microsoft maintains the platform for you; you do not need to provision hardware for, install, or patch Azure SQL. Additionally, since the service automatically provides these functionalities, you do not need to construct a database installation for scalability, high availability, or disaster recovery. Azure SQL applications need to be connected to the Internet in order to access the database.

SQL Server on Azure Virtual Machine: A version of SQL Server that runs in an Azure VM is called SQL Server on a virtual machine. All your SQL Server abilities should transfer seamlessly as just SQL Server, though Azure can help automate backups and security patches. Infrastructure as a service (IaaS) is the term used to describe SQL Server on an Azure virtual machine (IaaS). Except crucial SQL Server security patches, you are in charge of upgrading and patching the OS and SQL Server. However, you have access to all of the SQL Server's features.