› › Azure Cookbook

ETL with Azure Cookbook

Author : Christian Coté

Publisher : Packt Publishing Ltd

Page : 446 pages

File Size : 20,96 MB

Release : 2020-09-30

Category : Computers

ISBN : 1800202857

Get eBook

Book Description

Explore the latest Azure ETL techniques both on-premises and in the cloud using Azure services such as SQL Server Integration Services (SSIS), Azure Data Factory, and Azure Databricks Key FeaturesUnderstand the key components of an ETL solution using Azure Integration ServicesDiscover the common and not-so-common challenges faced while creating modern and scalable ETL solutionsProgram and extend your packages to develop efficient data integration and data transformation solutionsBook Description ETL is one of the most common and tedious procedures for moving and processing data from one database to another. With the help of this book, you will be able to speed up the process by designing effective ETL solutions using the Azure services available for handling and transforming any data to suit your requirements. With this cookbook, you’ll become well versed in all the features of SQL Server Integration Services (SSIS) to perform data migration and ETL tasks that integrate with Azure. You’ll learn how to transform data in Azure and understand how legacy systems perform ETL on-premises using SSIS. Later chapters will get you up to speed with connecting and retrieving data from SQL Server 2019 Big Data Clusters, and even show you how to extend and customize the SSIS toolbox using custom-developed tasks and transforms. This ETL book also contains practical recipes for moving and transforming data with Azure services, such as Data Factory and Azure Databricks, and lets you explore various options for migrating SSIS packages to Azure. Toward the end, you’ll find out how to profile data in the cloud and automate service creation with Business Intelligence Markup Language (BIML). By the end of this book, you’ll have developed the skills you need to create and automate ETL solutions on-premises as well as in Azure. What you will learnExplore ETL and how it is different from ELTMove and transform various data sources with Azure ETL and ELT servicesUse SSIS 2019 with Azure HDInsight clustersDiscover how to query SQL Server 2019 Big Data Clusters hosted in AzureMigrate SSIS solutions to Azure and solve key challenges associated with itUnderstand why data profiling is crucial and how to implement it in Azure DatabricksGet to grips with BIML and learn how it applies to SSIS and Azure Data Factory solutionsWho this book is for This book is for data warehouse architects, ETL developers, or anyone who wants to build scalable ETL applications in Azure. Those looking to extend their existing on-premise ETL applications to use big data and a variety of Azure services or others interested in migrating existing on-premise solutions to the Azure cloud platform will also find the book useful. Familiarity with SQL Server services is necessary to get the most out of this book.



Azure Cookbook

Author : Massimo Bonanni

Publisher : BPB Publications

Page : 732 pages

File Size : 37,87 MB

Release : 2024-10-17

Category : Computers

ISBN : 9365890195

Get eBook

Book Description

DESCRIPTION "Azure Cookbook" is a practical guide designed to help developers, system administrators, and cloud architects master Microsoft Azure through hands-on solutions. This book offers step-by-step recipes for tackling real-world challenges using Azure’s vast range of services. This book covers many important topics related to Azure, such as storage, networking, virtual machines, containers, and application development. It offers practical tips and step-by-step instructions for creating and managing secure Azure applications. You will learn about various Azure services, including Azure Storage, Virtual Networks, App Service, and Azure Security Center. Whether you are new to Azure or have some experience, this guide will help you gain the skills needed to use Azure effectively for your cloud computing projects. With this book, you will not only enhance your Azure skills but also apply them directly to your job roles. By mastering the cloud, you will be equipped to design, deploy, and manage robust, scalable solutions-making you an invaluable asset in today’s cloud-driven world. KEY FEATURES ● Step-by-step Azure recipes for real-world cloud solutions mastery. ● Troubleshoot Azure issues with expert tips and hands-on guidance. ● Boost skills with practical examples from core to advanced services. WHAT YOU WILL LEARN ● Deploying and managing Azure Virtual Machines, Networks, and Storage solutions. ● Automating cloud infrastructure using Bicep, ARM templates, and PowerShell. ● Implementing secure, scalable, and cost-effective cloud architectures. ● Building containerized apps with Azure Kubernetes Service (AKS). ● Creating serverless solutions using Azure Functions and Logic Apps. ● Troubleshooting Azure issues and optimizing performance for production workloads. WHO THIS BOOK IS FOR This book is for developers, cloud engineers, system administrators, and architects looking to deepen their understanding of Microsoft Azure and want to learn how to effectively utilize Azure for their cloud computing needs. TABLE OF CONTENTS 1. Azure Storage: Secret Ingredient for Your Data Solutions 2. Azure Networking: Spice up Your Connectivity 3. Azure Virtual Machines: How to Bake Them 4. Azure App Service: How to Serve Your Web Apps with Style 5. Containers in Azure: How to Prepare Your Cloud Dishes 6. ARM, Bicep, DevOps: Crafting Azure Resources with Ease 7. How to Automate Your Cloud Kitchen 8. Azure Security: Managing Kitchen Access and Permissions 9. Azure Compliance: Ensuring Your Kitchen Meets Standards 10. Azure Governance: How to Take Care of Your Kitchen 11. Azure Monitoring: Keep an Eye on Your Dishes



