- Integrate Database Mail.
- Database mail
- Database Mail Configuration Wizard
- sysmail_configure_sp
- How to: Convert Stored Procedures from SQL Mail to Database Mail (Transact-SQL)
- Database Mail Architecture
- Planning for Database Mail
- Database Mail XPs Option
- Database Mail Configuration Stored Procedures
- Database Mail Configuration Objects
- Mail Host Database
- Database Mail Views (Transact-SQL)
- Database Mail and SQL Mail Stored Procedures (Transact-SQL)
- Database Mail Profiles
- Database Mail Accounts
- How to: Create Database Mail Accounts (Transact-SQL)
- How to: Create Database Mail Private Profiles (Transact-SQL)
- How to: Create Database Mail Public Profiles (Transact-SQL)
- Implement full-text search
- Full-text search
- Full-Text Search Overview
- Full-Text Search Architecture
- Administering Full-Text Search
- Querying SQL Server Using Full-Text Search
- Troubleshooting Full-Text Search
- Full-Text Predicates and Functions Overview
- Supported Forms of Query Terms (Full-Text Search)
- Limiting Ranked Result Sets (Full-Text Search)
- Querying varbinary(max) and xml Columns (Full-Text Search)
- Querying Multiple Columns (Full-Text Search)
- Querying Linked Servers (Full-Text Search)
- Performance Tuning and Optimization of Full-Text Queries
- How Search Query Results Are Ranked (Full-Text Search)
- CONTAINS (Transact-SQL)
- CONTAINSTABLE (Transact-SQL)
- FREETEXT (Transact-SQL)
- FREETEXTTABLE (Transact-SQL)
- Stopwords and Stoplists
- CREATE FULLTEXT STOPLIST (Transact-SQL)
- How to: Create a Full-Text Stoplist (SQL Server Management Studio)
- ALTER FULLTEXT STOPLIST (Transact-SQL)
- How to: Change the Properties of a Full-Text Stoplist (SQL Server Management Studio)
- DROP FULLTEXT STOPLIST (Transact-SQL)
- CREATE FULLTEXT INDEX (Transact-SQL)
- How to: Start the Full-Text Indexing Wizard (SQL Server Management Studio)
- ALTER FULLTEXT INDEX (Transact-SQL)
- How to: View or Change the Properties of a Full-Text Index (SQL Server Management Studio)
- transform noise words Option
- sys.fulltext_stoplists (Transact-SQL)
- sys.fulltext_stopwords (Transact-SQL)
- sys.dm_fts_parser (Transact-SQL)
- Configuring Full-Text Linguistic Components
- Implement scripts by using Windows PowerShell and SQL Server Management Objects (SMOs)
- SQL Server PowerShell overview
- SQL Server PowerShell Help
- Running SQL Server PowerShell
- Using the SQL Server PowerShell Provider
- Using the SQL Server cmdlets
- Using SQL Server Identifiers in PowerShell
- Query Expressions and Unique Resource Names
- How to: Enable or Disable a Server Network Protocol (SQL Server PowerShell)
- Scripting (Database Engine)
- Using the Invoke-Sqlcmd cmdlet
- Using the Invoke-PolicyEvaluation cmdlet
- Microsoft.SqlServer.Management.Smo
- Microsoft.SqlServer.Management.Smo.Agent
- Microsoft.SqlServer.Management.Smo.Broker
- Microsoft.SqlServer.Management.Smo.Mail
- Microsoft.SqlServer.Management.Smo.Wmi
- Implement Service Broker solutions
- Service Broker Tutorials
- Benefits of Programming with Service Broker
- Service Broker Applications
- Planning for Service Broker Development
- Developer Responsibilities for Service Broker
- Service Broker Programming Concepts
- Creating Service Broker Objects
- Creating Service Broker Applications
- Transactional Messaging
- Controlling Transactions (Database Engine)
- BEGIN DIALOG CONVERSATION (Transact-SQL)
- BEGIN CONVERSATION TIMER (Transact-SQL)
- GET CONVERSATION GROUP (Transact-SQL)
- END CONVERSATION (Transact-SQL)
- MOVE CONVERSATION (Transact-SQL)
- RECEIVE (Transact-SQL)
- SEND (Transact-SQL)
- Broker System Messages
- Conversation Group Locks
- State Management
- Service Broker Application Outline
- CREATE QUEUE (Transact-SQL)
- Service Broker Activation
- Error Handling for Service Broker
- Contracts
- CREATE CONTRACT (Transact-SQL)
- DROP CONTRACT (Transact-SQL)
- Creating Service Broker Contracts
- Dialog Conversations
- BEGIN DIALOG CONVERSATION (Transact-SQL)
- BEGIN CONVERSATION TIMER (Transact-SQL)
- END CONVERSATION (Transact-SQL)
- SEND (Transact-SQL)
- RECEIVE (Transact-SQL)
- sys.transmission_queue (Transact-SQL)
- Conversation Groups
- sys.conversation_endpoints (Transact-SQL)
- sys.conversation_groups (Transact-SQL)
- Message Types
- Messages
- Queues
- CREATE QUEUE (Transact-SQL)
- ALTER QUEUE (Transact-SQL)
- DROP QUEUE (Transact-SQL)
- Services
- CREATE SERVICE (Transact-SQL)
- ALTER SERVICE (Transact-SQL)
- DROP SERVICE (Transact-SQL)
- Building Applications with Service Broker
- Remote Service Bindings
- CREATE CERTIFICATE (Transact-SQL)
- CREATE LOGIN (Transact-SQL)
- CREATE USER (Transact-SQL)
- Security and Protection (Service Broker)
- CREATE REMOTE SERVICE BINDING (Transact-SQL)
- ALTER REMOTE SERVICE BINDING (Transact-SQL)
- DROP REMOTE SERVICE BINDING (Transact-SQL)
- Routes
- Service Broker Routing
- CREATE ROUTE (Transact-SQL)
- Track data changes
- Configuring Change Data Capture
- Change Tracking
- Change Data Capture
- Comparing Change Data Capture and Change Tracking
- CHANGE_TRACKING_IS_COLUMN_IN_MASK (Transact-SQL)
- CHANGE_TRACKING_CURRENT_VERSION (Transact-SQL)
- CHANGE_TRACKING_MIN_VALID_VERSION (Transact-SQL)
- WITH CHANGE_TRACKING_CONTEXT
- CHANGETABLE
- Change Tracking Functions (Transact-SQL)
- Tracking Data Changes
- Change Data Capture Functions (Transact-SQL)
- Change Data Capture Stored Procedures (Transact-SQL)
- Change Data Capture Tables (Transact-SQL)
- Change Data Capture Related Dynamic Management Views (Transact-SQL)
Friday, July 29, 2011
MCTS - Microsoft SQL Server 2008, Database Development - 70-433 - Objective List Part 5 (Working with Additional SQL Server Components)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment