SQL Server data automation through frameworks : building metadata-driven frameworks with T-SQL, SSIS, and Azure Data Factory /

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...

Full description

Bibliographic Details
Call Number:Libro Electrónico
Main Author: Leonard, Andy (Author)
Other Authors: Bradshaw, Kent
Format: Electronic eBook
Language:Inglés
Published: [Berkeley, CA] : Apress, [2020]
Subjects:
SQL server.
Microsoft .NET Framework.
Client/server computing.
Microsoft software.
Database management.
Computer software.
Data mining.
Software
Data Mining
Architecture client-serveur (Informatique)
Logiciels Microsoft.
Bases de données > Gestion.
Logiciels.
Exploration de données (Informatique)
software.
Online Access:Texto completo (Requiere registro previo con correo institucional)
Table of Contents:
  • 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.

Similar Items