Prenesi
Download
1 / 21

Novosti v Microsoft SQL Server 2005 - PowerPoint PPT Presentation


  • 269 Views
  • Updated On :

Novosti v Microsoft SQL Server 2005. Danijel Novak. Urnik. Uvod Orodja Novosti pri programiranju Service Broker Novosti pri upravljanju Novosti pri razpoložljivosti Novosti pri učinkovitosti Replikacija Integration Services Analysis Services Reporting Services Notification Services.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Novosti v Microsoft SQL Server 2005' - richard_edik


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Novosti v microsoft sql server 2005 l.jpg

Novosti vMicrosoft SQL Server 2005

Danijel Novak


Urnik l.jpg
Urnik

  • Uvod

  • Orodja

  • Novosti pri programiranju

  • Service Broker

  • Novosti pri upravljanju

  • Novosti pri razpoložljivosti

  • Novosti pri učinkovitosti

  • Replikacija

  • Integration Services

  • Analysis Services

  • Reporting Services

  • Notification Services



Slide5 l.jpg

.NET Framework

  • Common Language Runtime Integration

  • User-defined Aggregates

  • User-defined Data Types

  • User-defined Functions

  • SQL Server .NET Data Provider

  • Extended Triggers

    Data Types

  • Managed SQL Types

  • New XML Datatype

  • Varchar (MAX) Varbinary (MAX)

    SQL Server Engine

  • New Message Service Broker

  • HTTP Support (Native HTTP)

  • Database Tuning Advisor

  • Multiple Active Result Sets

  • Persisted Computed Columns

  • Snapshot Isolation Level

  • Scale Up Partitioning

  • VIA support

  • NUMA support

    Database Failure and Redundancy

  • Fail-over Clustering (up to 8 node)

  • Enhanced Multi-instance Support

  • Database Mirroring

  • Database Snapshots

    XML

  • XQUERY Support

  • XML Data Manipulation Language

  • FOR XML Enhancements

  • XML Schema (XSD) Support

  • MSXML 6.0 (Native)

  • .Net XML Framework

    Full-text Search

  • Indexing of XML Datatype

Database Maintenance

  • Backup and Restore Enhancements

  • Checksum Integrity Checks

  • Dedicated Administrator Connection

  • Dynamic AWE

  • Fast Recovery

  • Highly-available Upgrade

  • Online Index Operations

  • Online Restore

  • Parallel DBCC

  • Parallel Index Operations

    Management Tools

  • New Management Studio

  • MDX Query Editor

  • Version Control Support

  • XML/A

  • SQLCMD Command Line Tool

    Performance Tuning

  • Profiler Enhancements

  • Profiling Analysis Services

  • Exportable Showplan

  • Exportable Deadlock Traces

    MDAC

  • SNAC

  • Microsoft Installer base setup

  • Support for Active Directory Deployment

    SQL Client .NET Data Provider

  • Server Cursor Support

  • Asynch

    Security

  • All Permissions Grantable

  • Fine Grain Administration Rights

  • Separation of Users and Schema

  • Data encryption primitives

Replication

  • Auto-tuning Replication Agents

  • Oracle Publication

  • Improved Blob Change Tracking

  • Replication Monitor

    OLAP and Data Mining

  • Analysis Management Objects

  • Windows Integrated Backup and Restore

  • Web Service/XML for Analysis

  • DTS and DM Integration

  • New Data Mining Algorithms

  • Auto Packaging and Deployment

    Data Transformation Services

  • New Architecture (DTR + DTP)

  • Complex Control Flows

  • Control Flow Debugging

  • For Each Enumerations

  • Property Mappings

  • Full Data Flow Designer

  • Full DTS Control Flow Designer

  • Graphical Presentation of Pkg Execution

  • Immediate Mode and Project Mode

  • Package (Advanced) Deployment Tools

  • Custom Tasks and Transformations

    Reporting Services

  • Multiple Output Formats

  • Parameters (Static, Dynamic, Hierarchical)

  • Bulk Delivery of Personalized Content

  • Support Multiple Data Sources

  • STS (Web Parts, Doc Libraries)

  • Visual Design Tool

  • Charting, Sorting, Filtering, Drill-Through

  • Scheduling, Caching

  • Complete Scripting Engine

  • Scale Out architecture

  • Open XML Report Definition

    Notification Services & SQL Server CE