Azure Data Engineering Cookbook

Author : Ahmad Osama

Publisher : Packt Publishing Ltd

Page : 455 pages

File Size : 33,11 MB

Release : 2021-04-05

Category : Computers

ISBN : 1800201540

Get eBook

Book Description

Over 90 recipes to help you orchestrate modern ETL/ELT workflows and perform analytics using Azure services more easily Key FeaturesBuild highly efficient ETL pipelines using the Microsoft Azure Data servicesCreate and execute real-time processing solutions using Azure Databricks, Azure Stream Analytics, and Azure Data ExplorerDesign and execute batch processing solutions using Azure Data FactoryBook Description Data engineering is one of the faster growing job areas as Data Engineers are the ones who ensure that the data is extracted, provisioned and the data is of the highest quality for data analysis. This book uses various Azure services to implement and maintain infrastructure to extract data from multiple sources, and then transform and load it for data analysis. It takes you through different techniques for performing big data engineering using Microsoft Azure Data services. It begins by showing you how Azure Blob storage can be used for storing large amounts of unstructured data and how to use it for orchestrating a data workflow. You'll then work with different Cosmos DB APIs and Azure SQL Database. Moving on, you'll discover how to provision an Azure Synapse database and find out how to ingest and analyze data in Azure Synapse. As you advance, you'll cover the design and implementation of batch processing solutions using Azure Data Factory, and understand how to manage, maintain, and secure Azure Data Factory pipelines. You'll also design and implement batch processing solutions using Azure Databricks and then manage and secure Azure Databricks clusters and jobs. In the concluding chapters, you'll learn how to process streaming data using Azure Stream Analytics and Data Explorer. By the end of this Azure book, you'll have gained the knowledge you need to be able to orchestrate batch and real-time ETL workflows in Microsoft Azure. What you will learnUse Azure Blob storage for storing large amounts of unstructured dataPerform CRUD operations on the Cosmos Table APIImplement elastic pools and business continuity with Azure SQL DatabaseIngest and analyze data using Azure Synapse AnalyticsDevelop Data Factory data flows to extract data from multiple sourcesManage, maintain, and secure Azure Data Factory pipelinesProcess streaming data using Azure Stream Analytics and Data ExplorerWho this book is for This book is for Data Engineers, Database administrators, Database developers, and extract, load, transform (ETL) developers looking to build expertise in Azure Data engineering using a recipe-based approach. Technical architects and database architects with experience in designing data or ETL applications either on-premise or on any other cloud vendor who wants to learn Azure Data engineering concepts will also find this book useful. Prior knowledge of Azure fundamentals and data engineering concepts is needed.



Azure Data Factory Cookbook

Author : Dmitry Anoshin

Publisher : Packt Publishing Ltd

Page : 383 pages

File Size : 20,41 MB

Release : 2020-12-24

Category : Computers

ISBN : 1800561024

