Ginneblog

Captain Kirk - a cloud pioneer

By default, when you upload a document or any other large file to SharePoint, it gets stored as a Binary Large OBject   (BLOB) in the content database in SQL Server.  As revisions are made, each version of that file also gets stored (not just the differences).  The amount of BLOB data grows significantly faster than associated metadata, causing SharePoint to consume large amounts of expensive SQL Storage space.   Burzin talked about externalizing BLOB storage, as well as options for storing infrequently used BLOBs in the Cloud.  These approaches can help ease the backup and storage cost problems content-heavy SharePoint sites encounter. 

Burzin’s SharePoint Storage Best Practices talk also covered Configuration, Maintenance, and Performance Tuning.  He explained some of the unusual stresses SharePoint puts on SQL Server, and offered suggestions on how to avoid degraded performance.  If you’re planning a significant SharePoint implementation, you’ll want to take a close look at his specific recommendations regarding recommended I/O Capacities, Database configuration and sizing, processors and memory. 

Given the headaches SharePoint BLOBs cause in many organizations, it makes sense that StorSimple has a complete solution to externalize them. Their storage-on-demand appliance provides tiered storage for SharePoint with the option to secure and store infrequently updated BLOBs to the cloud to achieve substantial cost savings.  According to Ursheet Parikh, StorSimple’s Founder and CEO, Burzin’s extensive SQL Server and SharePoint experience make him a key member of the StorSimple team. 

I’ll write about StorSimple’s product in an upcoming post, and will follow that with a case study once DesignMind has had a chance to implement StoreSimple’s Cloud Storage Solution for one of our clients.  For data storage, Space is the Final Frontier.

 Send to Twitter

Fusion-io is bringing a whole new meaning to SSD – Super Speedy Database.

Last week I had lunch with Sumeet Bansal, Fusion-io’s Principal Solutions Architect. Fusion-io is a producer of enterprise-class SSDs (Solid State Drives, as opposed to HDDs – Hard Disk Drives). Fusion-io applies flash memory to large-scale enterprise storage products like Storage Area Networks. I first met Sumeet when he was VP of IT at Wine.com.

Part of our discussion was about their products, and how they differ from the competition.  SSDs can be very fast.  They can also be pretty rugged, as they have no moving parts.  They are more expensive per GB than conventional hard drives – at least for now.  SSDs eventually wear out – each spot on the NAND Flash Chip can be exercised a finite number of times before it stops working.

Key points regarding Fusion-io’s  ioDrive:

Performance of NAND Flash Chips is extremely fast. Read latency is an order of magnitude faster than conventional HDDs.  But the Fusion-io ioDrive removes the IO bottleneck and makes the cpu utilization more efficient.  Fusion-io decided to adopt a PCIe architecture rather than dealing with the multiple layers of protocols necessary to implement a SATA interface.  I reviewed performance results at HotHardWare, and it’s clear that they are getting a big performance advantage.

They have the wear under control.  Their controller spreads the “wear” across the entire drive, giving them excellent life (1.2 million hours MTBF!)

The rest of our discussion was around how the ioDrive could be used most effectively on different platforms we work with a lot at DesignMind. There is work to be done regarding Best Practices for implementing SSD technology for SQL Server, SharePoint, Exchange, and other key Microsoft Server tools.  We look forward to working with Fusion-io to help them develop Best Practices, Performance Benchmarks, and Case Studies.

 Send to Twitter

A prospective DesignMind client in San Francisco is making modest use of SharePoint 2003, and is considering a move to MOSS 2007.  The reasoning is good. They can do an incremental rollout, and gain immediate value from SharePoint’s ability to index documents, including PDFs.

In preparation for the meeting, I had to refresh my memory in two very important areas.  First, I needed a Comparison of the features of SharePoint 2003 with those of MOSS 2007. 

The second major question to answer was which features are included in each version of SharePoint?  

Here’s another useful site Comparing WSS and MOSS. 

The last gem I uncovered was an excellent PowerPoint file covering the Functionality in MOSS 2007 and Office 2007.  This is a great resource for those thinking about leveraging the integration Microsoft has delivered in these two major toolsets.  It will help us make the right recommendations to our clients when it comes to purchasing Standard vs. Enterprise Client Access Licenses. 

No doubt there’s a ton of information to sift through on MOSS.  Next I’ll look forward to reviewing the comparisons between MOSS 2007 and SharePoint 2010.  I must say I’m pleased that Microsoft is making our lives easier by by shifting back to the name SharePoint rather than MOSS…read my June 3rd Ginneblog post for more on the rollout of SharePoint 2010.

 Send to Twitter

Chances are, you’re either sick of hearing about Twitter or you’re tweeting.  Well I’ve been tweeting for about two months now and it’s already paid off. Twitter is easy, informative, and it’s a great way to stay in touch with my software network.  You can view my Twitter profile here. 

Twitter is on fire.  In March it had 9.3 million visitors, up 131% from 5 million visitors in February.  And do you want to know something really fascinating?  The most active folks on Twitter are in the 45-54 age group.  You can read about it on the comScore blog.

Twitter Users by Age Group

Right now I’m following 387 people and 199 are following me.  That means I see the tweets of the 387, and 199 of my digital admirers see mine.   I follow people that have similar interests and are in the same loops. You need to have something in common with your Tweeple, and for me, it’s primarily business related.  How did I find them?  Easy, just go to search.twitter.com 

A few weeks ago, someone who knows me saw one of my tweets and it prompted him to drive about 60 miles to the Silicon Valley SQL Server User Group meeting I was hosting at Microsoft in Mountain View.   He wouldn’t have learned about the meeting otherwise.  I must admit, I was impressed by the power of Twitter.

There are a few folks who I enjoy following on Twitter, like Brad McGehee. Brad was just in San Francisco in March, but he travels worldwide in his role as a SQL Server evangelist for Red Gate Software.   Thanks to Twitter, I know that Brad attended the European PASS Conference last week and is on his way home to Hawaii.  Brad tweets on the latest news in the SQL Server world, including new books coming out and news from his latest blog posts.

Other folks I follow on Twitter are Tech Bubble (that’s Nik Kalyani of DotNetNuke),TechWatching, ProWebDevBlog, TechCrunch, MSFTBizBuilder, SharePoint Buzz, Database Journal, and (why not) Lance Armstrong.

Tune in later this week when my next blog post will be an interview with San Francisco Bay Area Twitter guru Ted Prodromou on the hows and whys of using Twitter for business.   

 Send to Twitter

Montreal, Quebec

I wish I were attending the SharePoint Summit conference in Montreal this week. We use it at DesignMind. It really enhances our collaboration and content management processes. It’s no wonder that Forbes Magazine calls SharePoint the “Ultimate Business Timesaver”.

According to InfoWorld, MOSS (Microsoft Office SharePoint Server) 2007 is the fastest growing product in Microsoft’s history and has “as many uses as a Swiss Army knife”. Its six focus areas are collaboration, portal, search, ECM (enterprise content management), business process management, and business intelligence.

Ford Motor uses SharePoint for its dealer portal, and the Marines have deployed collaborative applications to aid their efforts in Iraq. In Scotland, the entire K-12 education community is connected via SharePoint.

The great thing about SharePoint is that it offers a single environment for all your information and collaboration tasks and it’s easy to learn, use, and personalize. It has a single platform and well-integrated set of technologies to manage and lower user support requirements. Can you tell I’m a big fan?

I’m also a fan of Formula One racing, so the following bit of news made me particularly happy. If you like fast cars check out the new Ferrari.com site which was built with MOSS 2007.

Ferrari F430

 Send to Twitter