"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein

Wednesday, 7 November 2012

Pass Summit 2012 Day One Keynote: Accelerate Insight on any Data

Today is the official start to the 2012 PASS summit. The PASS Summit 2012 Day One Keynote session was delivered by Microsoft corporate vice president of the Data Platform Group (DPG) Ted Kummert. The keynote was packed with announcements on changes in the database engines.

Service Pack 1
The first announcement made at PASS is the release of SQL Server 2012 SP1. Some of the new features include

Ted Kummert continued saying the world of data is changing with superabundant supplies. It is approaching a tipping point with volume, variety, velocity, hardware innovation, software innovation and cloud. There is also a change in architectural assumptions with big data providung new insights with new sources of data. There is the need to accelerate business process and insight, manage any data, any size, anywhere and enable pervasive insight.

Hekaton
The second announcement is project code name ‘Hekaton’ to accelerate in-memory for business process and insight. Project Hekaton brings an in-memory engine process to the transactional world. After converting tables to then in-memory engine there is almost a 10x performance increase. It allows recompiles of stored procedures so they will run in memory, which could also offer a 30 times performance increase.
This is in the next release of sql.
The Hekaton AMR tool is designed to help identify hot spots in the database application and provide assistance to migrate things such as tables and stored procedures.

SQL Server 2012 Parallel Data Warehouse
Microsoft announced the new SQL Server 2012 Parallel Data Warehouse. Queries that previously took 20 minutes to run only take 20 seconds. It offers an up to 50x performance gain with an optimized architecture. Due out in H1 2013.Polybase

Polybase is a breakthrough in data processing. It integrates Hadoop data and relational data to allow combined TSQL queries with an optimized architecture. It will allow future expansion to other data sets. Polybase will unify the relational and non-relational world. Built for big data and coming in H1 2013.

Microsoft’s strategy is to design an Enterprise platform for integrating data. We have to learn one new concept and that is about joining up data coming from multiple sources.

Other

Additional annoucements mentioned

Clustered column store index with updatable tables

Power View and PowerPivot fully integrated in Excel, now a complete BI tool

Fully interactive maps inside Excel

DAX queries on top of molap cubes

In conclusion data is bringing about lots of changes which adds richness to the solutions.

PASS is running the first ever Business Intelligence conference in spring 2013 in Chicago.