Get eBook

Book Description

Solve real-world data problems and create data-driven workflows for easy data movement and processing at scale with Azure Data Factory Key FeaturesLearn how to load and transform data from various sources, both on-premises and on cloudUse Azure Data Factory’s visual environment to build and manage hybrid ETL pipelinesDiscover how to prepare, transform, process, and enrich data to generate key insightsBook Description Azure Data Factory (ADF) is a modern data integration tool available on Microsoft Azure. This Azure Data Factory Cookbook helps you get up and running by showing you how to create and execute your first job in ADF. You’ll learn how to branch and chain activities, create custom activities, and schedule pipelines. This book will help you to discover the benefits of cloud data warehousing, Azure Synapse Analytics, and Azure Data Lake Gen2 Storage, which are frequently used for big data analytics. With practical recipes, you’ll learn how to actively engage with analytical tools from Azure Data Services and leverage your on-premise infrastructure with cloud-native tools to get relevant business insights. As you advance, you’ll be able to integrate the most commonly used Azure Services into ADF and understand how Azure services can be useful in designing ETL pipelines. The book will take you through the common errors that you may encounter while working with ADF and show you how to use the Azure portal to monitor pipelines. You’ll also understand error messages and resolve problems in connectors and data flows with the debugging capabilities of ADF. By the end of this book, you’ll be able to use ADF as the main ETL and orchestration tool for your data warehouse or data platform projects. What you will learnCreate an orchestration and transformation job in ADFDevelop, execute, and monitor data flows using Azure SynapseCreate big data pipelines using Azure Data Lake and ADFBuild a machine learning app with Apache Spark and ADFMigrate on-premises SSIS jobs to ADFIntegrate ADF with commonly used Azure services such as Azure ML, Azure Logic Apps, and Azure FunctionsRun big data compute jobs within HDInsight and Azure DatabricksCopy data from AWS S3 and Google Cloud Storage to Azure Storage using ADF's built-in connectorsWho this book is for This book is for ETL developers, data warehouse and ETL architects, software professionals, and anyone who wants to learn about the common and not-so-common challenges faced while developing traditional and hybrid ETL solutions using Microsoft's Azure Data Factory. You’ll also find this book useful if you are looking for recipes to improve or enhance your existing ETL pipelines. Basic knowledge of data warehousing is expected.



Azure Databricks Cookbook

Author : Phani Raj

Publisher : Packt Publishing Ltd

Page : 452 pages

File Size : 42,28 MB

Release : 2021-09-17

Category : Computers

ISBN : 178961855X

Get eBook

Book Description

Get to grips with building and productionizing end-to-end big data solutions in Azure and learn best practices for working with large datasets Key FeaturesIntegrate with Azure Synapse Analytics, Cosmos DB, and Azure HDInsight Kafka Cluster to scale and analyze your projects and build pipelinesUse Databricks SQL to run ad hoc queries on your data lake and create dashboardsProductionize a solution using CI/CD for deploying notebooks and Azure Databricks Service to various environmentsBook Description Azure Databricks is a unified collaborative platform for performing scalable analytics in an interactive environment. The Azure Databricks Cookbook provides recipes to get hands-on with the analytics process, including ingesting data from various batch and streaming sources and building a modern data warehouse. The book starts by teaching you how to create an Azure Databricks instance within the Azure portal, Azure CLI, and ARM templates. You'll work through clusters in Databricks and explore recipes for ingesting data from sources, including files, databases, and streaming sources such as Apache Kafka and EventHub. The book will help you explore all the features supported by Azure Databricks for building powerful end-to-end data pipelines. You'll also find out how to build a modern data warehouse by using Delta tables and Azure Synapse Analytics. Later, you'll learn how to write ad hoc queries and extract meaningful insights from the data lake by creating visualizations and dashboards with Databricks SQL. Finally, you'll deploy and productionize a data pipeline as well as deploy notebooks and Azure Databricks service using continuous integration and continuous delivery (CI/CD). By the end of this Azure book, you'll be able to use Azure Databricks to streamline different processes involved in building data-driven apps. What you will learnRead and write data from and to various Azure resources and file formatsBuild a modern data warehouse with Delta Tables and Azure Synapse AnalyticsExplore jobs, stages, and tasks and see how Spark lazy evaluation worksHandle concurrent transactions and learn performance optimization in Delta tablesLearn Databricks SQL and create real-time dashboards in Databricks SQLIntegrate Azure DevOps for version control, deploying, and productionizing solutions with CI/CD pipelinesDiscover how to use RBAC and ACLs to restrict data accessBuild end-to-end data processing pipeline for near real-time data analyticsWho this book is for This recipe-based book is for data scientists, data engineers, big data professionals, and machine learning engineers who want to perform data analytics on their applications. Prior experience of working with Apache Spark and Azure is necessary to get the most out of this book.



