SQL 2014 Developer, Part 6 of 13: Advanced SQL CLR

In this course you will explore two kinds of code modules that can be implemented with only .NET code. Those are Aggregates and User Defined Types. These module types are not support by T-SQL You will also see how to improve performance with ordered tabled valued functions that return data that is already sorted by defining them correctly in the database.

Lesson 1:

• Aggregates
• Demo: Custom Code Attributes
• Demo: Implementing the Code
• Demo: Running the Aggregation
• Large Aggregates
• Demo: Large Aggregates
• Demo: Running Large Aggregate
• Multiparameter Aggregates
• Demo: Multiparameter Aggregate.

Lesson 2:

• Demo: User-Defined Type
• Demo: Handling Nulls
• Demo: Setting UDT Values
• Demo: Implementing Properties
• Demo: Implementing Methods
• Demo: Test User-Defined Type.

Lesson 3:

• Demo: Table-Valued Function
• Demo: Deploy and Test the Code
• Demo: Ordered List Function
• Demo: Execution Plans
• Demo: Lying to SQL Server.

Lesson 4:

• Demo: Assemblies
• Demo: Viewing Source Code
• Demo: Assembly Modules
• Demo: Procedures and Triggers
• Demo: Types
• Viewing Loaded Assemblies
• Demo: View Loaded Assemblies.