Administering Microsoft Azure SQL Solutions by Geoff Hiten

Administering Microsoft Azure SQL Solutions by Geoff Hiten

Ace the DP-300 Exam with this essential study companion, chock-full of insights and tips you cannot find online.

This book will help you build a comprehensive understanding of Azure SQL systems and their role in supporting business solutions, and it will equip you with the mental models and technical knowledge needed to confidently answer exam questions.

Structured to align with Microsoft’s published study guide, the book spans five major sections that correspond to the skills measured by the exam, covering topics vital to modern cloud operations and including HA/DR, security, compliance, performance, and scalability. You’ll also learn about the ways cloud operations have changed the focus of operating database systems from task execution to platform configuration—and how to configure your data platforms to meet this new reality.

By the end of this book, you’ll be prepared to navigate exam scenarios with finesse, pass the exam with confidence, and advance in your career with a solid foundation of knowledge.

What You Will Learn

• Maximize your ability to benefit from the online learning tools for Exam DP-300
• Gain depth and context for Azure SQL technical solutions relevant to Exam DP-300
• Boost your confidence in Azure SQL Database skills
• Extend your on-premises SQL Server skill set into the Azure SQL cloud
• Enhance your overall understanding of Azure SQL administration and operations
• Develop your Azure SQL skill set to increase your value as an employee or contractor
• Adopt a new mindset for cloud-based solutions versus on-premises solutions

Who This Book Is For

Anyone planning to take the DP-300: Administering Microsoft Azure SQL Solutions exam, and those who wish to understand Azure SQL and how to successfully migrate and manage SQL solutions using all Azure SQL Technologies

Geoff Hiten began his SQL journey with Microsoft SQL Server version 4.2 for Windows NT in 1993 and hasn’t had the good sense to find an easier way to earn a living. Prior to that, he worked on dBase and other ISAM data systems. Geoff is a graduate of the University of Alabama (also in 1993), He has worked for many different organizations, managing their SQL Infrastructure. He built his first production SQL Cluster in 2002 using Microsoft SQL Server 2000. In 2005, in recognition of his SQL community leadership and involvement, Geoff was invited to become a Microsoft SQL (later Data Platform) MVP. That recognition lasted until 2018 when he joined Microsoft. In 2007, Geoff got tired of filling out new W-4 forms when finding new SQL problems and started working as a consultant. He now advises Microsoft customers on how to understand and adopt Azure SQL technologies as a Senior Data & AI Technical Specialist.