Azure Cookbook

Author : Reza Salehi

Publisher : "O'Reilly Media, Inc."

Page : 332 pages

File Size : 11,28 MB

Release : 2023-06-22

Category : Computers

ISBN : 109813575X

Get eBook

Book Description

How do you deal with the problems you face when using Azure? This practical guide provides over 75 recipes to help you to work with common Azure issues in everyday scenarios. That includes key tasks like setting up permissions for a storage account, working with Cosmos DB APIs, managing Azure role-based access control, governing your Azure subscriptions using Azure Policy, and much more. Author Reza Salehi has assembled real-world recipes that enable you to grasp key Azure services and concepts quickly. Each recipe includes CLI scripts that you can execute in your own Azure account. Recipes also explain the approach and provide meaningful context. The solutions in this cookbook will take you beyond theory and help you understand Azure services in practice. You'll find recipes that let you: Store data in an Azure storage account or in a data lake Work with relational and nonrelational databases in Azure Manage role-based access control (RBAC) for Azure resources Safeguard secrets in Azure Key Vault Govern your Azure subscription using Azure Policy Use CLI code to construct your application or fix a particular problem



Azure DevOps Server 2019 Cookbook

Author : Tarun Arora

Publisher : Packt Publishing Ltd

Page : 445 pages

File Size : 12,10 MB

Release : 2019-05-03

Category : Computers

ISBN : 1788830148

Get eBook

Book Description

Over 70 recipes to effectively apply DevOps best practices and implement Agile, Git, CI-CD & Test automation using Azure DevOps Server (TFS) 2019 Key FeaturesLearn improving code quality using pull requests, branch policies, githooks and git branching designAccelerate the deployment of high quality software by automating build and releases using CI-CD Pipelines.Learn tried and tested techniques to automate database deployments, App Service & Function Deployments in Azure.Book Description Azure DevOps Server, previously known as Team Foundation Server (TFS), is a comprehensive on-premise DevOps toolset with a rich ecosystem of open source plugins. This book is your one stop guide to learn how to effectively use all of these Azure DevOps services to go from zero to DevOps. You will start by building high-quality scalable software targeting .NET, .NET core or Node.js applications. You will learn techniques that will help you to set up end-to-end traceability of your code changes from design through to release. Whether you are deploying software on-premise or in the cloud in App Service, Functions, or Azure VMs, this book will help you learn release management techniques to reduce release failures. Next, you will be able to secure application configuration by using Azure KeyVault. You will also learn how to create and release extensions to the Azure DevOps marketplace and reach million developer ecosystem for feedback. The working extension samples will allow you to iterate changes in your extensions easily and release updates to the marketplace quickly. By the end of this book, techniques provided in the book will help you break down the invisible silos between your software development teams. This will transform you from being a good software development team to an elite modern cross functional software development team. What you will learnSet up a team project for an Agile delivery team, importing requirements from ExcelPlan,track, and monitor progress using self updating boards, Sprint and Kanban boardsUnlock the features of Git by using branch policies, Git pull requests, forks, and Git hooksBuild and release .NET core, SQL and Node.js applications using Azure PipelineAutomate testing by integrating Microsoft and open source testing frameworksExtend Azure DevOps Server to a million developer ecosystemWho this book is for This book is for anyone looking to succeed with DevOps. The techniques in this book apply to all roles of the software development lifecycle including developers, testers, architects, configuration analysts, site reliability engineers and release managers. If you are a new user you’ll learn how to get started; if you are an experienced user you’ll learn how to launch your project into a modern and mature DevOps enabled software development team.



