SQL Server 2019 Revealed
SQL Server 2019 Revealed

Author: Bob Ward

Publisher: Apress

Published: 2019-10-18

Total Pages: 435

ISBN-13: 1484254198

DOWNLOAD EBOOK

Get up to speed on the game-changing developments in SQL Server 2019. No longer just a database engine, SQL Server 2019 is cutting edge with support for machine learning (ML), big data analytics, Linux, containers, Kubernetes, Java, and data virtualization to Azure. This is not a book on traditional database administration for SQL Server. It focuses on all that is new for one of the most successful modernized data platforms in the industry. It is a book for data professionals who already know the fundamentals of SQL Server and want to up their game by building their skills in some of the hottest new areas in technology. SQL Server 2019 Revealed begins with a look at the project's team goal to integrate the world of big data with SQL Server into a major product release. The book then dives into the details of key new capabilities in SQL Server 2019 using a “learn by example” approach for Intelligent Performance, security, mission-critical availability, and features for the modern developer. Also covered are enhancements to SQL Server 2019 for Linux and gain a comprehensive look at SQL Server using containers and Kubernetes clusters. The book concludes by showing you how to virtualize your data access with Polybase to Oracle, MongoDB, Hadoop, and Azure, allowing you to reduce the need for expensive extract, transform, and load (ETL) applications. You will then learn how to take your knowledge of containers, Kubernetes, and Polybase to build a comprehensive solution called Big Data Clusters, which is a marquee feature of 2019. You will also learn how to gain access to Spark, SQL Server, and HDFS to build intelligence over your own data lake and deploy end-to-end machine learning applications. What You Will LearnImplement Big Data Clusters with SQL Server, Spark, and HDFS Create a Data Hub with connections to Oracle, Azure, Hadoop, and other sourcesCombine SQL and Spark to build a machine learning platform for AI applicationsBoost your performance with no application changes using Intelligent PerformanceIncrease security of your SQL Server through Secure Enclaves and Data ClassificationMaximize database uptime through online indexing and Accelerated Database RecoveryBuild new modern applications with Graph, ML Services, and T-SQL Extensibility with JavaImprove your ability to deploy SQL Server on Linux Gain in-depth knowledge to run SQL Server with containers and KubernetesKnow all the new database engine features for performance, usability, and diagnosticsUse the latest tools and methods to migrate your database to SQL Server 2019Apply your knowledge of SQL Server 2019 to Azure Who This Book Is For IT professionals and developers who understand the fundamentals of SQL Server and wish to focus on learning about the new, modern capabilities of SQL Server 2019. The book is for those who want to learn about SQL Server 2019 and the new Big Data Clusters and AI feature set, support for machine learning and Java, how to run SQL Server with containers and Kubernetes, and increased capabilities around Intelligent Performance, advanced security, and high availability.

Hands-On Data Warehousing with Azure Data Factory
Hands-On Data Warehousing with Azure Data Factory

Author: Christian Coté

Publisher: Packt Publishing Ltd

Published: 2018-05-31

Total Pages: 277

ISBN-13: 1789130093

DOWNLOAD EBOOK

Leverage the power of Microsoft Azure Data Factory v2 to build hybrid data solutions Key Features Combine the power of Azure Data Factory v2 and SQL Server Integration Services Design and enhance performance and scalability of a modern ETL hybrid solution Interact with the loaded data in data warehouse and data lake using Power BI Book Description ETL is one of the essential techniques in data processing. Given data is everywhere, ETL will always be the vital process to handle data from different sources. Hands-On Data Warehousing with Azure Data Factory starts with the basic concepts of data warehousing and ETL process. You will learn how Azure Data Factory and SSIS can be used to understand the key components of an ETL solution. You will go through different services offered by Azure that can be used by ADF and SSIS, such as Azure Data Lake Analytics, Machine Learning and Databrick’s Spark with the help of practical examples. You will explore how to design and implement ETL hybrid solutions using different integration services with a step-by-step approach. Once you get to grips with all this, you will use Power BI to interact with data coming from different sources in order to reveal valuable insights. By the end of this book, you will not only learn how to build your own ETL solutions but also address the key challenges that are faced while building them. What you will learn Understand the key components of an ETL solution using Azure Data Factory and Integration Services Design the architecture of a modern ETL hybrid solution Implement ETL solutions for both on-premises and Azure data Improve the performance and scalability of your ETL solution Gain thorough knowledge of new capabilities and features added to Azure Data Factory and Integration Services Who this book is for This book is for you if you are a software professional who develops and implements ETL solutions using Microsoft SQL Server or Azure cloud. It will be an added advantage if you are a software engineer, DW/ETL architect, or ETL developer, and know how to create a new ETL implementation or enhance an existing one with ADF or SSIS.

