1.

Record Nr.

UNINA9910453198903321

Titolo

Professional SQL Server 2008 integration services [[electronic resource] /] / Brian Knight ... [et al.]

Pubbl/distr/stampa

Indianapolis, IN, : Wiley Pub., c2008

ISBN

1-118-05956-5

1-281-83701-6

9786611837013

0-470-41768-4

Edizione

[1st edition]

Descrizione fisica

1 online resource (1010 p.)

Collana

Wrox professional guides

Altri autori (Persone)

KnightBrian <1976->

Disciplina

005.75/85

005.7585

Soggetti

Database management

Electronic books.

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Includes index.

"Wrox programmer to programmer."

Nota di contenuto

Professional SQL Server 2008 Integration Services; About the Authors; Credits; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p.wrox.com; Chapter 1: Welcome to SQL Server Integration Services; SQL Server SSIS Historical Overview; What's New in SSIS; Getting Started; Architecture; Precedence Constraints; Containers; Variables; Data Flow Elements; Error Handling and Logging; Editions of SQL Server; Summary; Chapter 2: The SSIS Tools; Import and Export Wizard

Business Intelligence Development StudioCreating Your First Package; The Solution Explorer Window; The SSIS Package Designer; Package Installation Wizard; Management Studio; Summary; Chapter 3: SSIS Tasks; SSIS Task Objects; Looping and Sequence Tasks; Scripting Tasks; Analysis Services Tasks; Data Flow Task; Data Preparation Tasks; RDBMS Server Tasks; Workflow Tasks; SMO Administration Tasks; Summary; Chapter 4: Containers; Task Host Containers; Sequence Containers; Groups; For Loop Container; Foreach Loop Container;



Summary; Chapter 5: The Data Flow; The Data Flow; Data Viewers; Sources

DestinationsTransformations; Data Flow Example; Summary; Chapter 6: Using Expressions and Variables; The Paradigm; Understanding Data Types; Using Variables; Working with Expressions; Summary; Chapter 7: Joining Data; The Lookup Component; The Merge Join Component; Contrasting to the Relational Join; New Lookup Features; Building the Basic Package; Using the Lookup Component; Cache Connection Manager and Transform; Summary; Chapter 8: Creating an End-to-End Package; Basic Transformation Tutorial; Typical Mainframe ETL with Data Scrubbing; Looping and the Dynamic Task; Summary

Chapter 9: Scripting in SSISScripting?; Getting Started in SSIS Scripting; Using the Script Task; Using the Script Component; Essential Coding, Debugging, and Troubleshooting Techniques; Summary; Chapter 10: Loading a Data Warehouse; Data Profiling; Data Extraction; Dimension Table Loading; Fact Table Loading; SSAS Processing; Master ETL Package; Summary; Chapter 11: Using the Relational Engine; Data Extraction; SQL Server 2008 Change Data Capture; Data Loading; Summary; Chapter 12: Accessing Heterogeneous Data; Excel and Access; Oracle; XML and Web Services; Flat Files; ODBC

Other Heterogeneous SourcesSummary; Chapter 13: Reliability and Scalability; Restarting Packages; Package Transactions; Error Outputs; Scaling Out; Summary; Chapter 14: Understanding and Tuning the Data Flow Engine; The SSIS Engine; SSIS Data Flow Design and Tuning; Pipeline Performance Monitoring; Summary; Chapter 15: Source Control and Software Development Life Cycle; Introduction to Software Development Life Cycles; Versioning and Source Code Control; Code Deployment and Promotion from Development to Test to Production; Summary; Chapter 16: DTS 2000 Migration

Managing DTS 2000 Packages within SQL Server Management Studio

Sommario/riassunto

The new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS)Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than everCase studies and tutorial examples acquired over the three years since the previous edition will contribute to helping illustrate advanced concepts and techniquesNew chapters include coverage of data warehousing using SSIS, new me



2.

Record Nr.

UNINA9910551839803321

Titolo

Single Molecule Sensing Beyond Fluorescence / / edited by Warwick Bowen, Frank Vollmer, Reuven Gordon

Pubbl/distr/stampa

Cham : , : Springer International Publishing : , : Imprint : Springer, , 2022

ISBN

3-030-90339-7

Edizione

[1st ed. 2022.]

Descrizione fisica

1 online resource (426 pages) : illustrations (chiefly color)

Collana

Nanostructure Science and Technology, , 2197-7976

Disciplina

681.2

620.5

Soggetti

Chemical detectors

Biophysics

Nanotechnology

Materials - Microscopy

Optics

Sensors

Microscopy

Optics and Photonics

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Nota di bibliografia

Includes bibliographical references and index.

Nota di contenuto

Part I Optical Sensing -- Interferometric Biosensing -- Optoplasmonic Whispering Gallery Mode Sensors for Single Molecule Characterization: A Practical Guide -- Nonlinear Optical Microcavities Towards Single-Molecule Sensing -- Part II Optomechanical Sensing -- Optomechanical Sensing -- Quantum Optical Theories of Molecular Optomechanics -- Part III Biomolecular Manipulation -- Dielectrophoresis of Single Molecules -- Optical Trapping of Single Molecules -- Applications of Trapping to Protein Analysis and Interactions -- Towards Single-Molecule Chiral Sensing and Separation -- Part IV Nanopores -- Experimental Approaches to Solid-State Nanopores -- Challenges in Protein Sequencing using 2-D MoS2 Nanopores -- Single-molecule Ionic and Optical Sensing with Nanoapertures -- Self-induced Back-action Actuated Nanopore Electrophoresis (SANE) sensing.

Sommario/riassunto

This book provides an interesting snapshot of recent advances in the



field of single molecule nanosensing. The ability to sense single molecules, and to precisely monitor and control their motion is crucial to build a microscopic understanding of key processes in nature, from protein folding to chemical reactions. Recently a range of new techniques have been developed that allow single molecule sensing and control without the use of fluorescent labels. This volume provides an overview of recent advances that take advantage of micro- and nanoscale sensing technologies and provide the prospect for rapid future progress. The book endeavors to provide basic introductions to key techniques, recent research highlights, and an outlook on big challenges in the field and where it will go in future. It is a valuable contribution to the field of single molecule nanosensing and it will be of great interest to graduates and researchers working in this topic.