Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Implementing Microsoft Azure Architect Technologies: AZ-303 Exam Prep and Beyond - Second Edition

You're reading from  Implementing Microsoft Azure Architect Technologies: AZ-303 Exam Prep and Beyond - Second Edition

Product type Book
Published in Dec 2020
Publisher Packt
ISBN-13 9781800568570
Pages 548 pages
Edition 2nd Edition
Languages
Concepts
Authors (2):
Brett Hargreaves Brett Hargreaves
Profile icon Brett Hargreaves
LinkedIn
Brett Hargreaves is a principal Azure consultant for Iridium Consulting, who has worked with some of the world's biggest companies, helping them design and build cutting-edge solutions. With a career spanning infrastructure, development, consulting, and architecture, he's been involved in projects covering the entire solution stack using Microsoft technologies. He loves passing on his knowledge to others through books, blogging, and his online training courses.
Read more
See other products by Brett Hargreaves
Sjoukje Zaal Sjoukje Zaal
Profile icon Sjoukje Zaal
LinkedIn
Sjoukje Zaal is head of the Microsoft Cloud Center of Excellence, Microsoft Regional Director, and Microsoft Azure MVP with over 20 years' experience in architecture, development, consultancy, and design-related roles. She currently works at Capgemini, a global leader in consultancy, technology services, and digital transformation. She loves to share her knowledge and is active in the Microsoft community as a co-founder of the user groups Tech Daily Chronicle, Global XR Community, and the Mixed Reality User Group. She is also a board member of Azure Thursdays and Global Azure. Sjoukje is an international speaker and is involved in organizing many events. She has written several books and writes blogs.
Read more
See other products by Sjoukje Zaal
View More author details
Toc

Table of Contents (25) Chapters close

Preface 1. Section 1: Implement and Monitor Azure Infrastructure
2. Chapter 1: Implementing Cloud Infrastructure Monitoring 3. Chapter 2: Creating and Configuring Storage Accounts 4. Chapter 3: Implementing and Managing Virtual Machines 5. Chapter 4: Implementing and Managing Virtual Networking 6. Chapter 5: Creating Connectivity between Virtual Networks 7. Chapter 6: Managing Azure Active Directory (Azure AD) 8. Chapter 7: Implementing Multi-Factor Authentication (MFA) 9. Chapter 8: Implementing and Managing Hybrid Identities 10. Section 2: Implement Management and Security Solutions
11. Chapter 9: Managing Workloads in Azure 12. Chapter 10: Implementing Load Balancing and Networking Security 13. Chapter 11: Implementing Azure Governance Solutions 14. Section 3: Implement Solutions for Apps
15. Chapter 12: Creating Web Apps Using PaaS and Serverless 16. Chapter 13: Designing and Developing Apps for Containers 17. Chapter 14: Implementing Authentication 18. Section 4: Implement and Manage Data Platforms
19. Chapter 15: Developing Solutions that Use Cosmos DB Storage 20. Chapter 16: Developing Solutions that Use a Relational Database 21. Chapter 17: Mock Exam Questions
22. Chapter 18: Mock Exam Answers
23. Assessments 24. Other Books You May Enjoy

Publishing a SQL database

One of the requirements for the AZ-303 exam is knowing how to migrate a database from an existing on-premises database into Azure.

There are actually a number of different ways we can achieve this, the most obvious being to perform a backup and restore operation.

However, SQL Server Management Studio contains a built-in wizard that makes the process of moving databases easy.

In this example, we are going to publish a database that resides on an on-premises database server to Azure:

Important note

For the following example, I have set up a Windows server running SQL Server Express and SQL Server Management Studio. I have also opened my Azure SQL Server firewall to allow my Windows server to connect. A T-SQL script to create and populate a simple database can be found at the GitHub link in the Technical requirements section.

  1. On a computer, run SQL Server Management Studio.
  2. Connect to the local server.
  3. Right-click Databases and...
lock icon The rest of the chapter is locked
arrow left Previous Section
Section 9 of 12
Next Section arrow right
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Sign up now
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Start free trial
Renews at €14.99/month. Cancel anytime

Authors (2)

Left arrow icon
Profile icon Brett Hargreaves
LinkedIn
Brett Hargreaves is a principal Azure consultant for Iridium Consulting, who has worked with some of the world's biggest companies, helping them design and build cutting-edge solutions. With a career spanning infrastructure, development, consulting, and architecture, he's been involved in projects covering the entire solution stack using Microsoft technologies. He loves passing on his knowledge to others through books, blogging, and his online training courses.
Read more
See other products by Brett Hargreaves
Profile icon Sjoukje Zaal
LinkedIn
Sjoukje Zaal is head of the Microsoft Cloud Center of Excellence, Microsoft Regional Director, and Microsoft Azure MVP with over 20 years' experience in architecture, development, consultancy, and design-related roles. She currently works at Capgemini, a global leader in consultancy, technology services, and digital transformation. She loves to share her knowledge and is active in the Microsoft community as a co-founder of the user groups Tech Daily Chronicle, Global XR Community, and the Mixed Reality User Group. She is also a board member of Azure Thursdays and Global Azure. Sjoukje is an international speaker and is involved in organizing many events. She has written several books and writes blogs.
Read more
See other products by Sjoukje Zaal
Right arrow icon

