What is Katmai?

Katmai is a Code Name for Microsoft’s SQL Server 2008. In May 2007, the Microsoft Flagship Database Server Model was announced and later launched in August 2008. Microsoft’s Katmai is the tenth essential model of this product, which was first added in 1989 by way of Microsoft and Sybase.

Katmai brought foremost improvements:

• Security
• Reliability/Availability
• PerFormance
• Management
• Development Enhancement
• Service Brokering
• Data garage
• Data warehousing/extract, rework load
• RePorting

In April 2010, Katmai become replaced by Kilimanjaro, Microsoft SQL Server 2008 R2.

What Does Katmai Mean?

Katmai’s main innovation promised new competencies for storing, Indexing and Accessing semi-structured and unstructured local Records. Traditionally, Relational Databases, along with SQL Server, had been optimized to keep textual and numerical statistics in numerous hierarchical organizational sySTEMs, also referred to as schemes or models.

The advent and get admission to of wealthy Media content material has created a more call for for the reliable garage of audio, video, graphical and geographical facts. Thus, Microsoft has replied with the introduction of new native Katmai facts types, together with FileSTREAM, which optimizes typical Database reaction with the aid of storing structural Metadata inside the database and document content material in the record system.

The GEOGRAPHY and GEOMETRY information types (for planar and round-earth spatial statistics, respectively) come with numerous dozen new strategies, which agree to the Open Geospatial Consortium’s easy Characteristic get admission to for SQL model 1.1.

Other key innovations include the full-textual content seek alternative and a resource governor, which allows for the reservation of resources for sure users or workflows.