Prepare for Microsoft Exam 70-765–and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level.

Focus on the expertise measured by these objectives:

• Implement SQL in Azure
• Manage databases and instances
• Manage storage

• Organises its coverage by exam objectives
• Features strategic, what-if scenarios to challenge you
• Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills

Introduction

Chapter 1 Implement SQL in Azure

Skill 1:1: Deploy a Microsoft Azure SQL Database

Skill 1:2: Plan for SQL Server installation

Skill 1:3: Deploy SQL Server instances

Skill 1:4: Deploy SQL Server databases to Azure virtual machines

Chapter 2 Manage databases and instances

Skill 2.1: Configure secure access to Microsoft Azure SQL databases

Skill 2.2: Configure SQL Server performance settings

Skill 2.3: Manage SQL Server instances

Chapter 3 Manage Storage

Skill 3.1: Manage SQL Storage

Skill 3.2: Perform database maintenance

Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry & Associates and lives in Malvern, PA.

Scott Klein loves data. His passion for data brought him to Cloud and Devices where he continues to help developers and companies grok the benefits of cloud computing.