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.
- A Modern Approach to the Data Deluge Read this whitepaper to learn how infrastructure leaders can confidently manage cost, complexity, and risk, capitalize on emerging technologies, and drive future innovation...
- 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.
- The Business Value of Continuous Delivery Download this whitepaper to learn more about the business value of Continuous Delivery and see why it could be a game changer for...
- Ten Factors Shaping the Future of Application Delivery Download this research report conducted by Enterprise Management Associates (EMA) to learn how those that are seeking to accelerate application delivery are leveraging...
- Leveraging Flash Storage to Accelerate Oracle Real Application Clusters Join this webinar to understand the latest solid-state storage trends, the specific applications driving solid-state storage deployments and the benefits of deploying the...
- On-demand webinar - 7 Keys to Service Catalog Implementation Success Watch this webinar to learn 7 crucial keys to make your service catalog a success! All Databases White Papers | Webcasts
Our new bimonthly Internet of Things newsletter helps you keep pace with the rapidly evolving technologies, trends and developments related to the IoT. Subscribe now and stay up to date!