Fourth Largest US Stock Exchange, Direct Edge, Looks to SQL Server Parallel Data Warehouse for Big Data Needs

http://blogs.technet.com/b/dataplatforminsider/archive/2011/06/03/fourth-largest-us-stock-exchange-direct-edge-looks-to-sql-server-parallel-data-warehouse-for-big-data-needs.aspx

  • Recent tests on their data showed dramatic gain in performance, with up to 163 times improvement in query performance and data loading speeds of up to 1 TB per hour
  • In addition, their testing data shows the solution generates reports in under 15 minutes, for what used to take over four hours

Also posted on information week – http://www.informationweek.com/news/software/info_management/229900133

Blog Post by: cvidotto

BizTalk 360

BizTalk 360

I assume anybody in the BizTalk space would have known BizTalk 360 by this time. I though I’ll just give my view of the product here. BizTalk 360 tries to address some of the real challenges we face on a BizTalk environment, especially controlled environments like Production and Test environments. There are 3 core features […]
Blog Post by: Randal van Splunteren

Maximize your BizTalk Server investment using BizTalk 360

In this post we will see a scenario where customer who are using Microsoft BizTalk Server can maximize their investment by reusing the environment for multiple business units/departments or projects by taking advantage of BizTalk 360 fine grained authorization.

Scenario: Let us take a scenario, where Woodgrove bank has made a huge investment in Microsoft BizTalk Server and they got 3 core mission critical applications "Loan Processing", "Mortgage Processing", and "Personal Account"deployed in their environment as shown below.

After a while there is a new requirement to build 2 new BizTalk applications to deal with "Business Accounts" and "Credit Card Processing". But the challenge here is these two applications will be developed and supported by a completely different business units (Business accounts department). They also aware the new applications are NOT high volume, and the current production environments are capable of taking the additional load.

The biggest concern for them is on supporting the applications and making sure business units are not interfering or seeing each others data.

Here are the challenges and options the bank faces

1. The simplest option will be to build a brand new environment for the business account department to deploy these new applications. This will solve the problem but it comes with additional cost and managing additional environments.

2. Take the risk and deploy all the applications in the same environment and hope your support staff will behave nicely.

BizTalk 360 to the rescue:

BizTalk 360 tries to address this problem seamlessly by providing a fine grained authorization module. It allows administrators to setup customized user access policy as shown below.

 

You deploy all the applications in a single BizTalk environment (provided you got spare capacity or you know the applications will be used in different times of business etc) and set the user access policy appropriately. In this scenario the administrator will provide users with appropriate application rights based on the business units/departments as shown above. In addition he can set other access rights like (access to BAM, EventViewer, Global Query etc) making it really powerful. If required the administrator can provide only READ-ONLY access to certain users for the applications.

The administrator can view all the user access policy for the environment anytime as shown below via the admin module.

Administrator View:

Administrator will be able to view all the applications deployed in the environment. He/She can query against instances across all the deployed BizTalk Applications as shown below.

Users from Business Unit 1 (Ex: Personal Account):

Users from personal accounts department will only be able to see applications related to them. In this case that is "Loan Processing", "Mortgage Processing" and "Personal Account"

Users from Business Unit 2 (Ex: Business Account):

Users from business accounts department will only be able to see applications related to them. In this case that is "Business Account" and "Credit Card Processing"

Instances restricted at application level

Once the user access policy is setup, the users will be able to query instances (running, suspended etc) only at application level. They won’t have ability to see the instances for which they don’t have access to.

In the below screen shot you can see the query instance module restricted to "Loan Processing" application.

Social:
twitter: @biztalk360
facebook: http://facebook.com/biztalk360
support: http://getsatisfaction.com/biztalk360

Note: BizTalk 360 is a web based (RIA) application, built using Microsoft SilverLight. The above screens are accessible via browser. There is no necessity to install anything on the client PC except Microsoft SilverLight.

Nandri!

Saravana

Windows AppFabric ServiceBus: Counting the costs….

While on a journey of trying to dispell some of the unknown magic surrounding the Azure/AppFabric/ServiceBus and Web/Worker Roles, I was hit with a challenge of:

“How much will my ServiceBus Connections cost me? How is Cost calculated? is it
cost effective?”


Yes and No.

So – quick one on ServiceBus. It allows you to auto-create an cloud based endpoint
to your on-premise application (you can also control how client requests/messages
are distributed through your endpoint, direct, multicast and queued)

The costings……

Richard has a great article here and
there’s the updated
FAQ
to guide you through.

Some key points:
– a ‘Connection’ is defined as either your application connecting OR one of your clients.
– a maximum of 2000 concurrent connections are allowed per ServiceBus namespace.
– you are charged on the average number of connections through the day/month
     – # of connections are sampled in 5 minute intervals and
must be connected longer than 10 secs (as per the current FAQ)

– DATA Charges are EXTRA to above.

(This has the distinct feeling of early mobile phone plans where there were so
many moving parts and bits you paid for, that it was almost impossible to calculate
your monthly spend.

Azure definately needs caps and plans rather than sting you every step of the way)

So the situation I am currently facing is potentially a high volume public facing
port.

One solution to this is:
– use a webrole with it’s own endpoint the clients call into.
– Webrole talks to SB Endpoint
– SB endpoint talks to onpremise

Costs: DATA In/Out + Webrole + 2 SB Connections(for starters).

There’s a couple of cost calculators here:
– http://www.microsoft.com/windowsazure/pricing-calculator/

– http://azureroi.cloudapp.net/

Check them out,

Still unravelling the mysteries of the Cloud…

Blog Post by: Mick Badran

Visio 2010 Stencil for BizTalk Server Updated

Visio 2010 Stencil for BizTalk Server Updated

After the unexpected success of my previous post and some requests, I decided to spend half of my weekend to improve the stencil by adding more artifacts. The result is 26 new shapes of a total of 37, representing: BizTalk topologies (Standalone and Clustering) BizTalk Runtime Architecture and ESB Toolkit Receive and Send Pipelines, Inbound […]
Blog Post by: Sandro Pereira

Attending BizTalk User group meeting in Sweden on 13th June.

I’m flying out to Sweden this weekend to attend the Sweden BizTalk User group meeting. This time it’s Richard Seroter and Kent Weare flying from other side of the Atlantic to show us what we should know when integrating with line of business systems. Steef-Jan Wiggers from Netherland is also coming to the event. So, it’s going to be a great catch up with fellow BizTalk Server MVP’s Johan Hedberg, Mikael Sand, Mikael H?kansson, Alan Smith

If you really got any burning questions related to BizTalk, this is the best possible opportunity  to clarify it.

Here are the details of the meeting, not sure if there are any availability, but worth trying at http://swebug20110613.eventbrite.com/

Details:

Top 10 Things to Know When Integrating with Line of Business Systems

Monday, June 13th at Microsofts office in Akalla.

Session 1 at 18:00

Session 2 at 19:30 to around 20:30.

On the side note, if anyone interested to learn more about BizTalk 360, or like to see a live demo. Please let me know either via the blog or one of the contact options at http://www.biztalk360.com/Content/Contact.aspx. I’ll be there between 11th June to 14th June. So, there is plenty of time to catch up.

Regards,

Saravana Kumar