Transcript Building Mission Critical Applications

Design and Development
Tools for Building MissionCritical Applications
Name
Title
Microsoft Corporation
Agenda
 Designing the WhidbeyRocks! System
 Visual Studio Team System
 Building the WhidbeyRocks! Database
 SQL Server 2005
 Extending the Database
 Visual Studio 2005 & SQL/CLR Components
 Business Process Integration
 BizTalk Server 2006
 Reporting
 Business Activity Monitoring / Report Builder
VSTS for Software Architects
 Model structure of complex systems
 Knowledge transfer/collaboration
 Between architects and developers
 Between developers and operations
 Improve the value of design
 Design, code and configuration are
synchronized
Visual Studio Team Edition
Software Architects
Application Designer
System Designer
Logical Datacenter Designer
Deployment Designer
 Improve predictability of deployment
 Design validation, unified
deployment manifest
 Integration with best practices and
guidance
Class Designer
Visio for Enterprise Arch.
Team Explorer
Visual Studio Professional
Distributed System Challenges
Application
Architect
Development
Infrastructure
Architect
IT Operations
Designing WhidbeyRocks!
T-SQL Enhancements
 Varchar(max), Varbinary(max)
 Alternative to Text, Image
 Uniform Programming model
 Exception Handling
 Try/Catch
 Common Table Expressions (CTEs)
 Recursive Queries
 Multiple Active ResultSets (MARS)
 PIVOT, UNPIVOT
 TOP (expression)
Native Support For XML
 Native XML Support
 Store platform independent data
 Create dynamic content rich applications
 Enable loosely-coupled systems via coarse-grained messages
Loosely coupled services
Point-of-Sale Svc
(Windows Platform)
XML message
Supplier Svc
(Non-windows)
 XML and Relational co-existence
 Support high performance XML storage and query
 Enhance existing applications with XML co-existence
 Create rich full-text search applications
DB Table
E.g.
Insurance
Policy
First Name
Last Name
Address
Phone
XML data type
Native Support for Web Services
Non Windows
 Native Web services access
 Enables cross platform interoperability
 Reduces middle-tier dependency (IIS)
 Simplifies management and administration
 New HTTP ENDPOINT object
SOAP/XML
/HTTP
 Encourage database object re-use
 Support service oriented architectures
 Easy maintenance via loose coupling
Web Svc
Endpoints
configure connection info
configure authentication
expose stored procedures
expose TSQL batches
SP
SP
SP
TSQL
Management Studio
 Integrated management
 Relational Database, Analysis
Services, Reporting Services,
Notification Services, SQL
Mobile
 Multiple versions of SQL
Server from one interface
 Rich Management &
authoring
 Performance
 Manage multiple servers,
MANY objects
 Combines:
 Enterprise Manager, Query
Analyzer, Analysis Manager
Building the Database
.NET Integration Choices
 Choice of where to run logic
 Database, for logic that runs close to data
 Mid-tier, for logic that scales out
 Symmetric programming model
 Leverage skills middle tier & server
 Choice of programming language
 C#, VB.NET, & Managed C++, for a safe, modern
execution environment
 T-SQL continues to be supported & enhanced
 Remains good choice for data-intensive procedures
 Safe extended stored proc (xp) replacement
The Developer Experience
VB, C#
VS 2005
Project
Build
Runtime
hosted by SQL
(in-proc)
Assembly:
“taxlib.dll”
SQL Data Definition:
create assembly …
create function …
create procedure …
create trigger …
create type …
SQL Server
SQL Queries:
select sum(tax(sal,state))
from Employee
where county = 'King'
Managing Assemblies
 Loaded and stored inside SQL Server
 Cataloged with CREATE ASSEMBLY
 Dropped with DROP ASSEMBLY
 Collated as sets of files
 Assembly, References, PDB, source files
 Three Permission Sets
 Safe - compute, access local data
 External - files, registry, network, web services
 Unsafe – full trust, unmanaged Code
Extending the Database
BizTalk Server 2006 Enhancements
Windows Server System
Integration
Comprehensive Management
and Operations
 MMC for Enterprise Management
 Single View for Operations
and Monitoring
 Application-level Management
 Engine and Infrastructure
Investments
Business User Empowerment
 Real-time BAM Alerting
and Notification
 BAM Portal and reusable
web components
 SharePoint Adapter for deeper
WSS integration




Windows 64-bit (x86)
SQL Server 2005 Support
Visual Studio 2005/.NET 2.0
Virtual Server 2005
Setup, Upgrade and Deployment
 Simplified Setup
 Tools for Enterprise
Application Deployments
 Seamless upgrade from
BizTalk Server 2004
How BizTalk Messaging Works
Message
Message
BizTalk
Receive Port
Receive Location
(File Drop)
Send Port Group
Orchestration
Send Port
(File Drop)
Map
Receive Location
(HTTP)
Send Port
(HTTP)
Maps
Map
MessageBox
Send Port
(HTTP)
Map
Messages
Subscriptions
Message
BizTalk Developer Tools
 Visual Studio 2005
 Runtime built on .NET Framework 2.0
 Flat-File Import wizard
 Improvements for Orchestration
 Exists operator support for properties
(example: public static methods of a
Collapsed and expanded shapes
.NET class can be called such as
preserved across saves
invoking pipelines components)
Array support for Web Services  Allow variable number of message
(consuming only, no publishing)
parts.
Jagged array support
 Unique event log id’s for better MOM
support.
(no multidimensional arrays)
Access the context properties of  Add syntax and API’s to access
correlation contents.
the message part of a multipart
message
 Zoom in / Zoom Out




BizTalk Server 2006
Business Activity Monitoring
 Ask real-time questions
 How many orders are waiting to be shipped?
 What is the total value of my music inventory?
 Ask aggregation questions
 How much does it cost to produce one poster?
 What is the average throughput time for
special orders right now?
 Capture business data and events
New Features in BAM 2006
 Business alert experience for end users
 Out-of-box dashboard (BAM Portal)
 Native integration with BizTalk Messaging
 Distributed BAM infrastructure
 SDK
 Dynamic WSS web part generator
 Integration with Office Scorecard Accelerator,
SQL Reporting Services
 Custom Interception of business events
directly from Web services
BAM Roles & Tools
BUSINESS ANALYST
ODBA
BAM Design
Workbook
Creates
Understands business
requirements
INFORMATION
WORKERS
Observation
Model
BAM Portal
Real-time monitoring
of business
IT PRO
DEVELOPER
Maps to
Implementation
Deploys
BAM Manager
Provisions
the Infrastructure
BAM Dynamic
Infrastructure
Maps to run-time
components
“Right tools for the right user”
Tracking
Profile
Editor
Reporting Services Architecture
Browser
Data Sources
(SQL, OLE DB, ODBC,
Oracle, Custom)
Management
URL
Custom App
WMI
Web Service
Report Server
Output Formats
(HTML, Excel,
PDF, Custom)
Report Processing
Security Services
(NT, Passport,
Custom)
Data Retrieval
Rendering
Security
Delivery
SQL Server Catalog
Delivery Targets
(E-mail, File share,
Custom)
Report Builder
 Built on top of familiar Microsoft Office paradigms
Reports built via report templates (table, matrix, chart)
 “Click-Once” application deployed from the RS server
 Users download and
launch the client from
Report Manager
 Finished reports can be
saved on the server
BAM and Report Builder
VSIP Partners
© 2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.