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

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
Otros Autores: Leonard, Andy, author (author), Bradshaw, Kent, author
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, California : Apress [2020]
Edición:1st ed. 2020.
Materias:
SQL server.
Client/server computing.
Microsoft software.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630979206719
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