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.

Select Guide Rating

• 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.

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.

Select Guide Rating

• 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.

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.

Select Guide Rating

• 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.