Other recommended products

Related to this chapter
Left arrow icon
Microsoft Azure Architect Technologies: Exam Guide AZ-300
Microsoft Azure Architect Technologies: Exam Guide AZ-300
Read more
Microsoft Azure Architect Technologies: Exam Guide AZ-300 is a complete guide that will help you master topics related to Azure architect practices. Using this guide, you will have all the information required to take the AZ-300 exam and become a Microsoft Azure Architect expert.
Read more
Jan 2020 18 hours 0 minutes
Microsoft Azure Administrator – Exam Guide AZ-103
Microsoft Azure Administrator – Exam Guide AZ-103
Read more
Microsoft Azure Administrator- Exam Guide AZ-103 is a complete guide that will help you master topics related to Azure administrator practices. Using this guide, you will have all the information required to ace the AZ-103 exam and become a Microsoft Azure administrator expert.
Read more
May 2019 15 hours 4 minutes
Architecting Microsoft Azure Solutions - Exam Guide 70-535
Architecting Microsoft Azure Solutions - Exam Guide 70-535
Read more
This study guide includes all the topics that are still relevant from the previous 70-534 exam, updated with the latest features like Artificial Intelligence, IoT, and architecture styles. This guide will help Azure Architects, Developers or anyone interested in designing and implementing effective Cloud architecture strategies.
Read more
Apr 2018 13 hours 56 minutes
Azure Networking Cookbook
Azure Networking Cookbook
Read more
Azure offers an extensive stack of network services that we can use, from simple Virtual Network and Subnets, over Network Security Groups and Gateways, to Load Balancers and many other services. In this book, we’ll offer the best Azure networking recipes to help you quickly create network resources and use them to your advantage.
Read more
Mar 2019 7 hours 48 minutes
Azure PowerShell Quick Start Guide
Azure PowerShell Quick Start Guide
Read more
As an IT professional, it is important to keep up with cloud technologies and learn to manage those technologies. PowerShell is a critical tool that must be learned in order to effectively and more easily manage many Azure resources. This book is designed to teach you to leverage PowerShell to perform many day-to-day tasks in Microsoft Azure.
Read more
Dec 2018 3 hours 56 minutes
Exam Ref AZ-304 Microsoft Azure Architect Design Certification and Beyond
Exam Ref AZ-304 Microsoft Azure Architect Design Certification and Beyond
Read more
If you're taking the AZ-304 Microsoft Azure Architect Design exam, you need to know which Azure technologies to choose and when. Exam Ref AZ-304 Microsoft Azure Architect Design Certification and Beyond prepares you for the AZ-304 exam and shows you how to design scalable and secure solutions using compute, storage, data, monitoring, and logging.
Read more
Jul 2021 17 hours 20 minutes
Hands-On Networking with Azure
Hands-On Networking with Azure
Read more
Customizing networks and controlling the traffic flow is becoming a must for all the modern solutions, even if these solutions exist on Azure, on-premises or a combination of both. In this book, you will learn all Azure networking solutions and spanning them across Azure and On-premises, and how to build a highly available environment by them.
Read more
Mar 2018 9 hours 12 minutes
Mastering Azure Security
Mastering Azure Security
Read more
Mastering Azure Security enables you to implement top-level security in your Azure tenant. With a focus on cloud security, this book will look at the architectural approach on how to design your Azure solutions to keep and enforce resources secure.
Read more
May 2020 8 hours 44 minutes
Azure Networking Cookbook
Azure Networking Cookbook
Read more
This second edition of the Azure Networking Cookbook will help you get a firm grip on basic and advanced Azure network management tools. You’ll discover the latest networking features in Azure and gain the confidence to create cost-effective solutions for efficient connectivity.
Read more
Dec 2020 9 hours 56 minutes
Implementing Microsoft Azure Infrastructure Solutions: Exam Guide 70-533
Implementing Microsoft Azure Infrastructure Solutions: Exam Guide 70-533
Read more
This book focuses on skills and knowledge for provisioning and managing services in Microsoft Azure. This includes implementing infrastructure components such as virtual networks, virtual machines, containers, web and mobile apps, storage, planning and managing Azure AD and configuring Azure AD integration with on-premises Active Directory domains.
Read more
Aug 2018 17 hours 12 minutes
Learning Microsoft Azure Storage
Learning Microsoft Azure Storage
Read more
Microsoft Azure Storage is the bedrock of Microsoft's core storage solution offering in Azure. No matter what solution you are building for the cloud, you'll find a compelling use for Azure Storage. This book will help you get up-to-speed quickly on Microsoft Azure Storage by teaching you how to use the different storage services. You will be able to leverage secure design patterns based on real-world scenarios and develop a strong storage foundation for Azure virtual machines.
Read more
Nov 2017 9 hours 12 minutes
Microsoft Operations Management Suite Cookbook
Microsoft Operations Management Suite Cookbook
Read more
Microsoft OMS is a one stop IT management solution used to gain visibility and control over hybrid environments with simplified operations management and security. With Microsoft-based solutions in Azure, OMS helps organizations make the most of their IT investments. This book offers practical and hands-on recipes to gather real-time operational intelligence of your entire hybrid environment.
Read more
Apr 2018 14 hours 56 minutes
Right arrow icon

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Designing and Implementing Microsoft Azure Networking Solutions
Designing and Implementing Microsoft Azure Networking Solutions
Read more
Designing and Implementing Microsoft Azure Networking Solutions Exam Ref AZ-700 is an all-encompassing guide to the AZ-700 exam and contains all the information you need to succeed in the world of virtual networking with Azure. With this book, you will be fully prepared for the exam and the world of cloud networking.
Read more
Aug 2023 17 hours 28 minutes
Microsoft 365 Security, Compliance, and Identity Administration
Microsoft 365 Security, Compliance, and Identity Administration
Read more
The Microsoft 365 Security, Compliance, and Identity Administration is a comprehensive guide that helps you employ Microsoft 365's robust suite of features and empowers you to optimize your administrative tasks.
Read more
Aug 2023 21 hours 0 minutes
Zero Trust Overview and Playbook Introduction
Zero Trust Overview and Playbook Introduction
Read more
Get started on Zero Trust with this step-by-step playbook and learn everything you need to know for a successful Zero Trust journey with tailored guidance for every role, covering strategy, operations, architecture, implementation, and measuring success. This book will become an indispensable reference for everyone in your organization.
Read more
Oct 2023 8 hours 0 minutes
The Self-Taught Cloud Computing Engineer
The Self-Taught Cloud Computing Engineer
Read more
This self-study book helps you master multiple clouds, including AWS, Azure, and GCP, and serves as a roadmap to becoming a certified cloud computing expert. The book will guide you to develop a professional cloud career by helping you build a broad cloud knowledge base, developing hands-on cloud computing skills, and getting cloud certified.
Read more
Sep 2023 15 hours 44 minutes
Technology Operating Models for Cloud and Edge
Technology Operating Models for Cloud and Edge
Read more
This book will help you build and create ownership of a technology operating model, as well as connect your leadership with engineering and operations, keeping your internal and external customers in mind. It provides practical tips on why, where, and how to make the cloud and edge platform paradigm sing for you, your team, and your organization.
Read more
Aug 2023 7 hours 36 minutes
Azure Architecture Explained
Azure Architecture Explained
Read more
Azure is the preferred platform to build mission-critical and secure apps. This book provides comprehensive coverage of essential Azure products, services, and solutions vital for every solution architect's success. Elevate your knowledge and master the critical components of Azure to excel in your role with Azure Architecture Explained.
Read more
Sep 2023 14 hours 52 minutes
Pentesting Active Directory and Windows-based Infrastructure
Pentesting Active Directory and Windows-based Infrastructure
Read more
This practical guide helps you explore the pentesting of Microsoft infrastructure in detail, and enhances your offensive skillset by showing you the different ways to perform security assessment. This book will help blue teamers and IT engineers get up to speed with possible security issues they may encounter in their Windows environments.
Read more
Nov 2023 12 hours 0 minutes
Practical Ansible
Practical Ansible
Read more
In Practical Ansible, you'll work with the latest release of Ansible and learn to solve complex issues quickly with the help of task-oriented scenarios. You'll start by installing and configuring Ansible to automate monotonous and repetitive IT tasks and get to grips with concepts such as playbooks, inventories, plugins, collections, and network modules.
Read more
Sep 2023 14 hours 0 minutes
Windows 11 for Enterprise Administrators
Windows 11 for Enterprise Administrators
Read more
Microsoft’s launch of Windows 11 is a step toward satisfying the enterprise administrator’s needs for better management and enhanced user experience customization. This book provides the enterprise administrator with the knowledge needed to fully utilize the advanced feature set of Windows 11 Enterprise.
Read more
Oct 2023 9 hours 32 minutes
The Linux DevOps Handbook
The Linux DevOps Handbook
Read more
This book is for software and IT professionals seeking knowledge on Linux systems and DevOps practices. This book will provide you with guidance and tools to learn and gain proficiency in managing Linux-based infrastructures and knowledge of DevOps.
Read more
Nov 2023 14 hours 16 minutes
Right arrow icon