國立虎尾科技大學 |

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

紀錄類型:	書目-語言資料,印刷品 : Monograph/item
正題名/作者:	SQL Server Data Automation Through Frameworks/ by Andy Leonard, Kent Bradshaw.
其他題名:	Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory /
作者:	Leonard, Andy.
其他作者:	Bradshaw, Kent.
面頁冊數:	XX, 391 p. 350 illus.online resource. :
Contained By:	Springer Nature eBook
標題:	Data Mining and Knowledge Discovery. -
電子資源:	https://doi.org/10.1007/978-1-4842-6213-9
ISBN:	9781484262139

SQL Server Data Automation Through Frameworks = Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory /
Leonard, Andy.

SQL Server Data Automation Through FrameworksBuilding Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory /[electronic resource] :by Andy Leonard, Kent Bradshaw. - 1st ed. 2020. - XX, 391 p. 350 illus.online resource.

Part I: Stored Procedure-Based Database Frameworks -- 1. Stored Procedures 101 -- 2. Automation with Stored Procedures -- 3. Stored Procedure Orchestrators -- 4. A Stored Procedure-Base Metadata-Driven Framework -- Part II: SSIS Frameworks -- 5. A Simple Custom File-Based SSIS Framework -- 6. Framework Execution Engine -- 7. Framework Logging -- 8. Azure-SSIS Integration Runtime -- 9. Deploy A Simple Custom File-Based Azure-SSIS Framework -- 10. Framework Logging in ADF -- 11. Fault Tolerance in the ADF Framework.

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. You will: 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.

ISBN: 9781484262139

Standard No.: 10.1007/978-1-4842-6213-9doiSubjects--Topical Terms:

677765
Data Mining and Knowledge Discovery.

LC Class. No.: QA76.76.M52

Dewey Class. No.: 004.165

SQL Server Data Automation Through Frameworks = Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory /
LDR:03534nam a22003855i 4500 001 1030573
003 DE-He213
005 20201017104750.0
007 cr nn 008mamaa
008 210318s2020 xxu| s |||| 0|eng d
020 $a 9781484262139 $9 978-1-4842-6213-9
024 7 $a 10.1007/978-1-4842-6213-9 $2 doi
035 $a 978-1-4842-6213-9
050 4 $a QA76.76.M52
072 7 $a UMP $2 bicssc
072 7 $a COM051380 $2 bisacsh
072 7 $a UMP $2 thema
082 0 4 $a 004.165 $2 23
100 1 $a Leonard, Andy. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1172476
245 1 0 $a SQL Server Data Automation Through Frameworks $h [electronic resource] : $b Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory / $c by Andy Leonard, Kent Bradshaw.
250 $a 1st ed. 2020.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2020.
300 $a XX, 391 p. 350 illus. $b online resource.
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
347 $a text file $b PDF $2 rda
505 0 $a Part I: Stored Procedure-Based Database Frameworks -- 1. Stored Procedures 101 -- 2. Automation with Stored Procedures -- 3. Stored Procedure Orchestrators -- 4. A Stored Procedure-Base Metadata-Driven Framework -- Part II: SSIS Frameworks -- 5. A Simple Custom File-Based SSIS Framework -- 6. Framework Execution Engine -- 7. Framework Logging -- 8. Azure-SSIS Integration Runtime -- 9. Deploy A Simple Custom File-Based Azure-SSIS Framework -- 10. Framework Logging in ADF -- 11. Fault Tolerance in the ADF Framework.
520 $a 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. You will: 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.
650 2 4 $a Data Mining and Knowledge Discovery. $3 677765
650 2 4 $a Professional Computing. $3 1115983
650 2 4 $a Database Management. $3 669820
650 1 4 $a Microsoft and .NET. $3 1114109
650 0 $a Data mining. $3 528622
650 0 $a Computer software. $3 528062
650 0 $a Database management. $3 557799
650 0 $a Microsoft .NET Framework. $3 565417
650 0 $a Microsoft software. $3 1253736
700 1 $a Bradshaw, Kent. $e author. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1327516
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484262122
776 0 8 $i Printed edition: $z 9781484262146
856 4 0 $u https://doi.org/10.1007/978-1-4842-6213-9
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)