Developer's Guide to SQL Server CLR Integration

MP4 | AVC 212kbps | English | 1024x768 | 15fps | 5h 21mins | AAC stereo 127kbps | 931 MB

Genre: Video Training

Learn how to write and deploy CLR functionality written in .NET managed code into your SQL Server environment. You'll also get tips on when NOT to use CLR, as well as how to broach the topic with your database administrator.

Since SQL Server 2005, database stored procedures and functions can be written in .NET managed code targeted for the Common Language Runtime (CLR). This course walks the viewer through the steps required to create functions, stored procedures, triggers, aggregates, and user defined types with Visual Studio 2012. There is a specific module on how to approach a database administrator that may be less than eager to host CLR assemblies in SQL Server. There are also modules covering setup, permissions, troubleshooting, and times when it is not appropriate to use CLR in SQL Server.

Table of contents:

Introduction2m 35s

What Is a SQL CLR Extension?18m 7s

Why Not to Use CLR Extensions19m 1s

Setup and Requirements17m 38s

Quick Start16m 30s

Discussion Topics for Your DBA25m 40s

Functions1h 0m

Stored Procedures and Triggers47m 30s

Aggregates41m 55s

User Defined Types45m 43s

Troubleshooting26m 7s