Ginneblog

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