LEADER 06017nam 22005535 450 001 9910254748103321 005 20200705071107.0 010 $a1-4842-2083-8 024 7 $a10.1007/978-1-4842-2083-2 035 $a(CKB)3710000000838146 035 $a(EBL)4653465 035 $a(DE-He213)978-1-4842-2083-2 035 $a(MiAaPQ)EBC4653465 035 $a(CaSebORM)9781484220832 035 $a(PPN)19480738X 035 $a(EXLCZ)993710000000838146 100 $a20160823d2016 u| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aPro SQL Server on Microsoft Azure $b[electronic resource] /$fby Pranab Mazumdar, Sourabh Agarwal, Amit Banerjee 205 $a1st ed. 2016. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2016. 215 $a1 online resource (223 p.) 300 $aIncludes index. 311 $a1-4842-2082-X 327 $aContents 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 327 $aPoint-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 327 $aFile 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 327 $aQuerying 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 327 $aHybrid 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 327 $aRedirector Services Node 330 $aLearn 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 . 606 $aDatabase management 606 $aDatabase Management$3https://scigraph.springernature.com/ontologies/product-market-codes/I18024 615 0$aDatabase management. 615 14$aDatabase Management. 676 $a004 700 $aMazumdar$b Pranab$4aut$4http://id.loc.gov/vocabulary/relators/aut$0861747 702 $aAgarwal$b Sourabh$4aut$4http://id.loc.gov/vocabulary/relators/aut 702 $aBanerjee$b Amit$4aut$4http://id.loc.gov/vocabulary/relators/aut 801 0$bUMI 801 1$bUMI 906 $aBOOK 912 $a9910254748103321 996 $aPro SQL Server on Microsoft Azure$91923089 997 $aUNINA