Watching the releases at WPC over the past 2 days, you can see how the frontier technology investments of a few years ago have weaved their way into the product fabric in a way not seen since the .Net vision many moons ago.

Specifically the investments in photosynth, deep zoom and sea dragon are starting to surface at the application layer like Bing, Windows Phone and the next wave of online services.

Like all MSFT apps, it isn’t the parts, but rather the synergy of the parts running together that bring the power -thus my metaphor of the perfect storm.

Take the new Windows Phone for instance. The integration of cloud functionality like the Office Suite and SharePoint, Bing and Silverlight bring a cohesive user experience beyond any business app that we’ve ever seen. What’s more, we require very little training for our dev team to build apps on top of this platform. We already dev using Expression/Silverlight, so programming for the phone is completely familiar.

Like the .Net framework, we’re still in early days in imagineering our next wave of apps. What we do know is that the possibilities just got a whole lot better.

We’re seeing a different adoption pattern of SharePoint 2010 then we did for the last release. In 2006, we had to convince clients that SharePoint 2007 was a release they could trust. New clients wanted to wait for the first service pack, and existing clients understood that this was a major architectural shift and upgrade would be painful.  Our job was to convince them that the new architecture and the 2007 features made it worth their while. SharePoint 2010 retains the same fundamental architecture, and a lot of work has gone into making upgrade a painless process. What we see is that our clients are now saying, “we like what we see, is there any reason not to upgrade right now”? This is a substantial shift in the mindset of the client. Many are moving forward on the 2010 RTM code base with the only caveat of ensuring existing 3rd party applications are compliant.

The Pre-Upgrade checker is a great utility and substantial improvement over its predecessor. Once upgraded, you have the option of maintaining the ‘Classic’ 2007 look and feel or upgrading to the new look. In a resent upgrade, this proved extremely valuable because we were able to upgrade the farm and allow site-by-site upgrades without disturbing the corporate ecosystem. No more curses to the IT department for forcing a new release on the user community. We’re getting rave reviews on both the enhanced feature set and improved ease of use. If you have SP2007 now, don’t be afraid to move upstream.

I speak monthly at Microsoft evangelizing Microsoft’s play in the BI and SharePoint space.  Often I showcase applications that clients already own, but didn’t realize it.  Here are a couple of dynamite plug-ins from the SQL Server team that participants often find useful.

This is a gem for anyone who is looking to perform deep analytics in Excel 2007. For an explanation click here: http://www.microsoft.com/sqlserver/2008/en/us/data-mining-addins.aspx. To download the app click here: Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007 

SQL 2008R2 launched a brilliant application known as PowerPivot. To learn more, click here: http://www.powerpivot.com/index.aspx.  Click here to download Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010 – RTM .

Stay tuned for more on the use cases for these tools in future postings.

I have come to write this article after being inundated with a barrage of bandwagon jumpers who are proclaiming to have found a new religion in Cloud computing. I attended EMC World in Boston and they have spent an inordinate amount of branding dollars on “The Private Cloud”. At a resent Microsoft ISV event they primed us with their Cloud story and let us know that when we attend the World Partner Conference in Washington DC next month, we’ll get a full dose of the Kool-Aid.

So what’s all the hype about? Haven’t we been down this road before? Let me break it down for you. What they are really talking about is pure and simple “outsourcing”. I happen to be a huge fan of outsourcing because I spent about 1/3 of my career working for a payroll services company and drove tremendous value for many enterprises by offering a variety of outsourced services. Of course back then, fax machines were in vogue and intercompany email was just evolving. I know, life before the internet, hard to imagine. Back then, we were very proud of our Wide Area Network (WAN). I think we were as proud of that as EMC is of the Private Cloud today.

In the late ‘90’s the internet was starting to emerge and everyone was getting a web presence. I realized at that time that setting-up and maintaining these environments was hard and “outsourcing” to a company that hosts web sites would probably be a good idea. So we started a web hosting company (before they were called that), and perhaps we were a little too early in the adoption curve because our investors decided that the internet was just a fad and pulled the plug before we could get the rocket off the ground. Notwithstanding our failed experiment, the idea was sound and as evidenced by the evolution that ensured, many succeeded.

So what is different between the internet hosting companies of the late ‘90s and today’s foray into the cloud? Well on one hand very little has changed and on the other hand a lot has changed (Editorial comment –it is statements like this that make me think I’ve spent too long in the consulting field). The scope of applications has broadened from simple Web Content Management (WCM) systems to pretty much any application in the cloud. Bandwidth is growing exponentially and becoming cheaper in the process. This is more true for our US neighbours than North of the border in Canada. So how do you determine if the cloud is right for you?

First let’s dispel a few myths upfront. Security is my favourite topic because it’s usually the first flag that is raised. A classic consultant trick is to use the security trump card when you know you’re wrong and the idea on the table is better than yours. It goes like this: “Well, yes I can see how that would work, but of course you understand it’s less secure”. So let’s get real about this topic. The biggest risk to security is internal, not external. I have walked into offices where the administrator credentials are literally taped to the screen of that highly secure system. The last time I checked, hosting centers don’t allow access to those pesky little USB sticks to copy files off-system with little or no detection. Having been behind the firewall of literally hundreds of companies, I can tell you that I would much rather trust perimeter monitoring and security hardening to someone who does this for a living than the many IT departments trying to do this on a shoestring budget.

Control –the other false sense of security. Based on anecdotal evidence, I would say at least ½ of the back-up routines that are run so diligently every night have never been tested in a fire drill, and most of those would never recover the data they were intended to recover. Don’t tell me this isn’t true, because I’ve lived in those environments (names withheld to protect the innocent). Then of course there are the mega disasters like Katrina that literally wiped out entire data centers, but I’ll try not to be too dramatic in making the point.

