Most Read Latest News Blog Resources

Microsoft Readies SQL Server ‘Katmai’




May 9, 2007 — 
The next generation of Microsoft SQL Server, code-named Katmai, is slated for release next year. Microsoft corporate vice president Ted Kummert, of the company’s data and storage division, will divulge selected details about Katmai during his keynote address at the Business Intelligence conference in Seattle tomorrow.

Preliminary product literature reveals that Katmai will be more deeply integrated with Microsoft Office system front-end tools, including Office Excel, Excel Services, Office SharePoint Server and Office PerformancePoint Server 2007, its business score-carding application. Katmai’s reporting capabilities will be more robust, supporting any report size or complexity.

Additionally, it will manage and accept nonrelational data types, including documents, geographic information and XML. Katmai provides more advanced data warehousing capabilities with Integration Services and Change Capture Functionality, and can synchronize data from devices to the central data store.

On the flip side, Katmai enables applications to interact with local data stores and synchronizes the local store with a central store for reference and line-of-business data.

Katmai also supports the next-generation ADO.NET data access framework to define business entities, according to the literature. Data entities can be retrieved and queried natively within any .NET language—compliments of LINQ (Language Integrated Query). LINQ support is built into the upcoming Visual Studio “Orcas” release, which will reach beta 2 by the end of this year, Microsoft officials have said.

Katmai integrates with Visual Studio 2005 as well as Visual Studio Orcas and supports the .NET 3.0 Framework.

Administrative and security features have not been overlooked. Katmai has shifted SQL Server from scripts to a rules-based management framework. It defines a common set of policies for database operations that are automatically published, enforced and monitored on servers across the enterprise. The contents of entire databases may be encrypted.

Katmai collects performance data and generates management reports with historical comparisons. A resource governor defines individual resource limits and can prioritize workloads.

Microsoft literature states that database mirroring, a feature introduced in SQL Server 2005, will simplify application recovery from storage failures, and that system administrators can add system resources without affecting applications.

Private beta testing could begin as early as June, according to an Austrian TechNet blog post published in April.


Share this link: http://www.sdtimes.com/link/30538
 

Add comment


Name*
Email*  
Country     


  • Comment
  • Preview
Loading



 
 
 
 
News on Monday
more>>
SharePoint Tech Report
more>>


   

 
 
Download Current Issue
ISSUE 3/15/2010 PDF

Need Back Issues?
DOWNLOAD HERE

Receive the print Edition?


 
blogs tab
Google Code turns 5
Google Code Turns 5, and adds a Paxos Algorithm to make the system more stable and reliable.
03/17/2010 11:16 AM EST

Test your Visual Studio 2010 know-how
Microsoft is offering free beta certification exams for Visual Studio 2010.
03/17/2010 11:08 AM EST

Microsoft lifts the hood on IE9
Microsoft is previewing IE9.
03/16/2010 01:10 PM EST

 

Events calendar tab
3/22/2010 to 3/25/2010
Santa Clara, Calif.
The Eclipse Foundation

4/12/2010 to 4/14/2010
Las Vegas
Penton Media

4/12/2010 to 4/15/2010
Santa Clara, Calif.
O'Reilly Media

4/19/2010
New York City
Flagg Management

4/25/2010 to 4/28/2010
Overland Park, Kans.
IIUG