Monthly Archives: October 2011

PASS 2011: Project “Crescent” becomes Power View in SQL Server 2012

By Michael Otey
At the keynote in this year’s PASS 2011 conference Ted Kummert announced that SQL Server 2012 will include a new immersive data visualization technology named Power View. Formerly code named project Crescent, Power View is a data exploration and visualization tool that enables ad-hoc queries from a variety of devices including new touch-based devices like Windows 8 will support. At the PASS keynote technical Fellow Amir Netz demonstrated working with Power View on both a Windows Phone 7 and an iPad. Power View will replace the older Report Builder 1.0 ad-hoc query that was first introduced in SQL Server 2005. The Power View technology is included in SQL Server Denali CTP3.

PASS 2011: Microsoft Embraces Big Data with Hadoop

By Michael Otey
As a part of their any data, any size, anywhere initiative, at this year’s PASS 2011 conference in Seattle Ted Kummert, Microsoft Corporate Vice President Business Platform Division announced Microsoft’s intension to deliver Hadoop based data management to Windows Server and Windows Azure. Hadoop is a distributed computing platform that is written in Java. It uses a MapReduce technology to distribute computing resources across clusters of computers to rapidly process extremely high volumes of data. At first Microsoft’s embracing of Hadoop may seem a bit confusing but when you view like their incorporation of OLAP services back in SQL Server 7 you can see that support for Hadoop is really another step along the evolutionary path of SQL Server becoming a complete enterprise data platform. Hadoop will enable the processing of high volumes of data as well as unstructured data. A CTP is planned to be released before the end of the year. The Hadoop implementation will be integrated with both SQL Server relational databases as well as Analysis services. Microsoft announced Hadoop Connectors for SQL Server and the Parallel Data Warehouse. Customers can use these connectors for bi-directional integration of Hadoop with SQL Server’s relational and BI data. Hadoop data will be able to be consumed using Microsoft’s BI tools, including Microsoft PowerPivot and Power View