Ginneblog

Microsoft is launching SQL Server 2008 R2 on May 25, 2010 at the Santa Clara Marriott.  Attendees will get have the chance to learn about the new features, ranging from PowerPivot for self-service BI to StreamInsight, the latest version of Microsoft’s flagship database product. 

You can register for the free all-day event SQL Server R2 Launch Event here.   

Tom Casey, Microsoft’s General Manager for SQL Server BI will deliver the keynote for this event.  It looks like I will have the privilege of introducing him.  During my introduction, I will provide the details about our new PASS Chapter, the Bay Area Microsoft Business Intelligence User Group.  

Here’s a recent interview with Tom Casey on Microsoft’s BI Strategy in SQL Server Magazine.

If you’re interested in learning about StreamInsight, contact me for slides from the May 2010 Silicon Valley SQL Server User Group meeting with Mark Simms of Microsoft’s esteemed SQLCAT.

 Send to Twitter

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

Geek extraordinaire Fred Davis shared the coolest, wackiest gadgets of 2009 at SofTech’s 5th Annual Gadget Night. Fred is Co-Founder and CTO of Grabbit, and an award-winning tech journalist, entrepreneur, and gadget enthusiast.  His past lives included stints at Ziff-Davis, Wired, and CNET.  Fred’s annual presentations to SofTech are among my favorites.  He was accompanied by his fiancé, Lisa Padilla, host of  Lisacast.com.

iPhone 3G

Joining me during last night’s introductions were Suzanne Skyvara, of Women in Consulting’s North Bay Chapter, and Harry Chapman of the Bay Area Consultants Network, as both of these organizations helped host the event.

Fred talked about cell phones (iPhone, Palm Pre, and Motorola Droid), eBook Readers (Kindle 2 and DX, and rumors of Apple’s upcoming entry into this space), netbooks, HD TVs and associated products, digital still and video cameras, and other miscellaneous gadgets.

The Duracell Instant Power Charger, at $15.99, would be a great stocking stuffer.  If you have a lot of hungry mouths to feed, ask Santa for a Chefstack Automatic Pancake Maker, which can crank out 200 pancakes per hour.  Just the thing for those 6th grade sleepovers!

Chefstack Automatic Pancake Maker

And for the tech fan who has (almost) everything, there’s also the Husqvarna Automower (a Roomba on steroids!) 

 Send to Twitter

I just had to share this terrific demo of the ioDrive in action.  Here’s Father Robert Ballecer interviewing Fusion-io President and CTO David Flynn.

Father Robert is a Jesuit Priest.  The video was produced by Tech Stop at the Center for Apostolic Technology, headquartered in San Jose, California.  How cool is that?

Sumeet Bansal of Fusion-io will speak to the San Francisco SQL Server User Group on November 11, 2009.   We’ll be at the Microsoft office on Market Street in downtown San Francisco.  Please consider joining us.

You can see more from Father Robert on the Gadget You Tube channel.

 Send to Twitter

Perhaps you’ve heard this astonishing figure.  At Amazon.com, every 100 ms of latency costs the company 1% in sales. Sumeet Bansal, Principal Solutions Architect at Fusion-io, referenced the Amazon study as he separated myth from reality about Solid State Storage and its role in the modern Database enterprise system.  

Fusion-io is a producer of enterprise-class SSDs.  Their silicon-based storage architecture known as ioMemory applies flash memory to large-scale enterprise storage products like Storage Area Networks.

Sumeet’s presentation to the Silicon Valley SQL Server User Group on Tuesday included a variety of reasons why SQL Server  DBAs, as well as other technologists, should be excited about SSD’s.  He stressed that SSD’s are ready for the enterprise today.  His description of the things to look out for when purchasing SSD’s was quite useful – kind of like the Consumer Reports of SSD’s.

This list of differentiators is probably part of why Steve Wozniak joined Fusion-io as Chief Scientist – “the Woz” wouldn’t put his energies into anything but the most promising technologies.  And neither would Sumeet, who came over to Fusion-io from Wine.com, where he was VP of IT at the San Francisco company.

David Leston walked away happy, and probably stayed up very late installing his blazingly fast 320 GB Fusion-io Solid State Drive (SSD).  He won the coveted door prize, which was generously donated by Fusion-io. 

I hadn’t met David before tonight, but he was on the same wavelength as our speaker.  Sumeet’s discussion of SSD’s pointed out that you don’t purchase SSD’s based on cost per GB, but rather by the value of the performance gains and reliability. 

It was particularly interesting to hear comments from the audience about how Microsoft and other vendors will start optimizing performance based on SSD-equipped systems, in addition to conventional drives.  Right now there’s an assumption of significant latency when going to the drive.  As the operating systems see great reductions in latency, additional optimizations will add to the performance gains of this breakthrough technology.

 Send to Twitter

