SQL Server 2008 performs 1 trillion row query in seconds at BI Conference

The Washington State Convention & Trade Center in Seattle is buzzing today as Microsoft kicks off its second annual Business Intelligence Conference. Microsoft Business Division president Stephen Elop took the stage to speak to more than 2,500 customers and partners about end-user empowerment, self-service BI, and people-ready BI, followed by Ted Kummert, corporate vice president of the Data and Platform Storage Division at Microsoft, announced some exciting new developments for SQL Server.

	Project "Madison" runs 1 trillion row query in seconds Project "Madison" was announced as the release of SQL Server that will be integrated with the recent DATAllegro acquisition. Project "Madison" will be capable of handling the most challenging data warehouse workloads which is key since the data warehouse is the hub of any BI solution. Today at the BI Conference, SQL Server demonstrated how capable this technology really is by using current reporting tools to perform a 1 trillion row query on a 100 TB data warehouse with results returning in seconds.
	SQL Server code-name "Kilimanjaro" announced The next release of SQL Server code-name "Kilimanjaro" will focus on BI and end-user empowerment. As part of Kilimanjaro, project code-name "Gemini" will enable users to perform self-service analysis and intuitively build their own BI solutions by easily sharing and collaborating on personal BI results. The new capabilities will enable end users to directly access, analyze, personalize, and share data using the Excel and SharePoint with minimal dependence on IT.
	Acosta achieves 70% improvement with SQL Server 2008 Mike Chaffin, CIO of Acosta, joined Ted Kummert on stage to discuss Acosta’s efforts in upgrading its BI solutions to SQL Server 2008. Acosta provides retail sales and category management services to more than 1,000 manufacturers, including giants such as Clorox, Heinz, and Nestle. Now its clients get better data views, easier data management with table partitioning, enhanced performance with dynamic management views, and 70 percent faster aggregations.

Additional Resources

• Read the official press release here.
• Read more about the Acosta case study.
• The Microsoft BI Conference is currently being held through October 8^th in Seattle, WA. To learn more about the BI Conference, click here: www.microsoft.com/bi/conference/.