Hands-On Machine Learning with Azure
Hands-On Machine Learning with Azure

Author: Thomas K Abraham

Publisher: Packt Publishing Ltd

Published: 2018-10-31

Total Pages: 331

ISBN-13: 1789130271

DOWNLOAD EBOOK

Implement machine learning, cognitive services, and artificial intelligence solutions by leveraging Azure cloud technologies Key FeaturesLearn advanced concepts in Azure ML and the Cortana Intelligence Suite architectureExplore ML Server using SQL Server and HDInsight capabilitiesImplement various tools in Azure to build and deploy machine learning modelsBook Description Implementing Machine learning (ML) and Artificial Intelligence (AI) in the cloud had not been possible earlier due to the lack of processing power and storage. However, Azure has created ML and AI services that are easy to implement in the cloud. Hands-On Machine Learning with Azure teaches you how to perform advanced ML projects in the cloud in a cost-effective way. The book begins by covering the benefits of ML and AI in the cloud. You will then explore Microsoft’s Team Data Science Process to establish a repeatable process for successful AI development and implementation. You will also gain an understanding of AI technologies available in Azure and the Cognitive Services APIs to integrate them into bot applications. This book lets you explore prebuilt templates with Azure Machine Learning Studio and build a model using canned algorithms that can be deployed as web services. The book then takes you through a preconfigured series of virtual machines in Azure targeted at AI development scenarios. You will get to grips with the ML Server and its capabilities in SQL and HDInsight. In the concluding chapters, you’ll integrate patterns with other non-AI services in Azure. By the end of this book, you will be fully equipped to implement smart cognitive actions in your models. What you will learnDiscover the benefits of leveraging the cloud for ML and AIUse Cognitive Services APIs to build intelligent botsBuild a model using canned algorithms from Microsoft and deploy it as a web serviceDeploy virtual machines in AI development scenariosApply R, Python, SQL Server, and Spark in AzureBuild and deploy deep learning solutions with CNTK, MMLSpark, and TensorFlowImplement model retraining in IoT, Streaming, and Blockchain solutionsExplore best practices for integrating ML and AI functions with ADLA and logic appsWho this book is for If you are a data scientist or developer familiar with Azure ML and cognitive services and want to create smart models and make sense of data in the cloud, this book is for you. You’ll also find this book useful if you want to bring powerful machine learning services into your cloud applications. Some experience with data manipulation and processing, using languages like SQL, Python, and R, will aid in understanding the concepts covered in this book

Azure Data Scientist Associate Certification Guide
Azure Data Scientist Associate Certification Guide

Author: Andreas Botsikas

Publisher: Packt Publishing Ltd

Published: 2021-12-03

Total Pages: 448

ISBN-13: 1800561261

DOWNLOAD EBOOK

Develop the skills you need to run machine learning workloads in Azure and pass the DP-100 exam with ease Key FeaturesCreate end-to-end machine learning training pipelines, with or without codeTrack experiment progress using the cloud-based MLflow-compatible process of Azure ML servicesOperationalize your machine learning models by creating batch and real-time endpointsBook Description The Azure Data Scientist Associate Certification Guide helps you acquire practical knowledge for machine learning experimentation on Azure. It covers everything you need to pass the DP-100 exam and become a certified Azure Data Scientist Associate. Starting with an introduction to data science, you'll learn the terminology that will be used throughout the book and then move on to the Azure Machine Learning (Azure ML) workspace. You'll discover the studio interface and manage various components, such as data stores and compute clusters. Next, the book focuses on no-code and low-code experimentation, and shows you how to use the Automated ML wizard to locate and deploy optimal models for your dataset. You'll also learn how to run end-to-end data science experiments using the designer provided in Azure ML Studio. You'll then explore the Azure ML Software Development Kit (SDK) for Python and advance to creating experiments and publishing models using code. The book also guides you in optimizing your model's hyperparameters using Hyperdrive before demonstrating how to use responsible AI tools to interpret and debug your models. Once you have a trained model, you'll learn to operationalize it for batch or real-time inferences and monitor it in production. By the end of this Azure certification study guide, you'll have gained the knowledge and the practical skills required to pass the DP-100 exam. What you will learnCreate a working environment for data science workloads on AzureRun data experiments using Azure Machine Learning servicesCreate training and inference pipelines using the designer or codeDiscover the best model for your dataset using Automated MLUse hyperparameter tuning to optimize trained modelsDeploy, use, and monitor models in productionInterpret the predictions of a trained modelWho this book is for This book is for developers who want to infuse their applications with AI capabilities and data scientists looking to scale their machine learning experiments in the Azure cloud. Basic knowledge of Python is needed to follow the code samples used in the book. Some experience in training machine learning models in Python using common frameworks like scikit-learn will help you understand the content more easily.

