Description

SQL Server 2008 R2 provides many components to ensure that database developers can perform many tasks within the database without having to create custom applications. SQL Server’s Service Broker component allows developers to create applications that can work with other SQL Server components to complete a specific task by communicating using messages to relay the task information within the instance or between instances of SQL Server 2008 R2. SQL Server 2008 R2 also offers a way for developers to track changes within the database using either change tracking or change data capture. SQL Server’s full-text search component can be implemented to ensure that specific data is returned based on search words and phrases. PowerShell has been integrated into SQL Server and offers cmdlets to perform actions on database objects using methods within SQL Server Management Object (SMO) models, and to run scripts to perform tasks within SQL Server. Developers can also use Database Mail to send messages to mail accounts within a profile. This course demonstrates how to implement Server Broker, change tracking, full-text search, and Database Mail. It also demonstrates how to invoke and use PowerShell to run scripts and perform actions on objects. This course is one of a series in the Algeo learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.