Microsoft Big Brains: Peter Spiro

Microsoft Big Brains: Peter Spiro

Summary: One of the leading database experts at Microsoft, Technical Fellow Peter Spiro, used to be a charcoal maker in Mali. Then he was a corn farmer in Wisconsin. What a long, strange trip it's been, Spiro acknowledges.


It has been a while since I posted one of my profiles of Microsoft's Technical Fellows (they're a tough group to pin down). But the series is continuing, as I plow through the full list of 22.

Just before retiring from day-to-day responsibilities at Microsoft in 2008, Chairman Bill Gates said that he expected Microsoft's Technical Fellows to get a lot more publicly visible -- now that they wouldn't be living in his shadow. While some of the Microsoft fellows already have been active on the public-speaking circuit, many of them are not widely known outside the company.

Last year I launched this series -- "Microsoft Big Brains" -- to help remedy that shortcoming. In the coming weeks, I am hoping to profile as many of the company's tech fellows as to whom I can get access. Slowly but surely, I'm making my way through the list.

Microsoft's Technical Fellows came to the company via a variety of different routes. Some of them run divisions inside the company; some focus on particularly thorny technical issues that may span a variety of product units. Regardless of where they sit in the organization, the fellows all have been charged with helping Microsoft craft its next-gen products and strategies, much the way that Gates used his regular "Think Weeks" to prioritize what Microsoft needed to do next.

This Week's 'Big Brain': Peter Spiro Claim to Fame: One of the foremost experts in database internals How Long You've Been With Microsoft: 16 years More About You: Worked on a variety of database teams and projects at the company, including SQL Server, SQL Server Compact (for mobile devices), the WinFS file system, and CloudDB (which morphed into SQL Azure) Your Biggest Accomplishment (So Far) at Microsoft: Instrumental in the development of the SQL Server 7.0 release and "the mini-culture around SQL Server at Microsoft" Team(s) You Also Work With: SQL Server, SQL Azure Why stay at Microsoft? "I like the breadth of the playground," Spiro says. Claiming he bores easily (in spite of his multi-decade focus on databases), "I am a floater," he says. "I can work on whatever catches my eye." These days, "I'm like the village elder," he adds.

One of the leading database experts at Microsoft, Technical Fellow Peter Spiro, used to be a charcoal maker in Mali. Then he was a corn farmer in Wisconsin. What a long, strange trip it's been, Spiro acknowledges.

It was Wisconsin where Spiro ended up by chance after a stint in the Peace Corps, where he embarked on his database career. Attending the University of Wisconsin, where he was working on his Masters' in forestry, Spiro ended up working as a lab manager on a PDP 11. He took some computer science classes and met another Microsoft-Technical-Fellow-to-be, David DeWitt, who was teaching there. Spiro finished his Forrestry degree and then got another Masters' in Computer Science. He moved to Massachusetts in the mid-80s to take a job at Digital Equipment Corp. and ultimately became Technical Director for the DEC Rdb and DEC DBMS products.

"I figured I'd work at DEC for 20 to 30 years," Spiro recalls.

But then Oracle bought Rdb and Spiro was at a crossroads: Stay in a satellite office of a new company or look for something new. At that point, Microsoft was just starting to get serious about the database market, with former Chief Technology Officer David Vaskevitch looking to bring on a hundred database experts to get Microsoft in the game so it could compete with Oracle and IBM. Microsoft hired Spiro in 1994 as "the storage guy and change agent," he says. His job was to help Microsoft with everything from organizational structure, to hiring, to developing business plans. In between all that, he also served as dev lead, dev manager and product unit manager for the storage and relational engines of SQL Server.

It wasn't until SQL Server 7.0 that Microsoft got serious about being an enterprise-level player in the database market. The oft-delayed SQL Server 7.0 was a major (as in 80 percent of the code changed) version of Microsoft's database. Microsoft changed more than just the core database code with that release, Spiro says; it changed the people, the processes and the architecture around SQL Server.

Spiro hasn't worked only on big teams and big projects. Two years ago, he shed his direct reports so he could work on smaller, up-and-coming initiatives. He also worked with the WinFS and SQL Azure teams. WinFS -- one of the intended components of Longhorn/Windows Server 2008 -- never materialized. But pieces of the WinFS technology have been incorporated into subsequent SQL Server, Velocity (part of the Windows App Fabric), StreamInsight complex event-processing and other product/technology releases, Spiro says.

Managers learned a lot of lessons from WinFS -- like don't bet a shipping product on technology that is still in incubation -- Spiro says. "With these kinds of big, hard projects, you get two to three times the learnings you get in a typical five-year project," he adds.

"WinFS was almost too creative" and ahead of its time, Spiro says. But as a result of its people and ideas, "the SQL Server organization had a renaissance of incubation and innovation."

