SQL Server 2005 - Technischer Überblick

TechNet Seminar SQL Server 2005 Technischer ?berblick

Steffen Krause Technologieberater steffenk@ Blog:

Agenda

Einf?hrung Verwaltung Sicherheit Verf?gbarkeit Business Intelligence

Einf?hrung SQL Server 2005 Daten-Plattform

Integration Services

Database Maintenance

Replication

.NET Framework

Backup and Restore Enhancements Auto-tuning Replication Agents

Common Language Runtime Integration

Checksum Integrity Checks

Oracle Publication

User-defined Aggregates

Dedicated Administrator Connection Improved Blob Change Tracking

User-defined Data Types

Dynamic AWE

OLAP and Data Mining

User-defined Functions

Fast Recovery

Analysis Management Objects

SQL Server .NET Data Provider

Highly-available Upgrade

Windows Integrated Backup and Restore

Extended Triggers

Online Index Operations

Web Service/XML for Analysis

Data Types

Online Restore

DTS and DM Integration

Managed SQL Types

Parallel DBCC

New Data Mining Algorithms

New XML Datatype

Parallel Index Operations

Auto Packaging and Deployment

SQL Server Engine

Management Tools

Data Transformation Services

New Message Service Broker

New Management Studio

New Architecture (DTR + DTP)

HTTP Support (Native HTTP)

MDX Query Editor

Complex Control Flows

Database Tuning Advisor

Version Control Support

Control Flow Debugging

Multiple Active Result Sets

XML/A

For Each Enumerations

Persisted Computed Columns

SQLCMD Command Line Tool

Property Mappings

Queuing Support

Performance Tuning

Full Data Flow Designer

Snapshot Isolation Level

Profiler Enhancements

Full DTS Control Flow Designer

Scale Up Partitioning

Profiling Analysis Services

Graphical Presentation of Pkg Execution

VIA support

Exportable Showplan

Immediate Mode and Project Mode

NUMA support

Exportable Deadlock Traces

Package (Advanced) Deployment Tools Database Failure and Redundancy

Full-text Search

Custom Tasks and Transformations

Fail-over Clustering (up to 8 node)

Indexing of XML Datatype

Reporting Services

Enhanced Multi-instance Support

MDAC

Multiple Output Formats

Database Mirroring

Side by Side installation

Parameters (Static, Dynamic, Hierarchical) Database Viewpoints

Microsoft Installer base setup

Bulk Delivery of Personalized Content XML

Support for Active Directory Deployment Support Multiple Data Sources

XQUERY Support (Server & Mid Tier)

SQL Client .NET Data Provider

STS (Web Parts, Doc Libraries)

XML Data Manipulation Language

Server Cursor Support

Visual Design Tool

FOR XML Enhancements

Asynch

Charting, Sorting, Filtering, Drill-Through

XML Schema (XSD) Support

Security

Scheduling, Caching

MSXML 6.0 (Native)

All Permissions Grantable

Complete Scripting Engine

.Net XML Framework

Fine Grain Administration Rights

Scale Out architecture

Separation of Users and Schema

Open XML Report Definition

Notification Services & SQL Server CE

Einf?hrung Produktivit?t erh?hen

Enterprise Data Management

? H?chste Verf?gbarkeit f?r Unternehmensanwendungen ? Neue Security und Performance Features ? Management und Selbst-Optimierung

Developer Productivity

? Integration mit Visual Studio und .NET ? Natives XML ? Offene Standards, Interoperabilit?t via Web Services

Business Intelligence

? Vollst?ndige ETL-L?sung

? Echtzeit-Entscheidungsunterst?tzung: Reporting, Data Mining

? Verbesserte Skalierbarkeit und Verf?gbarkeit

Sichere, zuverl?ssige und produktive Datenbankplattform

f?r Line-of-Business und analytische Anwendungen

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download