Ginneblog

The SQL Server 2008 R2 Launch Event in Santa Clara was great.  More than 300 SQL Server and BI professionals were on hand, and the keynote was followed by three tracks of sessions that lasted the rest of the day.

Buck Woody, Microsoft’s “Real World DBA” was on his best behavior, but still had some great zingers and one-liners.  He handed the baton to Tom Casey, who was followed up by Fausto Ibarra and Sabrena McBride, giving an R2 demo.   Our own Ross Mistry, SQL Server MVP and our new host for the Silicon Valley SQL Server User Group, was also a featured speaker.  You can download Ross’s latest book, Introducing Microsoft SQL Server 2008 R2, here for free. 

During the intro, I had a chance to tell the crowd about our Bay Area PASS Chapters, and to officially announce the new Bay Area Microsoft Business Intelligence User Group.  That group will hold its first meeting in Mountain View on June 10th, and its second meeting, in San Francisco, on July 1st.  The group’s co-founders, Alex Viera, Elizabeth Diamond, and I, look forward to launching the group and continuing to help build the local Microsoft BI community.

 Send to Twitter

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

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

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

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