S

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]

SAC (Surface Area Configuration 2nd 3rd 4th
saving
    XML data to file
         C# stored procedure 2nd 3rd 4th
scalability 2nd
     asynchronous messaging 2nd
     Service Broker
scalable application architectures
SCC (Setup Configuration Checker)
SCC (System Configuration Checker)
scheduling
     cooperative thread scheduling
     nonpreemptive
scheduling nodes
schema
     creating 2nd
     default 2nd 3rd 4th 5th
     user-schema separation
     versus user
schema collections
schemas
     replication
Script Component transformation
scripter classes
scripting languages
     ASSL
Scripting tasks
scrubbing data
secondary XML indexes 2nd 3rd 4th 5th
securables
secure by default
secure by deployment
security
     Agent security, enhancements to
     auditing 2nd
     authentication 2nd
         endpoint-based 2nd 3rd
         limitations of in SQL Server 2000
         native password complexity
         password policy support 2nd 3rd 4th 5th 6th 7th
         passwords
         SQL Browser 2nd 3rd
     authorization
         granular permissions control 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th
         metadata, restricting access to 2nd 3rd 4th
         module execution context 2nd 3rd 4th 5th 6th 7th 8th 9th
         terminology
         user-schema separation 2nd 3rd 4th 5th 6th 7th 8th
     code access security in .NET Framework
         permissions 2nd
     cryptography
         data encryption 2nd 3rd 4th 5th 6th
         key management 2nd 3rd 4th 5th
     dimension-level 2nd
     encryption
     of Analysis Services
         granular permissions 2nd
     ownership chaining
     proxy accounts
     role-based 2nd
     SAC 2nd 3rd 4th
     Service Broker 2nd 3rd 4th 5th
     signed modules 2nd 3rd
         assigning permissions to users 2nd 3rd
     user schema separation 2nd
security architecture
selective aggregation
semicolon
     as statement operator
sending
     messages 2nd
sequence clustering
Sequence container 2nd
sequenced messages
SERIALIZABLE isolation level
server configuration options
     T-SQL enhancment
server-scoped permissions
server-side processing
     Service Broker solutions
Service Broker 2nd 3rd 4th 5th 6th 7th 8th 9th
     applications 2nd 3rd 4th 5th 6th
         batch processing
         data collection
         parallel processing
         server-side processing, distributing
     applications, backing up and restoring
     availability
     catalog views 2nd
     contracts
         creating 2nd
     conversation groups
     dialog conversations 2nd
         starting 2nd
         terminating
     disabling 2nd
     enabling 2nd
     endpoints 2nd
         creating 2nd
     message forwarding 2nd
     message types 2nd
         creating 2nd
     messages
         sending and receiving 2nd
     monitoring 2nd 3rd
     Perfmon counters 2nd
     poison messages 2nd
     Profiler trace events 2nd
     queues
         creating 2nd
     remote service bindings
     routes 2nd 3rd
     security 2nd 3rd
     sequenced messages
     service programs
     services
         creating 2nd
     terminology
     troubleshooting 2nd
     unsequenced messages
     versus BizTalk Server
     versus Indigo
     versus MSMQ
service programs
services
     creating 2nd
SET SHOWPLAN XML statement
     T-SQL enhancement 2nd
SET STATISTICS XML operator
     T-SQL enhancement 2nd
setup enhancements 2nd
Setup Progress dialog box
showplans
signed modules 2nd 3rd
     assigning permissions to users 2nd 3rd
single-page allocator
Slowly Changing Dimension transformation
SMO (SQL Server Management Objects
SMO (SQL Server Management Objects) 2nd 3rd 4th 5th 6th
SMP (symmetric multiprocessing 2nd
SNAC (SQL Native Client)
snapshot isolation 2nd 3rd 4th
     isolation levels 2nd
     row versioning 2nd 3rd
     T-SQL enhancements 2nd
snapshot isolation level
snapshots
     copy-on-write operation
     creating 2nd
     recovering deleted tables 2nd 3rd
     sparse files 2nd
snowflake schema
software requirements for installation
Solution Explorer
Sort transformation
source adapters
source data adapters
sparse files
     database snapshots 2nd
split-brain scenarios
SQL Authentication
SQL Browser 2nd
     running in low-privileged accounts
SQL DMO (Distributed Management Objects
SQL Profiler tool
SQL Server 2005
     platform support
SQL Server 2005 Express Edition 2nd
SQL Server 2005 Profiler
     blocked process report 2nd 3rd 4th 5th
     deadlock graphs 2nd 3rd 4th 5th
     features 2nd 3rd 4th
     XML showplans
         obtaining 2nd
SQL Server 7.0 Service Pack 4
     upgrading to SQL Server 2005 2nd 3rd
SQL Server Books Online
SQL Server Configuration Manager 2nd 3rd 4th
SQL server log files
     viewing 2nd
SQL Server Management Studio 2nd 3rd 4th 5th 6th
     built-in web browser
     creating new databases 2nd
     modifying server instance properties 2nd
     Object Explorer window 2nd
         nodes 2nd
     performing database backups
     performing server administration
     projects
     Query Editor windo
     Query Editor window 2nd
         keyboard shortcuts 2nd
     Registered Servers window
     tables 2nd 3rd 4th
     usability enhancements
SQL Server Mobile Edition 2nd
SQL Server tasks
     Execute SQL task
SQLCLR
     comparing with T-SQL 2nd 3rd 4th
SQLCLR integration
     assemblies
     benefits of 2nd
     catalog views 2nd
     challenges 2nd
    examples of
         base-64 encoding and decoding 2nd
         saving XML data to file 2nd 3rd 4th
     monitoring activity 2nd 3rd
    permission buckets
         imported assemblies 2nd
SQLCMD 2nd
     command-line switches 2nd 3rd
     commands
     dedicated administrator connection
     environment variables 2nd 3rd 4th
     startup scripts 2nd
     variables 2nd
SQLOS 2nd
     memory management
         architectural components
         BPool
         common caching framework
         Dynamic AWE 2nd
         hot add memory
         reserved address space
         resource monitor 2nd
     non-preemptive scheduling
    threads
         max worker threads server configuration option 2nd
     UMS
         thread scheduling 2nd
SSIS
     BIDS
         Breakpoint window
         Call Stack window
         Command window
         Debug window
         Immediate window
         Locals window
         Output window
         Properties window
         Solution Explorer
         SSIS Designer window 2nd
         Toolbox window
         Watch window
     clients
     command-prompt utilities
         DTExec
         DTExecUI
         DTUtil
    control flow
         separation from data flow
     core components
     data flow engine
     destination adapters
     DTS runtime engine
     events 2nd
     Import/Export Wizard
    packages
         designing 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th
     progress reporting
     SQL Server Management Studio
     tasks
         control-flow tasks 2nd 3rd 4th 5th 6th
         Data Flow task
         data-flow tasks 2nd 3rd
         process-oriented workflow tasks
     transformations
     Windows service
SSIS (SQL Server Integration Services) 2nd 3rd 4th
SSIS Configuration Wizard
SSIS Designer window 2nd
SSIS expressions
SSIS Import/Export Wizard
SSIS Migration Wizard 2nd 3rd 4th 5th
SSIS object model 2nd 3rd 4th
SSIS package designer 2nd
SSMS (SQL Server Management Studio
Standard Edition
star schema
starting
     dialog conversations 2nd
startup scripts(SQLCMD) 2nd
statement operators
     semicolon
statement-level recompilation 2nd 3rd 4th
     new T-SQL enhancement
     T-SQL enhancment
statements
    ALTER INDEX
         new T-SQL enhancement 2nd
statistics management
     AUTO UPDATE STATISTICS ASYNC database option
     column-level change tracking
     computed columns
     enhanced DBCC SHOW STATISTICS results
     parallelism
     sample size formula
     string statistics
storage engine 2nd
     AUs 2nd
     datafile autogrow
     instant file initialization
     MPIO
     partitioning
stored procedures (C#)
     saving XML data to file 2nd 3rd 4th
storge engine
string statistics
supported platforms on SQL Server 2005
supported technologies
     CLR 2nd 3rd
         as replacement for extended stored procedures
     snapshot isolation 2nd
     XML
Surface Area Configuration tool
symmetric keys 2nd 3rd 4th
     key management 2nd 3rd 4th 5th
synchronous mode (database mirroring) 2nd
synonyms
     T-SQL enhancement 2nd
sys.sysobjvalues table
system catalog 2nd
system metadata
     access, controlling
         catalog security 2nd
         catalog views 2nd
     Resource database 2nd
         accessing
system tables
     accessing