Christa Stelzmuller, Chief Data Architect at MySpace.com, spoke Wednesday night to the San Francisco SQL Server User Group about the MySpace Service Broker.  Last summer, Christa spoke to the Silicon Valley SQL Server User Group about the MySpace Data Architecture.  MySpace is an amazing example of what can be done with SQL Server.

Christa started her presentation with a description of Service Broker, and the challenges they faced creating it.  She then covered basic features, advanced features, and the major use cases.  She concluded with a roadmap of their continuing development plans, and some fun examples of how their developers have sometimes used Service Broker to solve their problems in somewhat misguided ways.

Keep an eye out on CodePlex, where her team will be posting their work.  We’ll get a chance to speak more with Christa in early November at the PASS Community Summit in Seattle.

 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

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

Alex Viera, John Hanson, Mark Ginnebaugh, and Paul Bertucci

We had a full house at last week’s SQL Server 2008 Migration Workshop with 55 folks in attendance. The event was at the Microsoft office in San Francisco where Alex Viera was our host. John Hanson of DesignMind and well-known SQL Server author, and Chief Data Architect at Autodesk, Paul Bertucci led the 3-hour workshop, which included a walk through the steps of a successful migration.

The crowd at the workshop included folks from AXA Rosenberg, Chevron, Clicktime, Intuit, Ninth Circuit Court of Appeals, Onyx Pharmaceuticals, Opentable.com, Symantec, Shop.com, Sun Maid Growers, UCSF Medical Center, Varian, and Visa.

You can take a look at the slides from John and Paul’s presentations on SlideShare.

• Migrating to SQL Server 2008 (John R. Hanson)
• Migrating to 2008 (Paul Bertucci)

Some of the areas John and Paul covered were:

• How to reduce database costs through consolidation
• Virtualizing servers
• Compressing data
• Allocating resources more effectively
• Effective policy management 

According to Jeff Van Vliet , “the most valuable thing I learned was information on deprecated key words and existence of lists and support from Microsoft on the deprecated items for each new release”.   Also, “I liked the fact that they spent time talking about what also worked in 2005, as most of my clients are still using SQL 2005 (one major client just migrated from SQL 2000 to SQL 2005). If my clients are indicative of average enterprise level clients, they lag by a version or so, typically.”

Microsoft San Francisco, 4-29-09 Migration Workshop

Rick Griest of Systron liked, “the complexity of searching through legacy code looking for all SQL calls. It became obvious that it would be easy to overlook an entire block of calls if they were in an unusual format.  Also, the talk time during intermission was pretty exciting for me and I wouldn’t have minded possibly a little more”.  Rick also suggested that Anchor Steam would be a welcome addition to any future workshops…

 Send to Twitter

MySpace.com uses SQL Server in a big way. On Tuesday night MySpace Chief Data Architect Christa Stelzmuller spoke to the Silicon Valley SQL Server User Group in Mountain View. We had a record turnout. This was a rare opportunity to learn how a high profile company is using SQL Server to manage very large data.  And I mean large – think 130 million active users a month!

It’s pretty well known that MySpace.com started out as a two-tier system. They used ColdFusion on the front-end, and SQL Server at the back-end.  Traffic grew radically, and the technical team scrambled to adapt. Over the years, the technology has matured, but we’re talking about big data, heavy traffic, and continued rapid growth. 

Christa Stelzmuller and me at Microsoft

Now ColdFusion is gone, replaced by C# and ASP.NET. They added a middle tier, and are running mainly on SQL Server 2005, Standard Edition, with a few instances of Enterprise where required.  They have about 4 petabytes of disk space, spread across 17,000+ disks.  You can read more about the specifics in this MySpace Microsoft Case Study.

That volume of data pushes the database hard – and in some cases, beyond what SQL Server can handle out of the box.  Load during replication was so high that they had to write their own replication mechanism.  Likewise for many other processes. The load also impacts the development, testing, release, and backup routines. According to Christa, they literally invented their own processes and tools, as they are in uncharted territory.

Despite continued growth, MySpace is making real technical progress. For instance, when Christa joined the team from Yahoo 2.5 years ago, they were experiencing more than 2 million data integrity errors per day. Now that’s down to about 100,000 per day. My hat goes off to the MySpace engineering team!

The audience was so engaged that an extended Q&A that broke out in the middle of the presentation. Christa fielded dozens of questions, ranging from hardware configurations to backup strategies, and then finished off her presentation. You can check out Christa’s slides here.

Christa will speak to the San Francisco SQL Server User Group on October 14, 2009 when her topic will be Service Dispatcher: The MySpace Implementation of Service Broker, and I expect we’ll see another record turnout.

 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

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