German Marin's Blog

adjustable service level

2005-06-24T13:51:00Z

adjustable service level

Context

You have an application that answers request from many clients and you want to have control over quality of service to each client considering application capabilities and the service level agreement that you have with your customers.

Problem

You want to control the time when the application answers and processes requests. The answering application should have the option to deny service even if the requester is authorized to send requests.

Solution

The HUB informs the SPOKE how long it should wait for sending a response request, how long it is it time window and also the ID it should present to the HUB for retrieving response.

See Picture:

http://blogs.geekdojo.net/photos/german/picture8525.aspx

Stateless Paging in SQL Server

2005-05-17T12:41:00Z

What I would like ROWNUM , LIMIT, etc

SELECT TITLE FROM BOOK WHERE ROWNUM <= 5 ORDER BY TITLE
SELECT * FROM BOOK WHERE RowNumber BETWEEN 11 AND 20
SELECT * FROM BOOK WHERE userID = colname LIMIT 2
SELECT * FROM BOOK LIMIT 20, 10

... y no tengo

Sent from the client to the server the last register and the server performs a new query ("Registro de reenganche")
Cache en Cliente y Servidor???
Something that remember DIME???

Referencias:

http://www.windowsitpro.com/SQLServer/Article/ArticleID/40505/40505.html

http://weblogs.asp.net/pwilson/archive/2003/10/10/31456.aspx

http://www.windowsitpro.com/SQLServer/Article/ArticleID/43922/43922.html

http://www.codeproject.com/cs/database/PagingSqlNet.asp

http://www.codeproject.com/aspnet/PagingLarge.asp

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=31741

Referencias RowNum / RowNumber

http://www.joesack.com/SQLServerROWNUM.htm

Row level Security SQL

2005-05-09T14:34:00Z

Microsoft provides a method to grant permisisons to individual columns within a table. Row-level security, however, is implemented using a "view", a stored proc, or SQL function. The method I most commonly see is using a SQL view--it's a lot easier than trying to manage column permissions. Instead, you grant SQL permissions to the view, not the underlying table. With creative use of a WHERE clause, you should only need one "view" for every type of database access. For example, a customer service rep viewing his/her trouble tickets can be accomplished by creating a view that filters the TroubleTicket database for tickets WHERE AgentName = SUSER_NAME(), a built-in SQL function that returns the currently logged-in username. This ensures that all actions taken using the view will only affect tickets for that agent. Deny permissions to all the tables and only grant your users permissions to the views.

Referencias

http://vyaskn.tripod.com/row_level_security_in_sql_server_databases.htm

I think It's a better idea to use SUSER_SID() instead of SUSER_NAME(). What do you think???

Converting from the SOAP Toolkit to Visual Studio .NET

2005-04-30T06:38:00Z

Applications built with the SOAP Toolkit or XML Web services are built according to the SOAP specification. With SOAP-based applications, the connection between a client and a Web service is defined exclusively by the WSDL file. A Web service built with the SOAP Toolkit can be used with a Web service built with .NET and vice versa. This allows you to migrate from the SOAP Toolkit to .NET in stages by holding the WSDL definition of the service constant. For instance, the clients that access your Web service can continue to use the SOAP Toolkit's SOAPClient while your Web service is converted to .NET.

The simplest way to hold the WSDL file for your Web service constant is to generate the skeleton for your Web service from the WSDL file created by the SOAP Toolkit. The .NET Wsdl.exe utility will generate the Visual Basic .NET skeleton for a Web service if you pass the utility the:

/l parameter: Controls the language of the generated code. The default is C#. Passing /l:VB causes the utility to generate Visual Basic.
/server parameter: Indicates that you want the utility to generate the Web service’s server-side code. The default is for the utility to generate the client-side proxies.
The name of the WSDL file.

To generate the code for our sample Web service from the Cust.wsdl file, you would use:

wsdl.exe /l:VB /server cust.wsdl

The resulting skeleton code would be placed in a file called Cust.vb. You can copy the code from there into your ASMX module and then copy your Visual Basic 6.0 code into the equivalent routines in the ASMX module. You’ll need to convert your Visual Basic 6.0 code to .NET syntax, as described in other papers in this series. If you want to create a completely new .NET version of your Web service, the WSDL file from your SOAP Toolkit version can be used to generate the skeleton code for your Web service.