ETL with Azure Cookbook
ETL with Azure Cookbook

Author: Christian Coté

Publisher: Packt Publishing Ltd

Published: 2020-09-30

Total Pages: 446

ISBN-13: 1800202857

DOWNLOAD EBOOK

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.

Hands-On Cloud Solutions with Azure
Hands-On Cloud Solutions with Azure

Author: Greg Leonardo

Publisher: Packt Publishing Ltd

Published: 2018-10-31

Total Pages: 214

ISBN-13: 1786460203

DOWNLOAD EBOOK

Design effective Azure architecture and transform your IT business solutions Key FeaturesDevelop a resilient and robust cloud environmentDeploy and manage cost-effective and highly available solutions on your public cloudDesign and implement enterprise-level cloud solutionsBook Description Azure provides cloud-based solutions to support your business demands. Building and running solutions on Azure will help your business maximize the return on investment and minimize the total cost of ownership. Hands-On Cloud Solutions with Azure focuses on addressing the architectural decisions that usually arise when you design or migrate a solution to Microsoft Azure. You will start by designing the building blocks of infrastructure solution on Azure, such as Azure compute, storage, and networking, followed by exploring the database options it offers. You will get to grips with designing scalable web and mobile solutions and understand where to host your Active Directory and Identity Solution. Moving on, you’ll learn how to extend DevOps to Azure. You will also beneft from some exciting services that enable extremely smooth operations and streamlined DevOps between on-premises and cloud. The book will help you to design a secure environment for your solution, on both the Cloud and hybrid. Toward the end, you’ll see how to manage and monitor cloud and hybrid solutions. By the end of this book, you will be armed with all the tools and knowledge you need to properly plan and design your solutions on Azure, whether it’s for a brand new project or migration project. What you will learnGet started with Azure by understanding tenants, subs, and resource groupsDecide whether to “lift and shift” or migrate appsPlan and architect solutions in AzureBuild ARM templates for Azure resourcesDevelop and deploy solutions in AzureUnderstand how to monitor and support your application with AzureMake your life easier with Azure best practices and tipsWho this book is for If you’re an IT consultant, developer, or solutions architect looking to design effective solutions for your organization, this book is for you. Some knowledge of cloud computing will assist with understanding the key concepts covered in this book.

Hands-On Azure Data Platform
Hands-On Azure Data Platform

Author: Sagar Lad

Publisher: BPB Publications

Published: 2022-02-10

Total Pages: 364

ISBN-13: 9355510306

DOWNLOAD EBOOK

Plan, build, deploy, and monitor data solutions on Azure KEY FEATURES ● Work with PostgreSQL, MySQL, and CosmosDB databases on Microsoft Azure. ● Work with whole data architecture, leverage Azure Storage, Azure Synapse, and Azure Data Lake. ● Data integration strategies with Azure Data Factory and Data Bricks. DESCRIPTION 'Hands-On Azure Data Platform' helps readers get a fundamental understanding of the Database, Data Warehouse, and Data Lake and their management on the Azure Data Platform. The book describes how to work efficiently with Relational and Non-Relational Databases, Azure Synapse Analytics, and Azure Data Lake. The readers will use Azure Databricks and Azure Data Factory to experience data processing and transformation. The book delves deeply into topics like continuous integration, continuous delivery, and the use of Azure DevOps. The book focuses on the integration of Azure DevOps with CI/CD pipelines for data ops solutions. The book teaches readers how to migrate data from an on-premises system or another cloud service provider to Azure. After reading the book, readers will develop end-to-end data solutions using the Azure data platform. Additionally, data engineers and ETL developers can streamline their ETL operations using various efficient Azure services. WHAT YOU WILL LEARN ● In-depth knowledge of the principles of the data warehouse and the data lake. ● Acquaint yourself with Azure Storage Files, Blobs, and Queues. ● Create relational databases on the Azure platform using SQL, PostgreSQL, and MySQL. ● With Cosmos DB, you can create extremely scalable databases and data warehouses. ● Utilize Azure Databricks and Data Factory to develop data integration solutions. WHO THIS BOOK IS FOR This book is designed for big data engineers, data architects, and cloud engineers who want to understand how to use the Azure Data Platform to build enterprise-grade solutions. Learning about databases and the Azure Data Platform would be helpful but not necessary. TABLE OF CONTENTS 1. Getting Started with the Azure Data Platform 2. Working with Relational Databases on Azure 3. Working with Azure Synapse Analytics 4. Working with Azure Data Lake 5. Working with Azure Cosmos DB 6. Working with Azure Databricks 7. Working with Azure Data Factory 8. DevOps with the Azure Data Platform 9. Planning and Migrating On-Premises Azure Workloads to the Azure Data platform 10. Design and Implement Data Solutions on Azure

