Pro SQL Server on Microsoft Azure / by Pranab Mazumdar, Sourabh Agarwal, Amit Banerjee.

Format:

Book

Author/Creator:

Mazumdar, Pranab., Author.

Agarwal, Sourabh., Author.

Banerjee, Amit, Author.

Language:

English

Subjects (All):

Microsoft Azure SQL Database.

SQL server.

Database management.

Database Management.

Local Subjects:

Database Management.

Physical Description:

1 online resource (223 p.)

Edition:

1st ed. 2016.

Place of Publication:

Berkeley, CA : Apress : Imprint: Apress, 2016.

System Details:

text file

Summary:

Learn the basics of Microsoft Azure and see how SQL Server on Azure VMs (Infrastructure-as-a-Service) and Azure SQL Databases (Platform-as-a-Service) work. This concise book shows you how to deploy, operate, and maintain your data using any one or a combination of these offerings along with your on-premise environment. Pro SQL Server on Microsoft Azure is a quintessential book for any IT professional who is planning to host their data on Microsoft Azure. This book will not only equip you with the tips, tricks, and tools to manage SQL Server offerings on Azure, but will also help you in deciding between PaaS, IaaS, or hybrid. In the ever-changing world of operations, IT administrators and SQL Server DBAs often find that the biggest challenges occur once they’ve deployed to the cloud. This is precisely why Pro SQL Server on Microsoft Azure was written. It will help you master today’s cloud world, focusing on the following issues: Understanding the Microsoft Azure IaaS architecture Working with Azure Storage and Networking Deploying SQL Server on Azure VMs using best practices Applying effective security principles to SQL Azure Databases Measuring and optimizing the performance of SQL Server offerings on Azure Implementing Business continuity and disaster recovery options with Azure SQL Databases .

Contents:

Contents at a Glance; Contents; About the Authors; About the Technical Reviewer; Acknowledgments; Chapter 1: Introduction to Microsoft Azure; Cloud Computing Overview; Characteristics of Cloud Computing; Service Models; Platform as a Service; Infrastructure as a Service; Software as a Service; Microsoft Azure; Azure Services; Compute Offerings; Virtual Machines; Azure WebApps (Formerly Azure Websites); Cloud Services; Data Management Offerings; SQL/Oracle Running on Azure VM; Azure SQL Database; Azure Blobs; Azure Table Storage; Networking; Virtual Network; VPN Connection Options

Point-to-Site VPN ConnectionSite-to-Site VPN Connection; ExpressRoute Connection; Developer Services; Visual Studio Team Services; Application Insights; Identity and Access; Active Directory; Backup; Azure Site Recovery; Summary; Chapter 2: Azure Architecture; The Azure Services; The Compute; The Storage; The Network; How It Works Together; Update/Upgrade Domain; Fault Domain; Deployment; Classic Deployment Model; Resource Manager Deployment Model; Deployment Automation; Summary; Chapter 3: Microsoft Azure Storage; Azure Storage Service; Blob Storage; Table Storage; Queue Storage

File StorageDesign Decisions; Azure Storage Architecture Internals; Replication Engine; Layers Within a Storage Stamp; Maintaining Availability/Consistency for Read Requests; Load Balancing of Partition Layer; Load Balancing of the DFS Layer; Load Balancing of DFS Capacity; Durability Offerings with Azure Storage; Azure Premium Storage; Creating an Azure VM Machine Using Premium Storage and PowerShell; Inside Premium Storage; Azure Storage Best Practices; Performance Enhancement Using Blobs; Copy/Move Blobs; AzCopy; Choosing the Right Kind of Blob; Performance Enhancement Using Tables

Querying Data Best PracticesSummary; Chapter 4: Microsoft Azure Networking; Networking Primer; Site-to-Site Connections; Point-to-Site Connections; ExpressRoute; Azure AD Connect; Traffic Manager; Virtual Private Network; Load Balancer; Azure DNS; Summary; Additional References; Chapter 5: Deploying SQL Server on Azure VMs; Deploying a Standalone SQL Server Instance; Configuration Settings; Virtual Machine Region; Virtual Machine Hardware; SQL Server Settings; Automating the Automation; Post Deployment; Azure Resource Explorer; Azure CLI; Summary; Chapter 6: SQL Hybrid Solutions

Hybrid Model SnapshotBackups to Azure Storage; SQL Server Files in Microsoft Azure Storage; Smart Backup; AlwaysOn Configuration on Azure VMs; Summary; Additional References; Chapter 7: All About Performance; Understanding the Virtual Machine Performance; Compute; Network; Storage; Data Disks; Storage Spaces; Tempdb; Database Settings; Service Account Privileges; Backups; Data Files on Azure Blobs; Monitoring; Operational Insights; Cheat Sheet; Summary; Chapter 8: Azure SQL Database; SQL Database Architecture; The Tenant Ring; The Control Ring; Control Management Node; Management Service Node

Redirector Services Node

Notes:

Includes index.

ISBN:

9781484220832

1484220838

OCLC:

958879536