Randolph West

Learn how to combine SQL Server's analytics with Azure's flexibility and hybrid connectivity to achieve industry-leading performance and manageability for your cloud database.Key FeaturesUnderstand platform availability for SQL Server in AzureExplore the benefits and deployment choices offered by SQL IaaSGet to grips with deploying SQL Server on the Linux development ecosystemBook DescriptionDeploying SQL Server on Azure virtual machines allows you to work on full versions of SQL Server in the cloud without having to maintain on-premises hardware. The book begins by introducing you to the SQL portfolio in Azure and takes you through SQL Server IaaS scenarios, before explaining the factors that you need to consider while choosing an OS for SQL Server in Azure VMs. As you progress through the book, you'll explore different VM options and deployment choices for IaaS and understand platform availability, migration tools, and best practices in Azure. In later chapters, you'll learn how to configure storage to achieve optimized performance. Finally, you'll get to grips with the concept of Azure Hybrid Benefit and find out how you can use it to maximize the value of your existing on-premises SQL Server.By the end of this book, you'll be proficient in administering SQL Server on Microsoft Azure and leveraging the tools required for its deployment.What you will learnChoose an operating system for SQL Server in Azure VMsUse the Azure Management Portal to facilitate the deployment processVerify connectivity and network latency in cloudConfigure storage for optimal performance and connectivityExplore various disaster recovery options for SQL Server in AzureOptimize SQL Server on LinuxDiscover how to back up databases to a URLWho this book is forSQL Server on Azure VMs is for you if you are a developer, data enthusiast, or anyone who wants to migrate SQL Server databases to Azure virtual machines. Basic familiarity with SQL Server and managed identities for Azure resources will be a plus.

Conquer SQL Server 2022 and Azure SQL administration from the inside out! Dive into SQL Server 2022 administration and grow your Microsoft SQL Server data platform skillset. This well-organized reference packs in timesaving solutions, tips, and workarounds, all you need to plan, implement, deploy, provision, manage, and secure SQL Server 2022 in any environment: on-premises, cloud, or hybrid, including detailed, dedicated chapters on Azure SQL Database and Azure SQL Managed Instance. Nine experts thoroughly tour DBA capabilities available in the SQL Server 2022 Database Engine, SQL Server Data Tools, SQL Server Management Studio, PowerShell, and much more. You'll find extensive new coverage of Azure SQL Database and Azure SQL Managed Instance, both as a cloud platform of SQL Server and in their new integrations with SQL Server 2022, information available in no other book. Discover how experts tackle today's essential tasks and challenge yourself to new levels of mastery. Identify low-hanging fruit and practical, easy wins for improving SQL Server administrationGet started with modern SQL Server tools, including SQL Server Management Studio, and Azure Data StudioUpgrade your SQL Server administration skillset to new features of SQL Server 2022, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on LinuxDesign and implement modern on-premises database infrastructure, including KubernetesLeverage data virtualization of third-party or non-relational data sourcesMonitor SQL instances for corruption, index activity, fragmentation, and extended eventsAutomate maintenance plans, database mail, jobs, alerts, proxies, and event forwardingProtect data through encryption, privacy, and auditingProvision, manage, scale and secure, and bidirectionally synchronize Microsoft's powerful Azure SQL Managed InstanceUnderstand and enable new Intelligent Query Processing features to increase query concurrencyPrepare a best-practice runbook for disaster recoveryUse SQL Server 2022 features to span infrastructure across hybrid environments