Administering Microsoft Azure SQL Solutions

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 configurationand 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

  Helps you study for the Microsoft DP-300 Exam Builds your knowledge and skills around Azure SQL Database Services Follows the official exam outline that Microsoft recommends you study

  Autorentext

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.

Inhalt

1. About the DP-300 Exam, this book, and Azure.- Part 1: Plan and Implement Azure SQL Data Platform Resources.- 2. Plan and Implement Azure SQL Database Solutions.- 3. Configure Resources for Scale and Performance.- 4. Plan and Implement a Migration Strategy.- Part 2: Implement a Secure Environment.- 5. Configure Database Authentication and Authorization.- 6. Implement Security for Data at Rest and Data in Transit.- 7. Implement Compliance Controls for Sensitive Data.- Part 3: Monitor, Configure, and Optimize Database Resources.- 8. Monitor Resource Activity and Performance.- 9. Monitor and Optimize Query Performance.- 10. Configure Database Solutions for Optimal Performance.- Part 4: Configure and Manage Automation.- 11. Create and Manage SQL Agent Jobs.- 12. Automate Deployment of Database Resources.- 13. Create and Manage Database Tasks in Azure.- Part 5: Plan and Configure a High Availability and Disaster Recovery (HA/DR) Environment.- 14. Recommend a HA/DR Strategy for Database Solutions.- 15. Plan and Perform Backup and Restore of a Database.- 16. Configure HA/DR for Database Solutions.