PASS Summit 2012 – Day 1

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.

Advertisement

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 )

Facebook photo

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

Connecting to %s