Developer's Guide to SQL Server CLR Integration
Pluralsight
Course Summary
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.
-
+
Course Description
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.
-
+
Course Syllabus
Introduction- 2m 35s
—Introduction 2m 35sWhat Is a SQL CLR Extension?- 18m 7s
—Introduction 0m 5s
—What It Is 4m 8s
—Managed Code 1m 43s
—SQL Server Hosts CLR 2m 4s
—CLR Capabilities 0m 38s
—Functions 0m 40s
—Procedures and Triggers 1m 36s
—Aggregates and Types 2m 12s
—Replaces Extended Stored Procedures 0m 40s
—CLR vs. TSQL 1m 42s
—Why Use? 2m 0s
—Summary 0m 32sWhy Not to Use CLR Extensions- 19m 1sSetup and Requirements- 17m 38sQuick Start- 16m 30sDiscussion Topics for Your DBA- 25m 40sFunctions- 1h 0mStored Procedures and Triggers- 47m 30sAggregates- 41m 55sUser Defined Types- 45m 43sTroubleshooting- 26m 7s