Notes from Roundtable on Impact of Cloud on eDiscovery

Notes from Roundtable on Impact of Cloud on eDiscovery

This week I participated in a leadership breakfast hosted by the Cowen Group. The breakfast was attended by lawyers and IT personnel from a variety of industries including media and entertainment, manufacturing, law, electronics, healthcare, utilities and more. The point of the roundtable was to discuss the impact of cloud computing on eDiscovery and included […]

SQL Server Management Studio: Dynamic Folders

SQL Server Management Studio: Dynamic Folders

One of the problem with SQL Server Management Studio is it shows the objects in one list. For example, see the list of stored procedures for the BizTalkMsgBoxDb database, one of the BizTalk database.
It is a huge list. Smart developers are trying to make this list useful and searchable and use suffixes and prefixes to group the objects together.
See prefixes “adm_” and “bts_”. Following this practice we have got the nested compound prefixes. See the subgroups after the “bts_” prefix.
It is completely and absolutely awful view.We have to scroll down and up this listto find out the right object.
The same lists are for others SQL objects.
But it can be much better with small change.
Let’s create the virtual dynamic folders.
Now the list is short, easy searchable and easy observable. Moreover, the long awful names are folded to something readable. Yes, now the names are readable.
All we can do tothis beauty is to set up the parameters for thesevirtual dynamic folders.
Right-click the “Stored Procedures” folder and choose Properties / Dynamic Folders
There are only few parameters to set up:
%u00b7 Objects to fold, more than X (auto by default)
%u00b7 Characters to fold, more than X (auto by default
%u00b7 Show full name (unchecked by default)
Folders are smart enough to fold with good taste and intellect. But sometimes it helps to fold objects with unusual name conventions.


BizTalk and Gartner Oct’2010

BizTalk and Gartner Oct’2010

Gartner’s Magic Quadrant for Application Infrastructure for Systematic Application Integration Projects (October 2010) places Microsoft in the leader’s quadrant for integration, with BizTalk Server and the global integration platform, as the company with a clear lead in the ability to execute dimension.
Gartner_Oct2010

Gartner’s report can be found here with all the details. Check the Microsoft section to learn about the strengths and cautions to have. Some interesting details are: “the least-expensive perpetual license of commercial offerings that Gartner analyzed”, “BizTalk Server installed base of more than 10,000 customers – two-thirds are estimated to be BizTalk Server 2006 Enterprise Edition”, “Microsoft garnered 13 % of the ESB suite market software revenue” or the ever important skills question: “results in the availability of skills, services and add-ins”.

BizTalk Server 2010 Adapters

BizTalk Server 2010 Adapters

If you wonder where all adapters for BizTalk are or which ones are available when you have install DVD in virtually in your hand. There are two directories on DVD (after you mount it with something like ISO mount). One called BizTalk accelerators and one named BizTalk Server. Both folders contain a setup and when you run it a splash screen will appear.

BizTalk 2010 Install

In accelerators splash screen you find links to install:

  • Accelerators for HL7
  • Accelerators for RosettaNet
  • Accelerators for SWIFT
  • FileAct and Interact Adapters for SWIFT

Other splash screen that appears after running setup in BizTalk folder you will find links for:

  • Installing BizTalk Server
  • Installation UDDI
  • Installation RFID
  • Installation RFID Mobile
  • BizTalk Adapters (LOB Adapters)
  • AppFabric Connect

It can be annoying that you will have to find out what to install when looking for particular adapter. When installing BizTalk Server you will get the out-of-box adapters (HTTP, WCF-Adapters, SQL, FILE, FTP, ect), Adapter Pack contain ERP adapters (SAP, Siebel, Oracle, Oracle EBS), and other adapters like for instance MLLP (HL7) are found in appropriate accelerator. When installing Adapter Pack the necessary prerequisites are handed to you during installation (see my post Installing BizTalk Adapter Pack 2010 on x64). Still there are adapters that you have to download separately like one for Microsoft Dynamics CRM 4.0.

Documentation however is a different story. By clicking installation guide html page in accelerator folder you get access to installation guides by links.

Install guides

Other documentation if found at Microsoft:

Finally for BizTalk Server itself there is documentation available for installation (divers Operating Systems), and the product.

Technorati:

Started a New Blog

Started a New Blog

After a long period of inactivity, decided to get active again on the blogosphere. This time however, it’s not (just) going to be BizTalk, (I’ve lately been through some “Identity crisis” so) you will see me talking about how to protect your identity, get help through “Identity Federation”, asserting your identity, using “Proxies” etc. So thought of creating a new Identity for myself here, instead of using my old identity. 🙂

Check it out: http://blogs.msdn.com/benny/