Spiro says he considers the coming decade to be very much like the 1970s, in terms of being the "golden era of data management." The big data challenge, going forward is to manage data collections that are growing exponentially in size.

"The old techniques don't work as well. We need to be thinking about mining in real time, the implications of cheaper storage and scaling across thousands of nodes," he says. We'll be experimenting with lots of different techniques and technologies, Spiro notes. Already, some of these projects are rising to the forefront -- things like OData, Dallas and the continuously-evolving SQL Azure.

"We need to unlearn many of the things of the past 20 years, and then re-learn them," Spiro concludes.

(To check out more of the Microsoft Big Brains profiles, go here.)

Topics: Enterprise Software, Data Centers, Data Management, Hardware, Microsoft, Software, Storage


Mary Jo has covered the tech industry for 30 years for a variety of publications and Web sites, and is a frequent guest on radio, TV and podcasts, speaking about all things Microsoft-related. She is the author of Microsoft 2.0: How Microsoft plans to stay relevant in the post-Gates era (John Wiley & Sons, 2008).

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.


Log in or register to join the discussion
  • Shapiro?

    i think you meant Spiro.
    • RE: Microsoft Big Brains: Peter Spiro

      Yes I did. Thanks. Fixed. MJ
      Mary Jo Foley
  • Nothing against these guys personally, but with the management and business

    practices at Microsoft, they embarrass themselves. The best will move on at the first opportunity.
  • He kinda looks like...

    ...Jim Morrison from back in the day.
    Hatestone Johnson
  • Now thats a beard which demands respect

    I admire it whole heartedly..
  • RE: Microsoft Big Brains: Peter Spiro

    Mary Jo has covered the tech <a href="">sohbet</a> industry for more than 25 years for a variety of publications and <a href="">chat</a> sites, and is a frequent guest on radio, TV, <a href="">izlesene</a> and podcasts <a href="">portal</a>, speaking about all things Microsoft-related. She is the author of <a href="">chat sohbet</a>: How Microsoft plans to stay relevant in the <a href="">sohbet odalari</a> post-Gates <a href="">forum</a> era (John Wiley & Sons, 2008).
  • RE: Microsoft Big Brains: Peter Spiro
  • RE: Microsoft Big Brains: Peter Spiro

    The majority of migration <a title="kral oyun" target="_blank" href="">kral oyun</a> issues exist because some version of a 3rd party <a title="en yeni oyunlar" target="_blank" href="">en yeni oyunlar</a> line-of-business application critical to operations is not <a title="robot oyun" target="_blank" href="">robot oyun</a> supported on any <a title="oyun oyna" target="_blank" href="">oyun oyna</a> other browser. A company can't upgrade off the version <a title="oyunlar" target="_blank" href="">oyunlar</a> because they've modified it to hell, <a title="friv,firiv" target="_blank" href="">friv</a> and the 3rd party that manufactured it has long moved <a title="ben 10,ben ten" target="_blank" href="">ben 10</a> past that version.
    Many people don't understand how incredibly <a title="3d oyun,3d oyunlar" target="_blank" href="">3d oyunlar</a> widespread issue #3 is above and how difficult this issue is to resolve when you're talking about an application that is mission critical to a business. <a title="avatar oyunlar" target="_blank" href="">avatar oyunlar</a> This is the singel greatest reason companies look at the issue and say, "Screw it. We'll live with the risk and run an N-3 version of the browser
  • RE: Microsoft Big Brains: Peter Spiro

    Really liked your platform. Thank you to write <a title="dizi izle" href="">dizi izle</a>
    <a title="islami evlilik sitesi" href="">islami evlilik sitesi</a>
    <a title="kitap" href="">kitap</a>
    <a title="is ilanlari" href="">is ilanlari</a>
    <a title="divx indir" href="">divx indir</a> Not consider a realistic look at post comments. A great page thanks <a title="iyi" href="">iyi</a>
    <a title="webmaster forumu" href="">webmaster forumu</a>
    <a title="ates ve su 5" href="">ates ve su 5</a>
    <a title="bulmaca coz" href="">bulmaca coz</a> Web page google, and I 've also very much liked being held. Thanks <a title="sosyal imleme" href="">sosyal imleme</a>
    <a title="link wheel" href="">link wheel</a>
    <a title="power balance bileklik" href="">power balance bileklik</a>
    <a title="profil backlink" href="">profil backlink</a> Good Luck ZDNET
  • RE: Microsoft Big Brains: Peter Spiro

    Thanks ZDNet
  • RE: Microsoft Big Brains: Peter Spiro

    I used to be more than happy to seek out this internet-site.I wanted to thanks in your time for this glorious read!! I positively enjoying each little bit of it and I have you bookmarked to check