Hands-On Azure for Developers
Hands-On Azure for Developers

Author: Kamil Mrzygłód

Publisher: Packt Publishing Ltd

Published: 2018-11-30

Total Pages: 598

ISBN-13: 1789349494

DOWNLOAD EBOOK

Gain practical skills with Azure and understand how to start developing scalable and easy-to-maintain cloud applications Key FeaturesGet up and running with the development aspects of Azure cloudBuild fault-tolerant and scalable applications on AzureA practical, developer-centric guide for Azure developersBook Description Microsoft Azure is one of the fastest growing public cloud service providers in the market currently, and also holds the second highest market share after AWS. Azure has a sophisticated set of services that will help you build fault-tolerant and scalable cloud-based applications. Hands-On Azure for Developers will take you on a journey through multiple PaaS services available in Azure, including App Services, Functions, and Service Fabric, and explain in detail how to build a complete and reliable system with ease. You will learn about how to maximize your skills when building cloud-based solutions leveraging different SQL/NoSQL databases, serverless and messaging components, and even search engines such as Azure Search. In the concluding chapters, this book covers more advanced scenarios such as scalability best practices, serving static content with Azure CDN, and distributing loads with Azure Traffic Manager. By the end of the book, you will be able to build modern applications on the Azure cloud using the most popular and promising technologies, which will help make your solutions reliable, stable, and efficient. What you will learnImplement serverless components such as Azure functions and logic appsIntegrate applications with available storages and containersUnderstand messaging components, including Azure Event Hubs and Azure Queue StorageGain an understanding of Application Insights and other proper monitoring solutionsStore your data with services such as Azure SQL and Azure Data Lake StorageDevelop fast and scalable cloud applicationsWho this book is for Hands-On Azure for Developers is for developers who want to build highly scalable cloud-based applications on Azure. Prior knowledge of Azure services will be an added advantage.

Microsoft Azure Essentials - Fundamentals of Azure
Microsoft Azure Essentials - Fundamentals of Azure

Author: Michael Collier

Publisher: Microsoft Press

Published: 2015-01-29

Total Pages: 400

ISBN-13: 0735697302

DOWNLOAD EBOOK

Microsoft Azure Essentials from Microsoft Press is a series of free ebooks designed to help you advance your technical skills with Microsoft Azure. The first ebook in the series, Microsoft Azure Essentials: Fundamentals of Azure, introduces developers and IT professionals to the wide range of capabilities in Azure. The authors - both Microsoft MVPs in Azure - present both conceptual and how-to content for key areas, including: Azure Websites and Azure Cloud Services Azure Virtual Machines Azure Storage Azure Virtual Networks Databases Azure Active Directory Management tools Business scenarios Watch Microsoft Press’s blog and Twitter (@MicrosoftPress) to learn about other free ebooks in the “Microsoft Azure Essentials” series.

Data Modeling for Azure Data Services
Data Modeling for Azure Data Services

Author: Peter ter Braake

Publisher: Packt Publishing Ltd

Published: 2021-07-30

Total Pages: 428

ISBN-13: 1801076707

DOWNLOAD EBOOK

Choose the right Azure data service and correct model design for successful implementation of your data model with the help of this hands-on guide Key FeaturesDesign a cost-effective, performant, and scalable database in AzureChoose and implement the most suitable design for a databaseDiscover how your database can scale with growing data volumes, concurrent users, and query complexityBook Description Data is at the heart of all applications and forms the foundation of modern data-driven businesses. With the multitude of data-related use cases and the availability of different data services, choosing the right service and implementing the right design becomes paramount to successful implementation. Data Modeling for Azure Data Services starts with an introduction to databases, entity analysis, and normalizing data. The book then shows you how to design a NoSQL database for optimal performance and scalability and covers how to provision and implement Azure SQL DB, Azure Cosmos DB, and Azure Synapse SQL Pool. As you progress through the chapters, you'll learn about data analytics, Azure Data Lake, and Azure SQL Data Warehouse and explore dimensional modeling, data vault modeling, along with designing and implementing a Data Lake using Azure Storage. You'll also learn how to implement ETL with Azure Data Factory. By the end of this book, you'll have a solid understanding of which Azure data services are the best fit for your model and how to implement the best design for your solution. What you will learnModel relational database using normalization, dimensional, or Data Vault modelingProvision and implement Azure SQL DB and Azure Synapse SQL PoolsDiscover how to model a Data Lake and implement it using Azure StorageModel a NoSQL database and provision and implement an Azure Cosmos DBUse Azure Data Factory to implement ETL/ELT processesCreate a star schema model using dimensional modelingWho this book is for This book is for business intelligence developers and consultants who work on (modern) cloud data warehousing and design and implement databases. Beginner-level knowledge of cloud data management is expected.