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

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Leonard, Andy (Autor)
Otros Autores: Bradshaw, Kent
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [Berkeley, CA] : Apress, [2020]
Temas:
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.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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.

Ejemplares similares