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.
- 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.
- 5 Customers Deliver Virtual Desktops and Apps to Empower a Modern Workforce Learn how Citrix solutions helped 5 companies realize the full value of desktop virtualization through a project-by-project approach based on key business priorities.
- Top 10 Reasons to Strengthen Information Security with Desktop Virtualization Regain control and reduce risk without sacrificing business productivity and growth
- IDC MarketScape: Worldwide Client Virtualization Software 2013 Vendor Assessment IDC has placed Citrix in the 2013 IDC MarketScape Leaders Category once again noting that, "Citrix's position reflects the company's market leadership and...
- 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...
- What Does it Take to Deliver a Superior Customer Experience? The Two Top-Rated Online Retailers, B&H Photo and Crutchfield Electronics, Share Their Secrets Discuss practical CX tools and service methods such as contact center agents and the use of realtime speech analytics to help contact center... 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!