Professional Microsoft SQL Server 2014 Integration Services

Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co - founder of SQLServerCentral.com and JumpstartTV.

Meer over de auteurs

Brian Knight, Devin Knight, Jessica Moss, Mike Davis, Chris Rock e.a.

Professional Microsoft SQL Server 2014 Integration Services

Name: Professional Microsoft SQL Server 2014 Integration Services
Author: Brian Knight

Specificaties

Paperback, 878 blz. | Engels

Wrox | 1e druk, 2014

ISBN13: 9781118850879

Rubricering

Hoofdrubriek : Computer en informatica

Wrox 1e druk, 2014 9781118850879

Onderdeel van serie Programmer to Programmer (Wrox)

Verwachte levertijd ongeveer 9 werkdagen

63,08

In winkelwagen

Samenvatting

A complete guide to Microsoft SSIS, updated for the 2014 release

Renowned SQL Server MVP Brian Knight and his expert co–authors teach you best practices for using all of the features of Microsoft SQL Server Integration Services (SSIS), including the latest enhancements introduced with the 2014 release of SQL Server. In addition to technical updates and additions, the authors also add a new set of best practices for effective use of SSIS, more case studies, and tutorial examples to illustrate advanced concepts and techniques.

Professional Microsoft SQL Server 2014 Integration Services:
- Explains how to extract, transform, and load (ETL) data with SSIS
- Covers each of the many SSIS tasks and Data Flow components
- Teaches you the most effective techniques for performance tuning SSIS
- Covers advanced techniques for data cleansing and incremental loads
- Shows how to load a data warehouse using built–in components in SSIS
- Details best practices for manageability and scalability

Specificaties

ISBN13:9781118850879

Trefwoorden:Microsoft, systeembeheer, Database-beheer, SQL Server 2014

Taal:Engels

Bindwijze:paperback

Aantal pagina's:878

Uitgever:Wrox

Druk:1

Verschijningsdatum:3-6-2014

Hoofdrubriek:IT-management / ICT

Serie:Programmer to Programmer (Wrox)

Over Brian Knight

Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co - founder of SQLServerCentral.com and JumpstartTV.com. Brian is a Principal Consultant and owner of Pragmatic Works. He runs the local SQL Server users' group in Jacksonville (JSSUG) and was on the Board of Directors of the Professional Association for SQL Server (PASS). Brian is a contributing columnist for SQL Server Standard and also maintains a regular column for the database website SQLServerCentral.com and does regular webcasts at Jumpstart TV. He has authored nine SQL Server books during the past 10 years. Brian has spoken at conferences like PASS, SQL Connections, and TechEd, and many Code Camps.

Andere boeken door Brian Knight

Bekijk alle boeken

Inhoudsopgave

U kunt van deze inhoudsopgave een PDF downloaden

Introduction

1. Welcome to SQL Server Integration Services
2. The SSIS Tools
3. SSIS Tasks
4. The Data Flow
5. Using Variables, Parameters, and Expressions
6. Containers
7. Joining Data
8. Creating an End-to-End Package
9. Scripting in SSIS
10. Advanced Data Cleansing in SSIS
11. Incremental Loads in SSIS
12. Loading a Data Warehouse
13. Using the Relational Engine
14. Accessing Heterogeneous Data
15. Reliability and Scalability
16. Understanding and Tuning the Data Flow Engine
17. SSIS Software Development Life Cycle
18. Error and Event Handling
19. Programming and Extending SSIS
20. Adding a User Interface to Your Component
21. External Management and WMI Task Implementation
22. Administering SSIS

Appendix A: SSIS Crib Notes
Appendix B: SSIS Internal Views and Stored Procedures
Appendix C: Interviewing for an ETL Developer Position

Index

Anderen die dit boek kochten, kochten ook

Erdinç Saçan

AI voor iedereen

€ 34,99
Willem Leijnse

Bestuurlijke informatievoorziening

€ 72,95
The Open Group

ArchiMate® 3.2 Specification

€ 49,00
Job van den Berg

AI Agents

€ 34,95
Remko van der Pols

BiSL – Een Framework voor business informatiemanagement

€ 49,00
Barend Last

Beter, leuker, sneller - Optimaal ontwikkelen met AI

€ 31,25

Uw winkelwagen

Professional Microsoft SQL Server 2014 Integration Services

Samenvatting

Specificaties

Over Brian Knight

Andere boeken door Brian Knight

Inhoudsopgave

Anderen die dit boek kochten, kochten ook

Rubrieken

Populaire producten

Personen

Trefwoorden