PASS 2011 Summit–Day Two

From the Keynote Bloggers’ Table

The second day of PASS started with a keynote addressed that was as well attended as yesterday – probably about 3000.  The Wireless network was saturated once again.  During the session, I was able to post this draft and then a couple of revisions. I was only able to send tweets from my phone during the keynote (I managed to exhaust my phone battery by the afternoon by doing the same yesterday so I’m being a little more conservative today).

Today’s keynote presentations outlined features and capabilities of SQL Server 2012.

Bill Graziano started out by wearing a kilt on stage and recognizing all of the participants of the PASS Kilt Day

Quentin Clark let the presentation about the new capabilities on SQL Server 2012.

Top new capabilities in SQL Server 2012

Always On provides redirection to

Fast performance

Rapid Data Exploration

Managed Self-service BI

Credible, consistent data

Lori Edwards, @sqlgal, demonstrating a complete analytic & data quality.


Peace of Mind

Brit on stage to demo appliances and PDW

Architecture is chosen and designed before selecting the hardware.  Not the other way around.

Showing us the Dell Parallel Data Warehouse.  Looks like an 8 foot tall rack .  Has 480 cores

Small: Business DW manages 1.5 TB

FASTTRACK 3.0 – Pre-configured to, plug in, load data & run in 20 min.

Extend  any data, anywhere

Statistical semantic search

Michael Rys on stage to demo

Used a very cool Silverlight app to search and show results.

Optimized productivity

SQL Server Data Tools (Project Juneau)

Scale on demand

Embeddable, portable database engine (no install)

SQL Azure

Nicholas Dritas, SQLCAT on stage to demo Azure

Mange Azure databases using SSMS – very cool

Backup Azure db from the client

Elastic scale

Cihan Biyikoglu

Sharing (Federations)

Demoing data form Blogs R Us, scalable blog service.

PASS 2011 Summit Begin–Wed Keynote

From the PASS Keynote Bloggers’ Table
Refresh this post for updates and follow #SQLPass on Twitter

Rashabh Mehta

On stage introducing the conference “That’s Community”  – I agree

  • “Connecting is a very important part of this week”.   Build connections that will last a lifetime.  Many events and sessions specifically for networking and connecting with other professionals.
  • Best way to work with Microsoft and give feedback – Talk to the SQLCAT Team
  • MVP Deep Dives – from 55 MVPs, most are here.  Buy it at the summit and get it signed.
  • Evaluations are very important.  Paper in that back of each session room or onlight

Ted Kummert

Tools & Platform Sr. VP

Watch for announcements…..

  • SQL Server is the most widely adopted db platform/product on the planet
  • Transition to the cloud – new world of data
  • Appliance: Added Dell as PDW provider
  • Cloud is a combination of on premise & off-premise – “A Hybrid World”.  Sync Service s a big part of this vision.


  • Project Crescent is called POWER VIEW
  • Product name: SQL Server 2012
  • Product will ship in early 2012 – no surprises there.

Three-part vision going forward:

  • Processing any data any size, anywhere…
    Azure gets 20,000 Petabytes of data/month
    Microsoft officially supporting Apache Hadoop.  Will be making submission to the Hadoop project.
  • Hadoop project (an open source framework that enables applications to work with thousands of nodes and petabytes of data)
  • Hadoop
  • Partnering with HortonWorks

Denny Lee on stage

(Denny’s a one-of-a-kind personality – great guy) – runs the SQL CAT Team for large BI projects.

  • New Hive ODBC driver – will be available for download in about a month
  • Denny is demoing using PowerPivot with Hadoop as a data source. – very cool.

Tim Mallalieu on stage

  • Data Explorer – code name of new product in Azure Marketplace
  • Demo of Data Explorer to do data mashup with Excel and SQL Azure data – mashups are logical joins between disparate data sources using merging logic.
  • Using large data feeds through Azure Marketplace,
  • Data Explorer is from Azure Labs – coming soon, early next year.

Ted Kummert

  • Introducing Crescent/PowerView (I smell a demo)


Wooo Hoo.  Sitting at the Bloggers Table waiting for the first keynote address.  Mark Sousa wearing a lab coat – looks like a mad scientist.   This is the first of several posts during the first keynote address on Wednesday, October 12.

It’s 8:08 AM Pacific Time in Seattle and we have about 20 minutes to go.  I’ll be updating this post throughout the keynote this morning.

Real Time PASS 2011 Summit Announcements

Follow me for real-time updates from all three keynote sessions.  I will be blogging and tweeting from the Keynote Bloggers Table on Wed, Thurs & Friday morning starting at 8:30 am Pacific Time.  To stay tuned:

  • Follow me at @paul_turley
  • Follow the #SqlPASS hash tag
  • Check this blog throughout the keynote sessions

The PASS Global Summit officially starts tomorrow morning.  The pre-conference sessions are running yesterday and today and I’m on the Redmond Microsoft campus attending the SQL Server Advisor’s Summit / Insider sessions.  This is going to be a great conference.  SQL Server “Denali” is nearing release in the next few months, there’s a lot of buzz about new BI capabilities and many new enterprise features.  Attendance this year is expected to set a new record with over 3,800 registrations.

Even if you couldn’t make it to Seattle to attend in person, you can keep up with announcements and stay connected with the SQL Server community. 

If you are attending, please come to my sessions on Wednesday morning and Friday afternoon.  I’m speaking at the very beginning and the very end of the conference at these times:

  • Visual Report Design: Brining Sexy Back  (spotlight); Wed, Oct 12, 10:15am
  • Multidimensional Reporting with MDX; Fri, Oct 14,  4:15pm