On the client side, the different client applications that access a Web service can be converted from the SOAP Toolkit to .NET on an individual basis. Even rolling out the .NET versions of a single client can be staged because of the interoperability that the SOAP specification provides. To convert from the SOAP Toolkit to Visual Studio .NET within the client, you must replace the references to SOAPClient with references to the Web service proxies.

Referencias SOAP Toolkit a :NET

http://www.dotnet247.com/247reference/a.aspx?u=http://msdn.microsoft.com/webservices/default.aspx?pull=/library/en-us/dnsoap/html/stkmigration.asp

http://dev4net.com/blog/archive/2005/02/16/1988.aspx

http://blogs.msdn.com/rdias/archive/2004/06/02/147128.aspx

http://msdn.microsoft.com/webservices/building/soaptk/default.aspx

Referencias de Interop

http://www.programmersheaven.com/2/vbrad-Interop

http://www.codeproject.com/dotnet/nettocom.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconapplyinginteropattributes.asp

Some important info related to MSXML :

SDK:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsxml/html/joyofsax.asp

Support:

http://support.microsoft.com/search/default.aspx?catalog=LCID%3D1033&mode=s&cat=false&query=MSXML&srch=sup&x=11&y=12

MSXML2 will work if you point %TMP% to a writable location

BizTalk setup

2005-02-27T07:43:00Z

http://pluralsight.com/blogs/aaron/archive/2005/02/23/6140.aspx

Bykes experimients

2005-02-09T23:35:00Z

MSU mechanical engineering students design bicycle for kids with cerebral palsy http://www.lsj.com/news/local/040501_msubike_1b-2b.html

Infopath recordings

2005-02-03T03:15:00Z

Best Practices for Designing InfoPath Forms
Level 200 - 5.10.2004 - 18:00 - 19:30 Uhr
Scott Roberts, Software Design Engineer, Microsoft Corporation
User Roles in InfoPath 2003
Level 200 - 12.10.2004 - 18:00 - 19:30 Uhr
Josh Bertsch, Software Test Engineer, Microsoft Corporation
Building Advanced Dynamic Solutions in InfoPath 2003
Level 200 - 19.10.2004 - 18:00 - 19:30 Uhr
Jun Jin, Software Design Engineer, Microsoft Corporation
Business Logic in InfoPath 2003
Level 300 - 26.10.2004 - 20:00 - 21:30 Uhr
Yuet (Emily) Ching and Prachi Bora, Software Test Engineers, Microsoft Corporation
Using Managed Code and Visual Studio to Build Solutions
Level 300 - 2.11.2004 - 22:00 - 23:00 Uhr
Willson Raj David, Software Design Engineer, Microsoft Corporation
InfoPath in End-to-End Enterprise Solutions: Integrating InfoPath with Siebel and SAP
Level 300 - 8.11.2004 - 20:00 - 21:30 Uhr
Hagen Green, Software Test Engineer, Microsoft Corporation
Digital Signatures in InfoPath 2003
Level 300 - 15.11.2004 - 20:00 - 21:30 Uhr
Mihaela Cristina Cris, Software Test Engineer, Microsoft Corporation
Creating Custom Controls for InfoPath SP1
Level 400 - 29.11.2004 - 20:00 - 21:30 Uhr
Andrew Ma, Software Test Engineer, Microsoft Corporation
Programming Workflow into InfoPath Solutions: Using InfoPath with BizTalk Server 2004 and Human Workflow Services
Level 400 - 6.12.2004 - 20:00 - 21:30 Uhr
Rick Severson, Software Test Engineer, Microsoft Corporation
Database Connectivity in InfoPath Through ADO.NET DataSet Support
Level 400 - 14.12.2004 - 20:00 - 21:30 Uhr
Mikhail Vassiliev, Software Design Engineer, Microsoft Corporation

Customer Data Integration (ideas 1)

2005-02-02T16:20:00Z

