THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

PASS Summit 2011: Wednesday Keynote

I am honored to sit at the blogger’s table at the PASS Summit 2011 this year. Here’s some notes from the Wednesday keynote.

Rushabh opened with a welcome to those viewing the live stream for the first time.

Then thanks the PASS Executive Committee and PASS Board, followed by recognition of founding company representatives. Then the new international Board members (non-voting). Last year, Rushabh announced goals for the organization:

  • 1,000,000 hours of training
  • 250,000 members
  • 5 global regions

   Rushabh reports the following progress towards those goals:

  • 430,000 hours of training this year
  • 80,000 members;  20,000 new members
  • 1 global region consisting of the new Board Advisors

DVDs are available, on-line streaming is available. The fifty-five authors of SQL Server MVP Deep Dives 2 are available to sign your copy of the book today and Friday.

Ted Kummert’s Keynote Address

Mr. Kummert started his keynote by looking back at the available choices in hardware, appliances, and the cloud.

SQLAzure will offer reporting services next year. The focus has been on SQL Server Denali this past year. The official release name of SQL Server Denali is: “SQL Server 2012” and it will be released in the first half of next year.

“Processing Any Data, Any Size, Anywhere”

This is the vision, refined. It grew from the SQL Server 7.0 and 2000 – the vision has matured in SQL Server 2005, 2008, and 2008 R2. And now it takes the next step in SQL Server 2012.

Big Data

Microsoft doesn’t have the only solution for Big Data, but they are competitive. Microsoft will be supporting Hadoop connectivity, democratizing data:

  • Connectors to support bi-directional connectivity
  • Additions to Apache Hadoop to support Azure and Parallel Data Warehouse
  • Business Intelligence support and connectivity
  • Excel connectivity to hives
  • A partnership with hortonworks.

Denny Lee

Hives are data warehouse structures in Hadoop. Denny Lee demonstrates HiveQL, then using the Hive ODBC driver to connect to Hadoop from Excel.

Data Explorer

Data Explorer connects to a SQLAzure database and discovers the data values. If a second data source is added, such as an Excel spreadsheet, the “Mashup” option is enabled. Mashups allow the user to overlay the data from both sources. This functions as a lookup. Next, the Azure Data Marketplace contains data recommended to the user. This data can also be added to the Mashup. Applying OData interfaces, Mashups allow users to “join” data from disparate sources – in the cloud. Pretty cool.

Amir Netz

Congratulations to Mr. Netz. He’s been promoted to Microsoft Technical Fellow. Amir is an entertaining speaker. Using a movie and actor database, Amir demonstrates the power of reporting against discovered data, essential to self-service business intelligence.

Powerview on the Windows 7.5 phone? And the iPad2? Very nice!


Published Wednesday, October 12, 2011 12:41 PM by andyleonard
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement