Microsoft to let DBAs manage pools of SQL Server databases
Tech preview of SQL Server Data Services, its cloud version of SQL Server, also announced
Computerworld - At a conference for users of its SQL Server database on Wednesday, Microsoft Corp. officials demonstrated an upcoming tool aimed at enabling database administrators to manage hundreds of database servers at a time.
The "application and multi-server management" feature will also enable DBAs to set policies and deploy applications to their entire "SQL Server Fabric," rather than one at a time, Microsoft said.
The feature will arrive with the upcoming Kilimanjaro release of SQL Server 2008. Due in 2010, Kilimanjaro will be the first version of SQL Server that can "scale out" to hundreds of servers -- hence the need for the management feature.
Kilimanjaro, which some are calling SQL Server 10.5, will be aimed at large-scale data warehouses with tens or hundreds of terabytes of data. It will allow Microsoft to compete with the likes of Teradata Inc. in the high-end BI (business intelligence) space, as well as IBM and Oracle Corp.
The management dashboard was demonstrated during a keynote speech by Microsoft's corporate vice-president for the data and storage platform division, Ted Kummert, that officially kicked off the Professional Assocation for SQL Server's annual conference.
The conference goes through Friday in Seattle. Due to interest from the release of SQL Server 2008 in August and Microsoft's announced plans to scale out its database, attendance is up at this year's PASS show, to a reported 2,500 attendees from about 1,500 last year.
One attendee of the demonstration, Steve Jones of SQLServerCentral.com, blogged that multi-server management "is a good idea since I've always tried to set up the same management tools and processes on each server, so that I can efficiently keep an eye on things."
Jones also wrote, "I assume some backwards compatability, but there is a lot of work for third party vendors to do here. At least that's my guess."
Microsoft said it has more than 40 internal apps running SQL Server 2008, including a 37 Terabyte data warehouse, and two SQL Server Analytical Services (SSAS) cubes for its Live Search service that are 1.4TB and 1.8TB, respectively.
Microsoft also announced the public availability of the first Community Technology Preview for SQL Server Data Services (SSDS), its cloud version of SQL Server.
Read more about Databases in Computerworld's Databases Topic Center.
- 15 Non-Certified IT Skills Growing in Demand
- How 19 Tech Titans Target Healthcare
- Twitter Suffering From Growing Pains (and Facebook Comparisons)
- Agile Comes to Data Integration
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- Aberdeen Group: Marketing Analytics for Manufacturing: Forging Customer Insights There are no recalls for poor marketing. Manufacturers need to get their customer intelligence and messaging right the first time. Learn how.
- SIEM: Keeping Pace with Big Security Data Learn how SIEM can have the right database back-end and offer security intelligence that leverages contextual data to achieve a strong security posture...
- Pay-as-you-Grow Data Protection: IBM Tivoli's Full-featured Data Protection Suite for Small to Medium Businesses IBM Tivoli Storage Manager Suite for Unified Recovery gives small and medium businesses the opportunity to start out with only the individual solutions...
- Streamline Data Protection with IBM Tivoli Storage Manager Operations Center IBM Tivoli Storage Manager (TSM) has been an industry-standard data protection solution for two decades. But, where most competitors focus exclusively on Backup...
- Meg Whitman presents Unlocking IT with Big Data During this Web Event you will hear Meg Whitman, President and CEO, HP discuss HAVEn - the #1 Big Data platform, as well...
- The New Way to Work Knowledge Vault This Knowledge Vault focuses on how, in today's increasingly virtual world, it's more important than ever to engage deeply with employees, suppliers, partners,... All Databases White Papers | Webcasts