Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Applied Architecture Patterns on the Microsoft Platform (Second Edition)
  • Table Of Contents Toc
Applied Architecture Patterns on the Microsoft Platform (Second Edition)

Applied Architecture Patterns on the Microsoft Platform (Second Edition) - Second Edition

By : Dovgal, Noriskin
4.9 (7)
Buy this Book
close
close
Applied Architecture Patterns on the Microsoft Platform (Second Edition)

Applied Architecture Patterns on the Microsoft Platform (Second Edition)

4.9 (7)
By: Dovgal, Noriskin
Buy this Book

Overview of this book

Presented in a scenario-driven tutorial way, we lead you through fictitious example problems and present you with the best solutions. This book is intended for architects, developers, and managers who need to improve their knowledge of the Microsoft application platform. This book will appeal to anyone, especially consultants, who want to get up to speed on selecting the most appropriate platform for a particular problem. A good understanding of the general Windows platform and development technologies would be helpful.
Table of Contents (15 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Solution Decision Framework
Icon
1. Solution Decision Framework
Icon
The need for a decision framework
Icon
Sources of input
Icon
Deciding upon your architecture strategy
Icon
Technology evaluation dimensions
Icon
Applying the framework
Icon
Summary
2
2. The .NET Framework Primer
Icon
2. The .NET Framework Primer
Icon
An evaluation framework for .NET Framework APIs
Icon
The .NET Framework
Icon
Summary
3
3. The SQL Server Primer
Icon
3. The SQL Server Primer
Icon
What is included in SQL Server 2012?
Icon
Building the payroll processor application
Icon
New features of SQL Server 2014
Icon
Summary
4
4. The SSIS Primer
chevron up
Icon
4. The SSIS Primer
Icon
What's new in SSIS 2012
Icon
Building the payroll processor application
Icon
What's new in SSIS 2014
Icon
Summary
5
5. The BizTalk Server Primer
Icon
5. The BizTalk Server Primer
Icon
Using BizTalk in an integration architecture
Icon
BizTalk essentials
Icon
New features of BizTalk Server 2013
Icon
BizTalk Server editions
Icon
BizTalk Server abilities
Icon
Building the BizTalk application
Icon
Summary
6
6. The SharePoint Server Primer
Icon
6. The SharePoint Server Primer
Icon
The SharePoint editions
Icon
The SharePoint platform
Icon
Administration and management
Icon
Core concepts and capabilities of SharePoint
Icon
SharePoint extensibility
Icon
SharePoint APIs
Icon
SharePoint development tools
Icon
Summary
7
7. Other Microsoft Technologies
Icon
7. Other Microsoft Technologies
Icon
Operating systems
Icon
The Microsoft Office software
Icon
Software development tools
Icon
Cloud computing
Icon
Summary
8
8. Integration Patterns and Antipatterns
Icon
8. Integration Patterns and Antipatterns
Icon
Integration styles and challenges
Icon
Point-to-point integration
Icon
The federated request pattern
Icon
The message broker pattern
Icon
The guaranteed delivery problem
Icon
The Publish/Subscribe pattern
Icon
Moving to Enterprise Service Bus
Icon
Summary
9
9. Web Services and Beyond
Icon
9. Web Services and Beyond
Icon
Service-oriented architecture
Icon
Enterprise Service Bus
Icon
RESTful services
Icon
Summary
10
10. Data Exchange Patterns
Icon
10. Data Exchange Patterns
Icon
File transfer
Icon
A shared database
Icon
Data replication and synchronization
Icon
Data migration
Icon
The extract, transform, and load pattern for centralized data aggregation
Icon
Multiple master synchronization
Icon
Data sharing and federation
Icon
Summary
11
11. Workflow Patterns
Icon
11. Workflow Patterns
Icon
Fully automated workflows
Icon
Human workflows
Icon
Summary
12
12. Presentation Layer Patterns
Icon
12. Presentation Layer Patterns
Icon
Building presentation layers
Icon
MVC, MVP, and MVVM
Icon
Working with a use case – a user interface for the shopping cart
Icon
Working with a use case – a desktop time billing application
Icon
Summary
13
13. Conclusion
Icon
13. Conclusion
Icon
Patterns for software-intensive systems
Icon
Where to go next
14
Index
Icon
Index

Chapter 4. The SSIS Primer

When the ancestor of SQL Server Integration Services (SSIS)—Data Transformation Services (DTS)—was initially released with SQL Server 7.0, database administrators were extremely pleased. DTS not only replaced old data transformation and loading tools, but also added new features that significantly simplified their lives. However, only in SQL Server 2000 did DTS become a modern Extract, transform, load (ETL) tool, which set up a foundation for SQL Server Integration Services.

SSIS was originally released with SQL Server 2005 with the intention of replacing DTS. SSIS 2005 was a full-featured data integration engine and development environment to build high-performance solutions. After several more versions, SSIS became a development platform to build quality data integration, migration, and transformation solutions. Typical scenarios for the usage of SSIS include the following:

  • ETL tasks to support data warehousing
  • Data migration as part of...
Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Applied Architecture Patterns on the Microsoft Platform (Second Edition)
End of Section 4
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon