The Resource SQL Server 2012 data integration recipes, Adam Aspin, (electronic resource)

SQL Server 2012 data integration recipes, Adam Aspin, (electronic resource)

Label
SQL Server 2012 data integration recipes
Title
SQL Server 2012 data integration recipes
Statement of responsibility
Adam Aspin
Creator
Contributor
Provider
Subject
Genre
Language
eng
Summary
SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more. What DBA or developer isn't faced with the need to move data back and forth? Author Adam Aspin brings 10 years of extensive ETL experience involving SQL Server, and especially satellite products such as Data Transformation Services and SQL Server Integration Services. Extensive coverage is given to Integration Services, Microsoft's flagship tool for data integration in SQL Server environments. Coverage is also given to the broader range of tools such as OPENDATASOURCE, linked servers, OPENROWSET, Migration Assistant for Access, BCP Import, and BULK INSERT just to name a few. If you're looking for a resource to cover data integration and ETL across the gamut of Microsoft's SQL Server toolset, SQL Server 2012 Data Integration Recipes is the one book that will meet your needs. Provides practical and proven solutions towards creating resilient ETL environments Clearly answers the tough questions which professionals ask Goes beyond the tools to a thorough discussion of the underlying techniques Covers the gamut of data integration, beyond just SSIS Includes example databases and files to allow readers to test the recipes
Member of
Cataloging source
GW5XE
http://library.link/vocab/creatorName
Aspin, Adam
Image bit depth
0
LC call number
QA76.9.D338
LC item number
A87 2012
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorName
SpringerLink
http://library.link/vocab/subjectName
  • Data integration (Computer science)
  • Client/server computing
  • COMPUTERS / Database Management / General
  • COMPUTERS / Desktop Applications / Databases
  • COMPUTERS / System Administration / Storage & Retrieval
  • Database management
  • Data integration (Computer science)
  • Client/server computing
Label
SQL Server 2012 data integration recipes, Adam Aspin, (electronic resource)
Instantiates
Publication
Note
Includes index
Antecedent source
mixed
Color
not applicable
Contents
  • Data Transformation
  • Data Profiling
  • Delta Data Management
  • Change Tracking and Change Data Capture
  • Organising And Optimizing Data Loads
  • ETL Process Acceleration
  • Logging and Auditing
  • Sourcing Data from MS Office Applications
  • Flat File Data Sources
  • XML Data Sources
  • SQL Databases
  • SQL Server Sources
  • Miscellaneous Data Sources
  • Exporting Data from SQL Server
  • Metadata
Dimensions
unknown
Extent
1 online resource.
File format
multiple file formats
Form of item
  • online
  • electronic
Isbn
9781430247920
Level of compression
uncompressed
Quality assurance targets
absent
Reformatting quality
access
Specific material designation
remote
Stock number
CL0500000218
System control number
  • (OCoLC)826019111
  • (OCoLC)ocn826019111
Label
SQL Server 2012 data integration recipes, Adam Aspin, (electronic resource)
Publication
Note
Includes index
Antecedent source
mixed
Color
not applicable
Contents
  • Data Transformation
  • Data Profiling
  • Delta Data Management
  • Change Tracking and Change Data Capture
  • Organising And Optimizing Data Loads
  • ETL Process Acceleration
  • Logging and Auditing
  • Sourcing Data from MS Office Applications
  • Flat File Data Sources
  • XML Data Sources
  • SQL Databases
  • SQL Server Sources
  • Miscellaneous Data Sources
  • Exporting Data from SQL Server
  • Metadata
Dimensions
unknown
Extent
1 online resource.
File format
multiple file formats
Form of item
  • online
  • electronic
Isbn
9781430247920
Level of compression
uncompressed
Quality assurance targets
absent
Reformatting quality
access
Specific material designation
remote
Stock number
CL0500000218
System control number
  • (OCoLC)826019111
  • (OCoLC)ocn826019111

Library Locations

  • African Studies LibraryBorrow it
    771 Commonwealth Avenue, 6th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Alumni Medical LibraryBorrow it
    72 East Concord Street, Boston, MA, 02118, US
    42.336388 -71.072393
  • Astronomy LibraryBorrow it
    725 Commonwealth Avenue, 6th Floor, Boston, MA, 02445, US
    42.350259 -71.105717
  • Fineman and Pappas Law LibrariesBorrow it
    765 Commonwealth Avenue, Boston, MA, 02215, US
    42.350979 -71.107023
  • Frederick S. Pardee Management LibraryBorrow it
    595 Commonwealth Avenue, Boston, MA, 02215, US
    42.349626 -71.099547
  • Howard Gotlieb Archival Research CenterBorrow it
    771 Commonwealth Avenue, 5th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Mugar Memorial LibraryBorrow it
    771 Commonwealth Avenue, Boston, MA, 02215, US
    42.350723 -71.108227
  • Music LibraryBorrow it
    771 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Pikering Educational Resources LibraryBorrow it
    2 Silber Way, Boston, MA, 02215, US
    42.349804 -71.101425
  • School of Theology LibraryBorrow it
    745 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350494 -71.107235
  • Science & Engineering LibraryBorrow it
    38 Cummington Mall, Boston, MA, 02215, US
    42.348472 -71.102257
  • Stone Science LibraryBorrow it
    675 Commonwealth Avenue, Boston, MA, 02445, US
    42.350103 -71.103784
Processing Feedback ...