Category: Business Continuity
Indexes – Relational Databases in Azure
Indexes Consider the index at the end of this book. Its purpose is to sort keywords and provide each keyword’s location in the book. Database indexes work very similarly in that they sort a list of values and provide pointers to the physical locations of those values. Ideally, indexes are designed to optimize the way …
Extract – Core Data Concepts
Extract The first phase of an ETL process involves extracting data from different source systems and storing it in a consolidated staging layer that is easier for the transformation tools to access. Data sources are typically heterogenous and are represented by a wide variety of data formats. The staging layer can be transient to cut …
Relational Database Offerings in Azure – Relational Databases in Azure
Relational Database Offerings in Azure Until recently, most organizations hosted their database systems in on-premises datacenters that they owned or leased. They were responsible for applying updates to the database software and had to make sure that the hardware hosting the databases was properly maintained. Business continuity aspects such as database backup management, high availability …
Relational Database Offerings in Azure – Relational Databases in AzureRead More
SQL Server on Azure Virtual Machine – Relational Databases in Azure
SQL Server on Azure Virtual Machine There are several reasons why an organization would want to migrate its applications to the cloud. Perhaps the most common reason is to offload the maintenance of hardware and networking equipment that it either owns or leases to a cloud provider. Expiring datacenter leases or aging hardware force many …
SQL Server on Azure Virtual Machine – Relational Databases in AzureRead More
Business Continuity – Relational Databases in Azure
Business Continuity There are multiple solutions available in Azure to ensure that data hosted on SQL Server VMs is highly available in the event of several outage scenarios, ranging from planned downtime to datacenter-level disasters. These include solutions that provide database backup management at the database level and high availability and disaster recovery (HADR) capabilities …
Business Continuity – Relational Databases in AzureRead More