• SQL Server 2008 R2 Overview and Whitepaper

    I know, SQL Server 2008 R2 was released some time back, but with so much content out there I thought I might simplify it a bit. I've written a complete overview that you can read through in about 10 minutes, and there's a great new whitepaper on one of the main features, PowerPivot. Thought I'd share here:

    My article: http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=359 

    PowerPivot Whitepaper: http://whitepapers.zdnet.com/abstract.aspx?docid=1911939&promo=100303

  • Migrating to SQL Azure

    As Mary Jo Foley recently reported migrating to SQL Azure just got a little easier with the latest version of the SQL Server Migration Assistant (SSMA), released on August 12. Included in the update are the typical cast of source databases: Oracle, Sybase, and Access. But there are two new things. First, MySQL was added as a source database. And second, SQL Azure was added as a target. If you have an existing MySQL database there’s no better way to get started with SQL Azure than migrating your existing db .The process is fast and painless. You can read more about this release of SSMA on the SSMA blog.