Objetivo:
vista única del cliente (360 grados) y su comportamiento macro con la empresa.
Market Research
Existe una iniciativa de OASIS para definir información especifica de los clientes (http://www.oasis-open.org/committees/ciq/ciq.html) tales como nombre (xNL) y dirección (xAL), otro tipo de información (xCIL) y relaciones entre Organizaciones, Organizacion con Persona y Relación entre personas (xCRL)
Existe una linea de investigación en la que encaja esta problematica de base de datos unica de clientes que se llama Semantic Integration (http://www.coolheads.com/SRNPUBS/EXTREME2003/A_Semantic_Integration_Methodology/slide01.htm )

Experiencias de adaptadores BTS

2005-01-16T03:57:00Z

http://www.gotdotnet.com/community/resources/default.aspx?Query=BizTalk

BTS 2004 Webcast Recordings

2005-01-15T00:01:00Z

Past Webcast Recordings
2003
Aug 29 BizTalk 2004 Overview & VS.NET Integration - Erik Leaseburg
http://www.placeware.com/cc/microsoft/view?id=JUPBAG&pw=35DKTQ
Sep 5 Setup & Installation - Vipul Goyal
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-1&pw=35DKTQ
Sep 12 2002 to 2004 Comparison & Migration - Erik Leaseburg
Sep 19 2002 to 2004 Comparison & Migration (repeat!) - Erik Leaseburg
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-2&pw=35DKTQ
Sep 26 XML Editor - Guru Venkataraman
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-3&pw=35DKTQ
Oct 3 XML Mapper - Vipul Goyal
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-4&pw=35DKTQ
Oct 10 Orchestration - Dale Michalk
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-5&pw=35DKTQ
Oct 17 Deployment - Rajan Dwivedi
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-6&pw=35DKTQ
Oct 24 Content Based Routing - Marty Wasznicky
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-7&pw=35DKTQ
Oct 31 Skip This Week for PDC
Nov 7 Pipeline & Custom Components - Gavin Islip
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-8&pw=35DKTQ
Nov 14 Cancelled
Thu, Nov 20 BizTalk Message Queuing (MSMQ/T) - Rajan Dwivedi
http://www.placeware.com/cc/microsoft/view?id=6DWNGR-16&pw=494ZRK
Note: Click on Agenda slide to skip first 30min of unrelated information
Nov 28 Skip This Week for Thanksgiving Holiday
Dec 5 Web Services and Orchestration - Erik Leaseburg
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-10&pw=35DKTQ
Dec 12 Rules Composer - David Wang
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-11&pw=35DKTQ
Dec 19 Advanced Orchestration, Part 1 - Erik Leaseburg
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-12&pw=35DKTQ
Dec 26 Skip This Week for Holidays

2004
Jan 2 Skip This Week for New Years Holiday
Jan 9 Health and Activity Tracking (HAT) & Debugging - Patrick Smith
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-13&pw=35DKTQ
Jan 16 Business Activity Services (BAS) - David Wang
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-14&pw=35DKTQ
Jan 23 Advanced Orchestration, Part 2 - Marty Wasznicky
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-15&pw=35DKTQ
Jan 30 Human Workflow Services (HWS) - Raman Mahal
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-16&pw=35DKTQ
Feb 6 InfoPath/BizTalk 2004 Integration - David Solomon
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-17&pw=35DKTQ
Feb 13 BizTalk Adapter Framework - Gavin Islip
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-18&pw=35DKTQ
Feb 20 Business Activity Monitoring (BAM) - David Wang
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-19&pw=35DKTQ
Feb 27 BizTalk Explorer & Administration - Erik Leaseburg
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-20&pw=35DKTQ
Mar 5 Enterprise Single Sign-On (SSO) - Jonathan Gao
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-21&pw=35DKTQ
Mar 12 EDI Covast Adapter - Scott Mauvais
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-22&pw=35DKTQ
Mar 19 BizTalk Adapter Program - Ramona Ramadas (no recording)
Mar 26 SQL Adapter - Ananth Krishnamurthy (Equarius)
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-23&pw=35DKTQ
Apr 2 Performance, Stress & Scalability - Erik Leaseburg
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-24&pw=35DKTQ
Apr 9 Skip This Week for Good Friday/Easter Weekend
Apr 16 SAP Adapter - Bryan McCutchan
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-25&pw=35DKTQ
Apr 23 Skip This Week
Apr 30 Migrating from BizTalk 2002 to 2004 - Erik Leaseburg
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-26&pw=35DKTQ
May 7 MQSeries Adapter - Susie Adams
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-27&pw=35DKTQ
May 14 SharePoint Adapter - Steve Resnick
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-28&pw=35DKTQ
May 21 Advanced Orchestration - Erik Leaseburg
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032253626
May 28 HIPAA 3.0 Accelerator - Monica DeZulueta
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-29&pw=35DKTQ
Jun 4 Advanced Dev - Crypto Pipeline, Submit Direct, Orchestration - Rajan Dwivedi
(no recording, see Jun 18 repeat delivery)
Jun 11 Skip This Week
Jun 18 Advanced Dev - Crypto Pipeline, Submit Direct, Orchestration (repeat!) - Rajan Dwivedi
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-31&pw=35DKTQ
Jun 25 Trading Partner Management & FTP Adapter - David Wang
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-30&pw=35DKTQ
Jul 2 Skip This Week for 4th of July Holiday in US
Jul 9 SWIFT Accelerator - Fredda Cole
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-32&pw=35DKTQ
July 16 Skip This Week for MGB in Atlanta
July 23 RosettaNet Accelerator - Cuneyt Havlioglu
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-33&pw=35DKTQ
July 30 HL7 Accelerator - Suren Machiraju
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-34&pw=35DKTQ
Aug 6 Skip This Week
Aug 13 Skip This Week
Aug 20 BizTalk Configuration and Administration – Erik Leaseburg
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-35&pw=35DKTQ
Sep 3 Orchestration Drilldown: Transactions, Exceptions and Compensation - Erik Leaseburg
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-36&pw=35DKTQ
Sep 10 BizTalk Adapter Wizard - Boudewijn van der Zwan (Unisys)
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-37&pw=35DKTQ
Sep 17 HIS Integration with BizTalk - Mike Cramer
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-38&pw=35DKTQ
Sep 24 Advanced Mapping - Aleksey Savateyev
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-39&pw=35DKTQ
Oct 1 BizTalk PowerToys - Erik Leaseburg
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-40&pw=35DKTQ
Oct 8 BizTalk 2004 Administration Management Tool - Paul Somers (Charteris)
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-41&pw=35DKTQ
Oct 14 Microsoft BizTalk Adapter for WSE 2.0 Technical Overview - Joe Klug
http://www.placeware.com/cc/microsoft/view?id=WSE2.0&pw=WSE2.0
Oct 15 UK SDC BizTalk 2004 Documenter v.2.0 - Jason Birth
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-42&pw=35DKTQ
Oct 22 BAM Drilldown - Zach Jason and John Ballard
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-43&pw=35DKTQ
Oct 29 Building Adapters From Scratch Using VB.NET - David Stampfli
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-44&pw=35DKTQ
Nov 5 Skip This Week
Nov 12 BizTalk 2004 Adapter for MSMQ (NAIAD) - Rick Mittelstaedt
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-45&pw=35DKTQ
Nov 19 BizTalk Native Adapter & Orchestration Tips & Tricks - Erik Leaseburg
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-46&pw=35DKTQ
Nov 26 Skip This Week for Thanksgiving Holiday in US
Dec 3 Trading Partner Management (TPM) & Business Activity Services (BAS) - Dale Michalk
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-47&pw=35DKTQ
Dec 10 WRQ Verastream BizTalk 2004 Screen Scraping Adapter for Legacy Integration - Paul Neutz & Jeff Zuber (WRQ)
http://www.placeware.com/cc/microsoft/view?id=JUPBAG-48&pw=35DKTQ

Ideas para laboratorio MBI/EDRA+BTS

2005-01-14T23:49:00Z

1. Llamar desde una accion a BTS sincronicamente
2. Hacer un Output Provider de MBI que escriba en una cola y sacar la info con
adapatdor MSMQc de biztalk para inyectar una Orquestracion que registre BAM
El mensaje command tiene variable el request (any) pero se le puede fijar una propiedad
en MBi donde se indique el esquema del request. Se puede construir un patron
broker con BTS donde se filtra en los puertos de acuerdo con el esquema.
Otra forma es construir un pipeline donde se pueda leer esta propiedad por un handler
del pipe.

3. Modificar al target del pipeline de EDRA para que este envie al BRE el request
y este devuelva información respecto a la acción a ejecutar. De esta forma se puede
delegar al analista de negocio que accion mas refinada ejecutar.

Outlook Scenarios

2004-11-04T19:38:00Z

1.-Crear desde Outlook 2003 un mail con word 2003 que este formateado con un custom schema

2.-Transformar un Excel formateado con un custom schema en objetos de Outlook (tareas, contactos, citas, etc)

3.-Asociar eventos a algunos objetos de Outlook que puedan ser transmitidos por correo una aplicación central. Por ejemplo, cambio en una dirección de un contacto se actualiza en una aplicación centralizada.

Servicio de Notificaciones

2004-10-19T20:30:00Z

Ambito	Arquitectura de Aplicaciones
Descripción	Servicio de notificaciones que permite a los ejecutivos y a las aplicaciones suscribirse a notificaciones provenientes de otros sistemas tales como CRM , sistemas productos, canales internet, etc. Este servicio consta de servicio de notificaciones basado en un framework de notificaciones y de una pieza encargada de inyectar o buscar los eventos en los sistemas y formatearlos adecuadamente. El interface de suscripción a eventos puede ser Web a través de una API.
Enfoque	La arquitectura propuesta inicialmente para el Servicio de Notificaciones consta de los siguientes componentes : Cliente Outlook : responsabilidades (1) Es el receptor de las suscripciones; (2) Es el cliente desde donde el ejecutivo se suscribe ;(3) Puede ser una Web Part o un cliente rico Smart Client : responsabilidades (1) Es el receptor de las suscripciones; (2) Puede ser un control en el cliente rico Servicios de Notificación (NS) (1)Los suscriptores crean suscripciones ;NS recolecta eventos ;(3) NS hace match en entre subscripciones y eventos ;(4) NS formatea la notificación y la envía a un servicio de entrega Los eventos son generados por aplicaciones externas a NS. Extractor/Recolector de eventos: (1) Entrega al NS los eventos (2) permite definir formato de los eventos y Transformar de formatos de eventos (3) Generar consultas de eventos (pull) a las aplicaciones que sea fuentes de eventos; (4) Recibir de las aplicaciones eventos generados por ellas (push)
Objetivos	· Mejorar calidad relacion comercial · Integración de canales
Entregables	· Servicio de Notificaciones incorporado a la Arquitectura del Banco · Formación · Profile de una aplicación y configuración de Notificaciones para dicha aplicación.
Beneficios	· Aumento de la eficiencia de la gestión comercial · Aumento de la Satisfacción de los clientes
Riesgos Identificados
Problemas impactados	· Satisfacción de clientes · Productividad · Calidad de Servicio

Rol de la arquitectura

2004-10-15T22:07:00Z

Architecture is essentially the process of making the appropriate technological choices for the enterprise and its business units. These decisions concern the target architecture and technical standards or guidelines. It is not the role of architecture to decide when or where to spend the available financial resources — that is the job of strategic planning, which is primarily resource allocation.

The architecture team has the responsibility to reveal the opportunities, standards and migration paths that will yield the greatest benefit for the company. The decision, for example, to spend the money on an upgrade or consolidate two different styles of portals, as opposed to buying some new package, should be made by the strategic planners. The benefits of this attention to choices and technology consistency can produce favorable results.

Extensible Application Markup Language (XAML)

2004-10-15T05:08:00Z

XAML Schemas

The primary use of XAML is in the definition of Client User Interfaces, both describing the graphical layout of the interface, and tying user-Interface generated events to code. The introduction of XAML should hopefully replace the hidden block of “Windows Form Designer Generated Code” with structured XML.XAML will be fully supported in the Longhorn build of .NET, but until then, you can use a third-party Xaml viewer such as that from xamlon.
As with all programming languages, the best place to start is with a simple “Hello World” example, XAML should be no exception. Simply create a file named HelloWorld.xaml with the following content:

<?xml version="1.0" standalone="yes"?>
<Window>
   <Button>Hello World</Button>
</Window>