Microsoft scales out SQL Server 2008, wants to 'democratize BI'
Plans to take its 2008 Server database to the large data warehousing market by 2010
Computerworld - SEATTLE -- Microsoft Corp. today said it will take its SQL Server 2008 database into the large data warehousing market by 2010 as it integrates technology from recently acquired DATAllegro Inc.
Microsoft plans to release a version of SQL Server 2008, code-named Kilimanjaro, that will use technology from the data warehousing appliance vendor it bought over the summer to build massively parallel systems that can scale out into the "hundreds of terabytes," said Ted Kummert, corporate vice president for data and storage at Microsoft.
Hardware vendors such as Dell, EMC, Hewlett-Packard, Unisys and Bull, which were previously working with DATAllegro, will build data warehousing appliances, code-named Madison, based on the combined SQL Server/DATAllegro technology.
Those appliances will be available by the first half of 2010, though a community technology preview version of Madison should be available within 12 months, Kummert said.
At its second business intelligence conference in Seattle, Microsoft also said it wants to "democratize" business intelligence and make it available to more employees inside a company by bolstering its self-service analysis features in a project code-named Gemini.
Stephen Elop, president of Microsoft's business division, said that tools such as Microsoft Office, particularly Excel, along with SharePoint and PerformancePoint, provide a complete stack that complements SQL Server and is superior to other vendors' "cobbled-together, disparate solutions."
"Other companies talk about features that are like Excel; we talk about Excel," he said in a keynote speech at the conference, which was attended by 3,000.
These "people-ready" BI features will also be available in the next release.
Elop also said that companies using Microsoft's stack will find it much cheaper and easier to implement. "Some vendors have made the decision during these hard economic times to start cranking up prices," he said. "Well, doggone it, there's something wrong with that."
Officially released in August, SQL Server 2008 has been deployed by 80 companies, said Tom Casey, Microsoft general manager for SQL Server business intelligence, during a presentation. The free version has been downloaded 500,000 times, he said.
SQL Server, along with Oracle Database, has long been dogged by accusations that its technology was unsuitable for users interested in "scaling out" their systems using lower-cost PC servers hooked up in massively parallel networks.
But during the keynote, Microsoft demonstrated a 150TB database with 1 trillion rows of data using 24 separate instances of SQL Server 2008 that is a "true MPP system," according to Jesse Fountain, a principal group manager.
"This is a true shared-nothing architecture with no single point of failure," Fountain said.
Alluding to Oracle's recently announced high-end "data warehouse in a rack," the Database Machine, Kummert said, "Rarely do I ever hear customers say they want a one-size-fits-all solution that is new and different to manage."
- Best iPhone, iPad Business Apps for 2014
- 14 Tech Conventions You Should Attend in 2014
- 10 Desktop Apps to Power Your Windows PC
- How to Add New Job Skills Without Going Back to School
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- Four Myths of High-Productivity App Dev Debunked Debunk the main myths surrounding high-productivity application development and how both platforms have overcome them.
- IDC: Dual Perspectives on ITaaS This global survey by IDG Research Services of more than 350 IT and BU directors at enterprises of 1,000 employees or more reveals...
- ESG Whitepaper: Integrated Computing Platforms: Infrastructure Builds Tomorrow's Data Center Thought Leadership Report: 'Integrated Computing Platforms: Infrastructure Builds for Tomorrow's Data Center.' Highlights the challenges customers face when planning to deploy a Cloud...
- Analyst Report-Mixed All Flash Arrays Delivers Safer Higher Performance What is the impact of an all-flash array with enterprise features and reliability on the mainstream data center? In the mainstream environment, storage...
- Live Webcast Increasing the Value of Your Reports and Dashboards Learn how incorporating other analytical capabilities such as predictive modeling and visualization can increase the value of your reports and dashboards by providing...
On-Demand Webcast: 7 Reasons to Choose VoIP
Thinking about a new phone system for your business?
Be sure to watch this informative webcast. Steve Strauss, small business columnist for USA...
- Top 8 Communications Tools for Small Businesses Powerful technology is available to help your small business improve its communications with customers, employees and suppliers. View this free On-Demand Webcast produced... All Business Intelligence/Analytics White Papers | Webcasts
By Rob F. Walker, Ph.D.
In the previous installment, we looked at and discussed strategies for business simulation and the infrastructure needed to make such initiatives successful. Now, we¿re ready to discuss some practical examples of business simulation. Imagine a mail order company selling products together with the necessary financing. more