SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory

Leonard, Andy, Bradshaw, Kent

  • 出版商: Apress
  • 出版日期: 2020-10-18
  • 售價: $1,470
  • 貴賓價: 9.5$1,397
  • 語言: 英文
  • 頁數: 110
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484262123
  • ISBN-13: 9781484262122
  • 相關分類: Microsoft AzureMSSQLSQL
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

Learn to automate SQL Server operations using frameworks built from metadata-driven stored procedures and SQL Server Integration Services (SSIS). Bring all the power of Transact-SQL (T-SQL) and Microsoft .NET to bear on your repetitive data, data integration, and ETL processes. Do this for no added cost over what you've already spent on licensing SQL Server. The tools and methods from this book may be applied to on-premises and Azure SQL Server instances. The SSIS framework from this book works in Azure Data Factory (ADF) and provides DevOps personnel the ability to execute child packages outside a project--functionality not natively available in SSIS.
Frameworks not only reduce the time required to deliver enterprise functionality, but can also accelerate troubleshooting and problem resolution. You'll learn in this book how frameworks also improve code quality by using metadata to drive processes. Much of the work performed by data professionals can be classified as "drudge work"--tasks that are repetitive and template-based. The frameworks-based approach shown in this book helps you to avoid that drudgery by turning repetitive tasks into "one and done" operations. Frameworks as described in this book also support enterprise DevOps with built-in logging functionality.

What You Will Learn

  • Create a stored procedure framework to automate SQL process execution
  • Base your framework on a working system of stored procedures and execution logging
  • Create an SSIS framework to reduce the complexity of executing multiple SSIS packages
  • Deploy stored procedure and SSIS frameworks to Azure Data Factory environments in the cloud


Who This Book Is For
Database administrators and developers who are involved in enterprise data projects built around stored procedures and SQL Server Integration Services (SSIS). Readers should have a background in programming along with a desire to optimize their data efforts by implementing repeatable processes that support enterprise DevOps.

商品描述(中文翻譯)

學習使用基於元數據驅動的存儲過程和SQL Server Integration Services (SSIS) 框架來自動化SQL Server操作。將Transact-SQL (T-SQL) 和Microsoft .NET 的所有功能應用於重複的數據、數據集成和ETL過程中。這樣做不會增加你在SQL Server授權上已經花費的費用。本書中的工具和方法可應用於本地和Azure SQL Server實例。本書中的SSIS框架可在Azure Data Factory (ADF) 中使用,並為DevOps人員提供在項目之外執行子包的能力,這是SSIS本身不具備的功能。

框架不僅可以減少交付企業功能所需的時間,還可以加快故障排除和問題解決的速度。本書將向您展示,通過使用元數據來驅動流程,框架還可以提高代碼質量。數據專業人員所執行的大部分工作可以歸類為“苦工”-重複且基於模板的任務。本書中介紹的基於框架的方法可以將這些重複任務轉化為“一次性”操作,從而幫助您避免這種苦工。本書中描述的框架還支持企業DevOps,具有內置的日誌功能。

你將學到什麼


  • 創建一個存儲過程框架,以自動化SQL過程執行

  • 基於一個工作系統的存儲過程和執行日誌來構建框架

  • 創建一個SSIS框架,以減少執行多個SSIS包的複雜性

  • 在雲端部署存儲過程和SSIS框架到Azure Data Factory環境中

本書適合對象
對於參與圍繞存儲過程和SQL Server Integration Services (SSIS) 構建的企業數據項目的數據庫管理員和開發人員。讀者應具備編程背景,並希望通過實施可重複的流程來優化其數據工作,以支持企業DevOps。

作者簡介

Andy Leonard is Chief Data Engineer at Enterprise Data & Analytics, creator and Data Philosopher at DILM (Data Integration Lifecycle Management) Suite, an Azure Data Factory and SQL Server Integration Services trainer and consultant, and a BimlHero. He is a SQL Server database and data warehouse developer, community mentor, engineer, and farmer. Andy is co-author of SQL Server Integration Services Design Patterns, Data Integration Life Cycle Management with SSIS, and The Biml Book.
Kent Bradshaw is the founder or Tudor Data Solutions, LLC. With over 40 years of IT experience, he is a SQL Server database/ETL developer and database architect with a background is in Medicaid claims, public schools, government, retail, and insurance systems. In 2011, Kent founded Tudor Data Solutions, LLC to pursue new development opportunities which led to his association with Andy Leonard and Enterprise Data & Analytics. In 2017, Kent received the MPP certification for Data Science.

 

作者簡介(中文翻譯)

Andy Leonard 是 Enterprise Data & Analytics 的首席數據工程師,也是 DILM (Data Integration Lifecycle Management) Suite 的創建者和數據哲學家,同時也是 Azure Data Factory 和 SQL Server Integration Services 的培訓師和顧問,以及 BimlHero。他是一位 SQL Server 數據庫和數據倉庫開發人員、社區導師、工程師和農民。Andy 是《SQL Server Integration Services Design Patterns》、《Data Integration Life Cycle Management with SSIS》和《The Biml Book》的合著者。

Kent Bradshaw 是 Tudor Data Solutions, LLC 的創始人。擁有超過40年的IT經驗,他是一位 SQL Server 數據庫/ETL開發人員和數據庫架構師,其背景涉及醫療保險索賠、公立學校、政府、零售和保險系統。2011年,Kent 創立了 Tudor Data Solutions, LLC,以追求新的開發機會,並與 Andy Leonard 和 Enterprise Data & Analytics 有所合作。2017年,Kent 獲得了數據科學的 MPP 認證。