THE SQL Server Blog Spot on the Web

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

Andy Leonard

Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!
Note: Comments are moderated. Spam shall not pass! </GandalfVoice>

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

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

My Company


Other Blog

Check out my personal blog...
http://andyleonard.me

Contact Me

Twitter: @AndyLeonard
Email: andy.leonard@gmail.com

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement