Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

managed code 2nd

managed objects

management and authoring tools

     BI Development Studio

         Analysis Services projects designer 2nd

         Express Manager

         Reporting Services 2nd

         SSIS package designer 2nd

     SQL Server Management Studio 2nd 3rd

         built-in web browser

         creating new databases 2nd

         modifying server instance properties 2nd

         Object Explorer window 2nd 3rd 4th

         performing database backups

         performing server registration

         Query Editor window 2nd 3rd 4th 5th

         Registered Servers window

         tables 2nd 3rd 4th

managing system metadata access 2nd 3rd

     catalog security 2nd

     catalog views 2nd

many-to-many dimensions

markup languages,XML [See XML]

MARS (multiple active results sets

max specifier

measures

member properties

members

memory management

     architectural components

     BPool

     common caching framework

     Dynamic AWE 2nd

     hot add memory

     NUMA

     plan cache

     reserved address space

     resource monitor 2nd

Merge Join transformation

merge replication

Merge transformation

message forwarding 2nd

message types

    Service Broker

         creating 2nd

message types (Service Broker) 2nd

messages

     sending and receiving 2nd 3rd 4th

messaging

     asynchronous

         benefits of 2nd

         database integration 2nd

    BizTalk Server

         versus Service Broker

    Indigo

         versus Service Broker

     MSMQ

     Service Broker 2nd 3rd

         catalog views 2nd

         contracts

         conversation groups

         dialog conversations 2nd

         endpoints 2nd

         message forwarding 2nd

         message types 2nd

         monitoring 2nd 3rd

         Perfmon counters 2nd

         poison messages 2nd

         Profiler trace events 2nd

         queues

         remote service bindings

         routes 2nd 3rd

         security 2nd 3rd

         sequenced messages

         service programs

         services

         troubleshooting 2nd

         unsequenced messages

metadata

     accessing

     restricting access to 2nd 3rd 4th

metadata views 2nd

methods

     modify() 2nd 3rd

     of xml data type

     xml data type methods (XQuery)

Microsoft .NET Framework

Microsoft SQL Server 2000

     tools, equivalent SQL Server 2005 tools

Microsoft's Trustworthy Computing initiative

migrating

     DTS 2000 packages to SSIS 2nd 3rd

     from Analysis Services 2000 to Analysis Services 2005 2nd 3rd 4th

mirror database

mirrored backup media

     performing backups 2nd 3rd

mirroring

     benefits of 2nd 3rd

     configuring 2nd

     monitoring 2nd

     operation modes

         asynchronous mode 2nd

         synchronous mode 2nd

     pausing

     server instances

     split-brain scenarios

     versus log shipping

Mobile Edition

modify() method 2nd 3rd 4th

modifying

     properties of assemblies

modifying server instance properties with SQL Server Management Studio 2nd

module execution context

     EXECUTE AS clause 2nd 3rd 4th 5th 6th

     limitations of ownership chaining 2nd

modules

     signed 2nd 3rd

         assigning permissions to users 2nd 3rd

MOLAP (Multidimensional OLAP

monitoring

     blocking

     blocking with blocked process threshold

     database mail 2nd

     database mirroring 2nd

     locking and blocking 2nd 3rd

     Service Broker 2nd 3rd

     SQLCLR activity 2nd 3rd

monolog

MPIO (multi-path I/O

MSMQ

MSMQ (Microsoft Message Queuing) 2nd 3rd

multi-instance support

multi-page allocator 2nd

Multicast transformation

multiple fact tables

     support for on Analysis Services 2005

multiple hierarchy dimensions

multiple instance support