Microsoft Windows Azure Development Cookbook

Author : Neil Mackenzie

Publisher : Packt Publishing Ltd

Page : 647 pages

File Size : 20,65 MB

Release : 2011-08-05

Category : Computers

ISBN : 1849682232

Get eBook

Book Description

Over 80 advanced recipes for developing scalable services with the Windows Azure platform.



Programming Windows Azure

Author : Sriram Krishnan

Publisher : "O'Reilly Media, Inc."

Page : 371 pages

File Size : 28,75 MB

Release : 2010-05-07

Category : Computers

ISBN : 1449390609

Get eBook

Book Description

Learn the nuts and bolts of cloud computing with Windows Azure, Microsoft's new Internet services platform. Written by a key member of the product development team, this book shows you how to build, deploy, host, and manage applications using Windows Azure's programming model and essential storage services. Chapters in Programming Windows Azure are organized to reflect the platform's buffet of services. The book's first half focuses on how to write and host application code on Windows Azure, while the second half explains all of the options you have for storing and accessing data on the platform with high scalability and reliability. Lots of code samples and screenshots are available to help you along the way. Learn how to build applications using the Windows Azure toolset Discover how Windows Azure works under the hood, and learn the how and the why behind several features Choose to write application code in .NET or other languages such as C/C++, PHP, or Ruby Understand the various options for managing your service Get up to speed on Azure's storage services, including blobs, queues, and tables Build a secure backup system, and learn about cloud application security, cryptography, and performance



Terraform Cookbook

Author : Mikael Krief

Publisher : Packt Publishing Ltd

Page : 360 pages

File Size : 49,47 MB

Release : 2020-10-15

Category : Computers

ISBN : 1800209622

Get eBook

Book Description

Discover how to manage and scale your infrastructure using Infrastructure as Code (IaC) with Terraform Key Features Get up and running with the latest version of Terraform, v0.13 Design and manage infrastructure that can be shared, tested, modified, provisioned, and deployed Work through practical recipes to achieve zero-downtime deployment and scale your infrastructure effectively Book DescriptionHashiCorp Configuration Language (HCL) has changed how we define and provision a data center infrastructure with the launch of Terraform—one of the most popular and powerful products for building Infrastructure as Code. This practical guide will show you how to leverage HashiCorp's Terraform tool to manage a complex infrastructure with ease. Starting with recipes for setting up the environment, this book will gradually guide you in configuring, provisioning, collaborating, and building a multi-environment architecture. Unlike other books, you’ll also be able to explore recipes with real-world examples to provision your Azure infrastructure with Terraform. Once you’ve covered topics such as Azure Template, Azure CLI, Terraform configuration, and Terragrunt, you’ll delve into manual and automated testing with Terraform configurations. The next set of chapters will show you how to manage a balanced and efficient infrastructure and create reusable infrastructure with Terraform modules. Finally, you’ll explore the latest DevOps trends such as continuous integration and continuous delivery (CI/CD) and zero-downtime deployments. By the end of this book, you’ll have developed the skills you need to get the most value out of Terraform and manage your infrastructure effectively.What you will learn Understand how to install Terraform for local development Get to grips with writing Terraform configuration for infrastructure provisioning Use Terraform for advanced infrastructure use cases Understand how to write and use Terraform modules Discover how to use Terraform for Azure infrastructure provisioning Become well-versed in testing Terraform configuration Execute Terraform configuration in CI/CD pipelines Explore how to use Terraform Cloud Who this book is for This book is for developers, operators, and DevOps engineers looking to improve their workflow and use Infrastructure as Code. Experience with Microsoft Azure, Jenkins, shell scripting, and DevOps practices is required to get the most out of this Terraform book.