SQL Server Big Data Clusters: Data Virtualization, Data Lake, and AI Platform, Weissman Benjamin, Van De Laar Enrico
Автор: Sarkar Debarchan Название: Mastering SQL Server 2014 Data Mining ISBN: 184968894X ISBN-13(EAN): 9781849688949 Издательство: Неизвестно Рейтинг: Цена: 45970.00 T Наличие на складе: Нет в наличии.
Автор: Weissman, Benjamin Van De Laar, Enrico Название: Sql server big data clusters revealed ISBN: 1484251091 ISBN-13(EAN): 9781484251096 Издательство: Springer Рейтинг: Цена: 26080.00 T Наличие на складе: Невозможна поставка. Описание: Get a head-start on learning one of SQL Server 2019’s latest and most impactful features—Big Data Clusters—that combines large volumes of non-relational data for analysis along with data stored relationally inside a SQL Server database. This book provides a first look at Big Data Clusters based upon SQL Server 2019 Release Candidate 1. Start now and get a jump on your competition in learning this important new feature.
Big Data Clusters is a feature set covering data virtualization, distributed computing, and relational databases and provides a complete AI platform across the entire cluster environment. This book shows you how to deploy, manage, and use Big Data Clusters. For example, you will learn how to combine data stored on the HDFS file system together with data stored inside the SQL Server instances that make up the Big Data Cluster.
Filled with clear examples and use cases, this book provides everything necessary to get started working with Big Data Clusters in SQL Server 2019 using Release Candidate 1. You will learn about the architectural foundations that are made up from Kubernetes, Spark, HDFS, and SQL Server on Linux. You then are shown how to configure and deploy Big Data Clusters in on-premises environments or in the cloud. Next, you are taught about querying. You will learn to write queries in Transact-SQL—taking advantage of skills you have honed for years—and with those queries you will be able to examine and analyze data from a wide variety of sources such as Apache Spark.
Through the theoretical foundation provided in this book and easy-to-follow example scripts and notebooks, you will be ready to use and unveil the full potential of SQL Server 2019: combining different types of data spread across widely disparate sources into a single view that is useful for business intelligence and machine learning analysis.
What You Will Learn
Install, manage, and troubleshoot Big Data Clusters in cloud or on-premise environmentsAnalyze large volumes of data directly from SQL Server and/or Apache SparkManage data stored in HDFS from SQL Server as if it were relational dataImplement advanced analytics solutions through machine learning and AIExpose different data sources as a single logical source using data virtualization
Who This Book Is For
For data engineers, data scientists, data architects, and database administrators who want to employ data virtualization and big data analytics in their environment
Автор: Kashel, Jeremy Kent, Tim Bullerwell, Martyn Название: Microsoft sql server 2008 r2 master data services ISBN: 1849680507 ISBN-13(EAN): 9781849680509 Издательство: Неизвестно Рейтинг: Цена: 74780.00 T Наличие на складе: Есть у поставщика Поставка под заказ.
Автор: Graham Tyler, Selhorn Suzanne, Graham Название: Microsoft SQL Server 2012 Master Data Services 2/E ISBN: 0071797858 ISBN-13(EAN): 9780071797856 Издательство: McGraw-Hill Рейтинг: Цена: 67490.00 T Наличие на складе: Есть у поставщика Поставка под заказ. Описание: Written by the technologists behind the software, this is the definitive resource for working with Microsoft Master Data Services-the Master Data Management tool included as part of SQL Server 2012.
Автор: Leonard, Andy Bradshaw, Kent Название: Sql server data automation through frameworks ISBN: 1484262123 ISBN-13(EAN): 9781484262122 Издательство: Springer Рейтинг: Цена: 41920.00 T Наличие на складе: Есть у поставщика Поставка под заказ. Описание: Intermediate-Advanced user level
Автор: Koesmarno Julie, Kastrun Tomaz Название: SQL Server 2017 Machine Learning Services with R: Data exploration, modeling, and advanced analytics ISBN: 1787283577 ISBN-13(EAN): 9781787283572 Издательство: Неизвестно Рейтинг: Цена: 53940.00 T Наличие на складе: Есть у поставщика Поставка под заказ. Описание: With integrated R Services within SQL Server 2017, developers and data scientists can now benefit from the integrated, effective, efficient and more streamlined analytics environment. In this book, you will understand how to leverage the capabilities of R Services in SQL Server 2017. This short yet effective guide will help you get familiar ...
Автор: Aspin Adam Название: SQL Server 2012 Data Integration Recipes: Solutions for Inte ISBN: 1430247916 ISBN-13(EAN): 9781430247913 Издательство: Springer Рейтинг: Цена: 55890.00 T Наличие на складе: Есть у поставщика Поставка под заказ. Описание:
SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.
What DBA or developer isn't faced with the need to move data back and forth? Author Adam Aspin brings 10 years of extensive ETL experience involving SQL Server, and especially satellite products such as Data Transformation Services and SQL Server Integration Services. Extensive coverage is given to Integration Services, Microsoft's flagship tool for data integration in SQL Server environments. Coverage is also given to the broader range of tools such as OPENDATASOURCE, linked servers, OPENROWSET, Migration Assistant for Access, BCP Import, and BULK INSERT just to name a few. If you're looking for a resource to cover data integration and ETL across the gamut of Microsoft's SQL Server toolset, SQL Server 2012 Data Integration Recipes is the one book that will meet your needs.
Provides practical and proven solutions towards creating resilient ETL environments
Clearly answers the tough questions which professionals ask
Goes beyond the tools to a thorough discussion of the underlying techniques
Covers the gamut of data integration, beyond just SSIS
Includes example databases and files to allow readers to test the recipes
Автор: Mark Chaffin Название: Professional SQL Server 2000 DTS (Data Transformation Services) ISBN: 0764543687 ISBN-13(EAN): 9780764543685 Издательство: Wiley Рейтинг: Цена: 38010.00 T Наличие на складе: Поставка под заказ. Описание: What is this book about? (DTS) Data Transformation Services helps you create a transactional system to load and transform your data from and to a wide variety of sources. SQL Server DTS was introduced in the release of SQL Server 7.0; however, SQL Server 2000 sees the functionality and power of this outstanding and incredibly useful tool greatly increased. DTS can be used to maximum effect in data--driven applications, offering rapid and effective solutions to a wide range of common problems. Professional SQL Server 2000 DTS provides a complete introduction to DTS fundamentals and architecture before exploring the more complex data transformations involved in moving data between different servers, applications, and providers. The book then focuses on DTS programming via the DTS object model, enabling developers to incorporate custom transformations and reporting capabilities into their applications. Advanced topics are explained including error handling, dynamic data loading, and data warehouses. With code and case studies, this book gives the reader a complete picture of how to use DTS to its fullest potential. What does this book cover? Here are just a few of the things you'll find covered in this book: A detailed explanation of the seventeen principal DTS tasks Connecting to, querying, and converting heterogeneous data Dynamic configuration of your DTS packages Enhancing your DTS packagwith VBScript and Visual Basic Writing your own custom tasks Using DTS in a data--warehousing environment Employing DTS in other applications Who is this book for? This book is principally aimed at database programmers and administrators who have a working knowledge of SQL Server, and who wish to take DTS beyond its most basic level and tailor it to their needs. It will also appeal to managers and project managers who want to gain an understanding of DTS and how it could benefit their businesses.
Автор: Diaz Francesco, Freato Roberto Название: Cloud Data Design, Orchestration, and Management Using Microsoft Azure: Master and Design a Solution Leveraging the Azure Data Platform ISBN: 1484236149 ISBN-13(EAN): 9781484236147 Издательство: Springer Рейтинг: Цена: 60550.00 T Наличие на складе: Есть у поставщика Поставка под заказ. Описание: 1 Overview of data architecture on Microsoft Azure Introduction Technologies: everyone touched in the book plus some other edge technologies just mentioned. We explain the scenarios of the book.This chapter will be written during the whole process, updating it with the relevant content of the scenarios developed in the chapters. 2 Working with Relational DBs on Azure Relational DBs scenarios Technologies: VMs, Backup, Storage, SQL Server DR and GEO-DR, (Oracle, MySQL)We would like to cover the best practices to deploy standard RDBMSs while using Azure VMs and networking. 3 Working with Azure SQL Database Azure DB scenarios Technologies: Azure SQL DB, Stretch DB, Database Pools, Sharding data, Migration from other RDBMSs to Azure SQL DBThis chapter is about the SQL Database PaaS, with some tricks for advanced usage. We cover the services and the connected services, how to scale with relational DBs and how to write multi-tenant applications. 4 Working with NoSQL alternatives NoSQL scenarios Technologies: Storage, DocumentDB, Redis, Azure SearchThis chapter enforces the polyglot persistence idea, where different technologies and data sources address different needs. The NoSQL alternatives can fill the gap of modern applications in terms of performance and feature set. 5 Orchestrate data with Azure Data Factory Integration scenarios Technologies: Azure Data FactoryIn this chapter we talk about integration of different data sources and advanced pipelines of data transformation. We explore some scenarios to lower the complexity of the Data Factory service and we see how to setup existing solutions to fit it. 6 Advanced analysis with Azure Data Lake Analysis scenarios Technologies: Data Lake Store/Analytics, U-SQLThis is the first chapter about ingestion of big data. This is focused on ingestion of native data, to be prepared, enriched and evaluated/analyzed in a second step. 7 Real-time Ingestion, Processing and Prediction Real-time scenarios Technologies: Machine Learning, Stream Analytics, Event HubThis is instead focused in ingestion of well-known and structured data with the aim to process it in real-time. In addition a step of prediction is added to react (in real time too) to certain events. 8 Working with Big Data with Azure Batch and Map/Reduce Big data scenarios Technologies: HDInsight, Hadoop, Spark, R Server, Storm, Azure BatchThis is the last chapter about Big Data, exploring the industry standard to perform data operations, while executing those engines on Azure. 9 APPENDIX (tbd yet, adding some of the topics below to one of the other chapter still has to be defined) Other Technologies: Azure Analysis Services (chapter 3?), Power BI (chapter 6?), Azure SQL DataWarehouse (chapter 6?), Azure Data Catalog (chapter 5?)Those technologies should fit the existing chapters, but we do not know where they best fit at the time being.
