Ginneblog

We got the word on Friday, April 16, that Microsoft SharePoint 2010 was released to Manufacturing.  Check out what the SharePoint Team Blog has to say about it.

You can sign up here to watch the Office 2010 + SharePoint 2010 Virtual Launch event coming on May 12.
 
Here in San Francisco, the DesignMind team is very excited about this release. Our clients will now be able to leverage many of the new features. Our team will be able to do more custom development, with less effort, than MOSS 2007 required.
 
We’ve also been waiting impatiently because we will soon be re-launching  the designmind.com site, using SharePoint 2010 as the platform.  I’ll let you know how that goes, as our own launch date approaches.
 
In the meantime, congratulations to the Microsoft SharePoint 2010 team for some really great work! 

Here’s Huey Lewis at the SharePoint Conference 2009.

 Send to Twitter

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

At the November 2009 PASS Summit in Seattle, one of the outstanding keynote presentations was by Dr. Dave DeWitt, Microsoft Fellow, and leader of the Microsoft Jim Gray Systems Lab, in Madison, WI.  I received a copy of his slide deck from PASS Headquarters, which you can see below.

Dr. DeWitt is working on releases 1 and 2 of SQL Server Parallel Database Warehouse.  In his keynote he reviewed the 30 year history of CPU, memory, and disk performance.  Variations in performance gains across these subsystems, with disk performance lagging badly, have major impacts on database system performance.

Disk performance gains have been made in three areas, Capacity, Transfer Rate, and Average Seek Time.  However, the gains over the last 30 years have not been uniform.

Capacity of high performance disk drives has increased by a factor of 10,000.  Transfer rates have increased by a factor of 65.  The average seek time has only increased by a factor of 10.  Dr. DeWitt talked about the impact of these discrepancies on OLTP and Data Warehouse applications. 

One of his conclusions is that some problems can be fixed through smarter software, but that “SSDs provide the only real help.”

Fusion-io

We learned more about SSD’s during the Fusion-io presentation to the Silicon Valley SQL Server User Group.  The DesignMind team has also been evaluating SSDs to determine situations where we can provide our clients with the most leverage.  Plus here’s a terrific video which shows SSD’s in action. 

 Send to Twitter

Ron Lichty spoke to SofTech recently.  His presentation, Making Your Software Development Hum, contained a lot of useful information for software professionals.  Since I manage DesignMind’s custom software development and database teams, I found this topic particularly interesting and valuable. 

Ron learned his trade at companies like Apple, Schwab, Berkeley Systems, and Avenue A/Razorfish.  He’s Co-chair of SDForum’s Emerging Technology and Software Development Best Practices Special Interest Group.  I’ve known Ron since the dot-com boom, and over the years have seen him leverage his large development community following to raise a lot of money for charity, an effort I’ve always admired.

Software development is difficult to be good at individually, and even harder to perfect as a team.  This is a discipline where you have to deliver something that works, and if you don’t, it’s obvious.  What’s not so obvious, though, is whether you got the job done as well as you could have.  It’s worthwhile to look over Ron’s slides and see his suggestions for making your software development efforts more productive and enjoyable.

If you missed Ron’s presentation to SofTech, he’ll be presenting to the East Bay Innovation Group on October 7, 2009.

You can learn more about SofTech’s upcoming meetings here.  SofTech is a San Francisco Bay Area business and technology networking group.

 Send to Twitter

Wouldn’t it be great to sit down next to your client and sketch out ideas?  Now there’s an online, user-friendly tool called Balsamiq Mockups that allows you to do that remotely.

Balsamiq Mockups helps you and your team or clients iterate on wireframes as early in the process as possible, when it’s cheapest to do so.  Not surprisingly, it was developed by a former Macromedia/Adobe software engineer.  

Balsamiq Mockups hits the bulls-eye for firms like DesignMind.  We can use this inexpensive tool to rapidly create mock-ups of both desktop and web applications.  It’s got a lot of power, and is easy to learn.  One of the really great ideas in this tool is that the prototypes look hand-drawn.  This informal appearance makes stakeholders more comfortable about giving the developers early feedback, which is so incredibly valuable.

I learned about Balsamiq Mockups last week when Don Robins spoke to the San Francisco .NET User Group.  (Don, a principal at Outformations, gave a great overview of SQL Server Compact Edition.)   

Software Application Developers have long struggled with ways to help their clients visualize what an application will look like, early in the project.  These days developers communicate their user interface designs in many ways, all the way from whiteboard sketches, Visio diagrams, Excel, and at the high end, complex software visualization systems such as iRise.

If you aren’t doing prototyping, or if you’re using the paper, Visio, or Excel approach, you can elevate your development process easily with this product.  Thanks to Don for spending some of his presentation demonstrating the Balsamiq tool.

 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

In my recent post on how MySpace is using SQL Server, I mentioned that the original MySpace.com was built with ColdFusion.  Even though MySpace moved to Microsoft .NET, there’s a very active ColdFusion community, fostered by Adobe.

As luck would have it, I had a chance to spend some time this week with ColdFusion guru Raymond Camden.  He’s co-author of the ColdFusion MX Developer’s Handbook, Mastering ColdFusion MX, and the Adobe ColdFusion 8 Web Application Construction Kit.  Along the way Ray has contributed to roughly a dozen other ColdFusion-related books.  He also runs several technical websites, and blogs at ColdFusionJedi.

Ray was here in the San Francisco Bay Area working with Adobe as they prepare for Adobe MAX 2009.  Ray will be a featured speaker at the conference, which will be held from October 4-7 in Los Angeles.

Our time was spent preparing for, and delivering, a presentation on migrating from Oracle Forms to ColdFusion – something we hope to be doing for an upcoming project.  We are also teaming up with Peter Koletzke, co-author of Oracle Developer Advanced Forms & Reports and Oracle JDeveloper 10g for Forms & PL/SQL Developers.  I’m very excited to have Ray and Peter, leading experts in their respective fields, working with the DesignMind team.

 Send to Twitter

Earlier this month Microsoft released the first beta of a new free tool – the IIS Search Engine Optimization Toolkit – that makes it easy to perform SEO analysis on your site and identify and fix issues within it.

Scott Guthrie’s excellent blog tells all about it.  Thanks to E.R. Gilmore at Travis Medical Software for pointing it out to me.   The new SEO Toolkit looks incredibly useful, and at DesignMind we’re starting to test it out on several client websites.  I’ll report back on its effectiveness.  I’ll also try to arrange a demo of this toolkit at an upcoming meeting of the San Francisco .NET User Group.

Scott Guthrie runs the development teams at Microsoft responsible for ASP.NET, Silverlight, WPF, IIS, and various Visual Studio Tools.

 Send to Twitter