Course 10369: Managed Code and Windows PowerShell in Microsoft SQL Server 2008 R2

Introduction This two-hour course provides you with the knowledge and skills required to implement managed code and Windows PowerShell in Microsoft SQL Server 2008 R2.

This course covers the following topics.

• Describing managed code
• Importing and configuring assemblies
• Creating SQL Server objects using Managed Code
• Using Windows PowerShell to manage SQL Server
• Best practices for implementing managed code and Windows PowerShell in SQL Server 2008 R2

This course helps you prepare for Exam 70-433: Microsoft SQL Server 2008, Database Development.

The prerequisites for this course are as follows:

• A good general knowledge of database concepts.
• Experience working with Windows and programming concepts.
• Understanding of server management concepts such as roles and tracing.
• A basic understanding of XML.

Objectives At the end of the course, students will be able to:

• Describe managed code.
• Import and configure assemblies.
• Create SQL Server objects using Managed Code.
• Use Windows PowerShell to manage SQL Server.
• Describe best practices for implementing managed code and PowerShell in SQL Server 2008 R2.

Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Managed Code and Windows PowerShell in Microsoft SQL Server 2008 R2 Module Overview Introducing Managed Code in SQL Server 2008 R2 Introducing Managed Code in SQL Server 2008 R2 Introduction to Common Language Runtime Features of Common Language Runtime SQL Server 2008 R2 Integration Enabling CLR Integration Compare Managed Code and Transact-SQL Self Test Importing and Configuring Assemblies Importing and Configuring Assemblies Introducing Assemblies Importing and Configuring an Assembly in SQL Server Assembly Trust Levels Importing and Configuring Assembly in SQL Server Self Test Creating SQL Server Objects Using Managed Code Creating SQL Server Objects Using Managed Code SQL Server Objects that Use Managed Code Creating Stored Procedures, Functions and Triggers Creating Aggregates and User Defined Types Creating Objects Using Managed Code Executing Objects Using Managed Code Self Test Using Windows PowerShell to Manage SQL Server Using Windows PowerShell to Manage SQL Server What Is Windows PowerShell? SQL Server Provider in Windows PowerShell SQLServer Cmdlets Using Windows PowerShell to Execute SQL Commands Using PowerShell in the SQL Server Agent Self Test Best Practices Best Practices Lab: Managed Code and Windows PowerShell in Microsoft SQL Server 2008 R2 Lab: Managed Code and Windows PowerShell in Microsoft SQL Server 2008 R2 Scenario Exercise Information Launch the Lab Lab Review Module Summary Module Summary Glossary Glossary System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled