Pro SQL Server on Microsoft Azure. (2016)

• Record Type: Book
• Further Information: Note: Pranab Mazumdar, Sourabh Agarwal, Amit Banerjee.
• Authors: Mazumdar, Pranab; Agarwal, Sourabh; Banerjee, Amit
• 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.
• Publisher Details: New York : Apress
• Publication Date: 2016
• Extent: 1 online resource
• Subjects: 005.74; Computer science; COMPUTERS -- Desktop Applications -- Databases; Computer Science; Database Management; Programming Languages, Compilers, Interpreters; Programming Techniques; Information Storage and Retrieval; Database management; Computers -- Database Management -- General; Databases; Electronic books
• Languages: English
• ISBNs: 9781484220832; 1484220838
• Related ISBNs: 148422082X; 9781484220825
• Notes: Note: Online resource, title from PDF title page (EBSCO), viewed September 11, 2016.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.