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.
- Silicon Valley's 19 Coolest Places to Work
- Is Windows 8 Development Worth the Trouble?
- 8 Books Every IT Leader Should Read This Year
- 10 Hot Hadoop Startups to Watch
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- Patient Portals: A Platform for Connecting Communities of Care Connecting patient health data across the care continuum is essential to achieve improved care, increased access to personal health records and lowered costs.
- 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.
- Acxiom Case Study This case study, which focuses on Acxiom, explores how the company was able to secure employee data, reduce migration costs and boost productivity...
- Windows® XP Migration: Protect and Secure Critical Data With the end of the Microsoft Windows XP operating system's lifecycle on April 8, 2014, businesses are faced with the decision to migrate...
- Top 4 Digital Signage Fails Join RMG Networks for a look at four of the most common reasons digital signage fails in corporate businesses. Learn about strategies to...
- Building Tomorrow's Infrastructure Listen to this podcast to discover how Crider Foods worked with PC Connection to update their IT infrastructure, while maintaining compliance and control. All Databases White Papers | Webcasts