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.
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.
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 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.
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!