Róbert Kanász - blog venujúci sa programovaniu na platforme .NET
Prihlásiť
|
Registrovať
|
Pomoc
Domov
RSS
Atom
RSS komentáre
Aktualizácie emailom
Predplatiť
Vyhľadávať
Štítky
70-433
70-536
C#
MCTS
MS SQL Server
StopWatch
Navigácia
AspNet.sk
Vyvojari.sk
ITici.sk
Blogy
Archív
November 2011 (14)
October 2011 (7)
MCTS - Microsoft SQL Server 2008, Database Development - 70-433 - Objective List Part 5 (Working with Additional SQL Server Components)
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)
Publikované Wednesday, November 02, 2011 1:45 PM
kanasz.robert
Zaradené do:
MCTS
,
70-433
,
MS SQL Server
Komentáre
Bez komentárov