Jeff Prom's SQL Server Blog

Sharing knowledge and tips on SQL Server, Business Intelligence and Data Management.

PASS Summit 2012 – Day 1

Posted by jeffprom on November 8, 2012

Day 1 of the conference may be over but there were a lot of exciting announcements made this morning that should keep the SQL Community energized for a while.

Here are some highlights of what was announced.

  1. Project Polybase. This project is working to allow the use of T-SQL queries to query Hadoop data as well as relational databases. It will also add the ability to use joins between the two.
  2. Hekaton. This is the code name given to the project that is working on in-memory OLTP. Basically, you enable selected databases to be run all in memory which makes it super fast!
  3. SQL Server 2012 SP1
  4. SSRS is now supported on iOS and win8 mobile devices when you install SQL Server 2012 SP1.
  5. Parallel Data Warehouse next gen.
  6. Updatable column store indexing.
  7. PowerView can be used with Excel 2013 as it’s data source.
  8. PowerView will be able run on OLAP Cubes. Multidimensional as well as Tabular!

Some of these features are available in SP1 (SSRS & Mobile), H1 of 2013 (PDW), but most will be released in the next major release of SQL Server.

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

%d bloggers like this: