Developer's Guide to SQL Server CLR Integration

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 info
Rating
(77)
Level
Intermediate
Updated
Feb 25, 2015
Duration
5h 22m
Table of contents
Introduction
What Is a SQL CLR Extension?
Why Not to Use CLR Extensions
Setup and Requirements
Quick Start
Discussion Topics for Your DBA
Functions
Stored Procedures and Triggers
Aggregates
User Defined Types
Troubleshooting
Description
Course info
Rating
(77)
Level
Intermediate
Updated
Feb 25, 2015
Duration
5h 22m
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.

About the author
About the author

Kevin is a lifelong learner with over 30 years in the IT industry. He works on web and mobile applications as well as the databases and web services to support them. With a gift for learning new languages, he is able to rapidly apply his broad experience in new environments.

More from the author
Making Work from Home Work for You
Beginner
2h 28m
Oct 12, 2015
Managing Developers
Beginner
2h 36m
Jun 17, 2015
More courses by Kevin Murray