Many IT shops consist of a handful of superheroes and a plethora of monkeys. Their service level agreement consists of –I’ll fix it as soon as it breaks and I’ll dawn my superhero costume and do my best to minimize downtime after someone discovers that it’s broken. Don’t get me wrong, I’ve seen some really crack IT shops that frankly I am envious of. If you think I’m wrong about the number of shops that are less than adequate, let me ask you this question –how many companies have a really well managed Active Directory? The prosecution rests on this subject.

Economics is another myth that needs to be dispelled. In the interest of full disclosure, I believed outsourcing beyond a small business market to be too expensive too. About a week ago, one of our sales reps came to me to calculate cloud pricing for a 60 person Exchange and SharePoint deployment. I did a quick calculation –60 users was about $750 per month for Microsoft’s Cloud offering. I said, there’s no way the client will go for that. So I started calculating an in-house solution. I used a 36 month amortization schedule on the software, including Exchange and SharePoint only and I was up over $900 per month. I hadn’t even started to calculate hardware, set-up and the care and feeding of the server. Not to mention, the Cloud offering also included Office Communication Server. That’s when I realized; somebody in Redmond had already done the math and ensured it was more economical.

Ok, let’s be real, not everything belongs in the Cloud and if I were to use the Microsoft example, yes there are limitations to the offering. I’ve used SharePoint in the Cloud and my frustration was that I had no access to Central Administration –meaning, I could not install any of our super cool (if I do say so myself), custom web parts. Flipside, I set-up the site and had it running between me and the client in about 10 minutes. It cost me a whopping $24/month, on a $50k contract it wasn’t even a rounding error. Not to mention that we were able to keep the project on track because we were always working with one version of the truth. In this case the trade-off was simple. I had less flexibility, but virtually no headache. As the evolution of the Cloud unfolds, I can see where the functionality will be less and less limiting.

My next example was a client that required CRM, but was quoted $100k to get it up and running. For a 25 person company, that’s an ROI that could not be justified. In this case, they opted to have CRM in the Cloud and they had us install SharePoint on-premise. The orchestration of credential management was done by a company called Statera with a product called Stratus http://stratus.statera.com/. I will do a small shout-out to this company because they have solid technology and really great support. This kind of deployment makes a ton of sense. The light transactional CRM data lives in the cloud, and the heavy document management information lives inside the firewall on local servers. It is seamless from an end user perspective.

What is interesting is that Microsoft has now put a stake in the ground saying “we’re moving to the cloud”. I’ve always said, Microsoft gets it right on the third try and by the forth try, they own 90% the market. Right now, they’re at about the second try, depending on the business application you are working with. Reading the tea leaves, they are poised to do something great in this space over the next couple of years. For now, I would consider hybrid solutions where it makes sense. For example, moving democratized applications like your Exchange server to the cloud is a no-brainer for most organizations. OCS seems like another natural candidate. Most individuals use Microsoft Messenger within enterprises that still allow it (incidentally, this is a huge Cloud app). Why not get some governance in place and use OCS instead?

Bottom line –this is an evolution, not a revolution. Pick what’s right for your enterprise and start working with the cloud.

In retrospect, it is obvious that when you save a site as a template it lands in the Solutions gallery as a .WSP file. I say it’s obvious, because when you save the site, the dialogue box says “Open Solutions Gallery”.  However, for those of us who have the 2007 UI burned into our brains, we instinctively look for the .STP file and the Site Gallery. Well, both are gone in favour of the solutions gallery.

A couple things I noted –the solution name (i.e. the file name you give the .WSP file) is what is used when you pick your custom site template.  The title seems irrelevant as it isn’t displayed anywhere. So name your files appropriately because that’s what your users will see.

This solution deployment structure would seem support the ability to author and deploy solutions to a site collection without the need access central admin (a form of sandbox solution).  I presume this was done to support the cloud version of SharePoint.

It appears there is a bug in SharePoint 2010 when you use underscores in the document library name. It is fairly nasty in that you can’t simply delete the library and start over. You cannot access the library via View All Site Content, or Manage Content and Structure or SharePoint Designer. Fortunately in our case, the site was new, so we blew away the site and started over.

This also raises a best practice for library creation.  When you create a library, it’s best to use a simple single word title so that it gets embedded in the URL.  Once the library is created, you can give it a more verbose name.  That way the URL stays compressed and the document library can have a more descriptive title.  It also prevents the bug described above.

The new SharePoint upload control in Windows 7 now supports metadata passing between SharePoint Document libraries, when using the “Explorer View” drag and drop feature in SharePoint. My use case was simple –create a duplicate SP Doc library of content containing documents that had been extensively tagged. I created doc library template from the original doc library and created a target library from that template (note: Include content would not work due to the size of the original library). I opened both libraries in separate browser sessions in “explorer view” (which launches the new Win7 upload control), and simply dragged all of the files over. When I opened my new target library in All Documents view, I found that all of the metadata was completely preserved. The file dates were not preserved, but in this use case, this did not matter.

Wow -this one really got me!  When you edit a SharePoint page using IE8 the browser would hang for 20 seconds until it timed-out with the an alert “You are about to navigate away from this page without saving your content…”. It turns out that IE8 has the following setting turned-on by default: ‘Enable native XMLHTTP support’.  

Fortunately IE8 allows you to turn off this advanced setting by selecting Tools/Internet Options/Advanced and un-checking the setting.
 
© 2011 Ed's Blog Suffusion theme by Sayontan Sinha
Blog WebMastered by All in One Webmaster.