Orodja l.jpg
Orodja

  • Orodja za upravljanje in nadzor:

    • Enterprise Manager

    • Query Analyzer

    • SQL Server Management Studio

    • Business Intelligence Development Studio

    • SQL Computer Manager

    • SQL Server Books Online

    • Database Tuning Advisor



Novosti pri programiranju l.jpg
Novosti pri programiranju

  • .NET Framework V2.0

  • Nov XML podatkovni tip

  • Izboljšan T-SQL:

    • Lovljenje napak TRY..CATCH

    • DDL Triggers (CREATE, ALTER, DROP)

    • Rekurzivne poizvedbe


Service broker l.jpg
Service Broker

  • Novo v SQL Server 2005

  • Programski vmesnik za pošiljanje sporočil in ukazov

  • Namenjen za delo z aplikacijami, ki uporabljajo več podatkovnih baz

Shranjena procedura

Aplikacija

Service Broker

Aplikacija

T-SQL

Aplikacija


Novosti pri upravljanju l.jpg
Novosti pri upravljanju

  • Varnost

  • Sheme (User ≠ Schema)

  • Dinamična uporaba AWE spomina

  • Onemogočanje indeksov

    • Rebuild – manjša poraba prostora

  • Rebuild in Reorganize z ALTER INDEX



Novosti pri razpolo ljivosti l.jpg
Novosti pri razpoložljivosti

  • 8-node Cluster

  • 50 instanc na enem računalniku

  • Database mirroring

  • Database snapshots

  • Mirrored Backup

  • Restore


Novosti pri u inkovitosti l.jpg
Novosti pri učinkovitosti

  • Snapshot isolation level

  • Particioniranje tabel in indeksov

    • “Razbijanje” velikih tabel na manjše dele

  • Izboljšani indeksirani pogledi

    • Več uporabe s strani optimizerja

    • Uporaba funkcij v indeksiranem pogledu

  • Asinhrono posodabljanje statistik


Replikacija l.jpg
Replikacija

  • Enostavnejša izdelava (manj oken)

  • Vzporedna izdelava “snapshota”:

    • Več člankov hkrati

  • Uporaba “backupa” namesto “snapshota”

  • Replikacija iz Oracla

  • Replikacija pa HTTPS (merge replikacija)

  • Izboljšana učinkovitost:

    • Paralelno izvajanje


Integration services l.jpg
Integration Services

  • Popolnoma novi DTS: Integration Services

  • Novo orodje:Business Intelligence Development Studio

  • Ločena “Data flow” in “Control flow”

  • Možnost uporabe več virov in ciljev

  • Možnost ponovne uporabe vira ali cilja

  • Nova opravila

  • Novi podatkovni viri

  • Nove transformacije



Analysis services l.jpg
Analysis Services

  • Enostavnejša uporaba:

    • Business Intelligence Development Studio

    • Novi čarovniki

    • Novi pogledi

  • Nove funkcionalnosti:

    • Triggers

  • Izboljšanje komponente:

    • Kocke

    • Dimenzije

    • Data Mining

  • Nove razvojne možnosti


Reporting services l.jpg
Reporting Services

  • Izdelava, vzdrževanje in uporaba poročil

  • Formati poročil:

    • HTML, PDF, TIFF, Excel, CSV, …

  • Viri poročil:

    • SQL Server, Analysis Services, Oracle, ODBC, OLEDB


Notification services l.jpg
Notification Services

  • Prvič kot del SQL Serverja

  • Novo platforma za razvoj in uporabo aplikacij

  • Glavni funkcionalnosti:

    • Izdelava obvestil za aplikacije

    • Pošiljanje obvestil za aplikacije

  • Poenostavlja obveščanje med aplikacijami


Slide20 l.jpg

V & O

Danijel Novak,

danijel.novak@snt.si


ad