2015
Pluralsight
Kevin Murray
5h 21m
English
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.
Introduction
001.Introduction 2:35
What Is a SQL CLR Extension
002.Introduction 0:05
003.What It Is 4:08
004.Managed Code 1:43
005.SQL Server Hosts CLR 2:04
006.CLR Capabilities 0:38
007.Functions 0:41
008.Procedures and Triggers 1:36
009.Aggregates and Types 2:12
010.Replaces Extended Stored Procedures 0:40
011.CLR vs. TSQL 1:42
012.Why Use 2:00
013.Summary 0:32
Why Not to Use CLR Extensions
014.Introduction 0:40
015.Personal Reasons 5:16
016.Business Logic 1:33
017.Validation vs. Rules 4:23
018.Performance 4:10
019.Deployment 2:07
020.Summary 0:50
Setup and Requirements
021.Introduction 3:54
022.Permission Assumptions 2:01
023.Verify .NET 3.5 0:51
024.AdventureWorksLT2008 3:47
025.AdventureWorksLT2008 Schema 0:51
026.DBO Membership 1:35
027.Enable CLR 1:32
028.Safe and Unsafe Assemblies 2:06
Quick Start
029.Summary 0:58
030.Introduction 0:15
031.Create New Project 1:44
032.Add New Function 2:26
033.Modify Function 1:55
034.Target Platform 1:25
035.Database Connection 1:08
036.Publish 1:31
037.Test 3:01
038.Allow for Null 2:16
039.Summary 0:46
Discussion Topics for Your DBA
040.Introduction 0:16
041.A Few Tips 2:49
042.DBA Concerns 1:21
043.Security 1:54
044.Data Integrity 2:05
045.Performance 3:24
046.Stability 3:49
047.Maintainability 2:58
048.Code Comfort 4:21
049.General Rules 1:47
050.Summary 0:51
Functions
051.Introduction 0:10
052.Overview 1:20
053.Regex vs. Patindex 1:20
054.Regex Explain 2:09
055.RegexMatch 10:06
056.Compile Regex 1:26
057.SqlString vs. SqlChars 1:53
058.WordsToTable 12:08
059.Alternate Code 3:40
060.DataAccess and SystemDataAccess 2:09
061.IsDeterministic and IsPrecise 2:47
062.FillRowMethodName 0:48
063.ProductToJson 16:23
064.Hints 3:42
065.Summary 0:45
Stored Procedures and Triggers
066.Introduction 0:44
067.Stored Procedure Intro 1:51
068.Stored Procedure Code 13:26
069.Name Attribute 1:03
070.Trigger Intro 2:29
071.Trigger Code 25:20
072.Trigger Attributes 1:25
073.Summary 1:08
Aggregates and User Defined Types
074.Introduction 1:35
075.Aggregate Processing 1:27
076.AVG Replacement 0:44
077.AVG Replacement Demo 1:38
078.Create Aggregate 0:25
079.Create Aggregate Demo 20:59
080.First Test 4:21
081.Final Test 6:42
082.Aggregate Attributes 1:36
083.SQLFacet 1:37
084.Summary 0:48
User Defined Types
085.Introduction 0:48
086.Use Case 4:42
087.Project Start 7:26
088.Constants 5:46
089.Project Methods 4:43
090.Catalog Pricing 4:04
091.Testing 7:52
092.New Table 2:51
093.User Defined Type Attributes 2:28
094.Deployment Strategies 4:10
095.Summary 0:50
Troubleshooting
096.Introduction 0:43
097.Permissions 0:42
098.Create Assembly From DLL 3:42
099.If You're Not DBO 1:55
100.Create Assembly From Visual Studio 2:35
101.EXTERNAL_ACCESS 4:47
102.SqlString vs. SqlChars 4:27
103.Unresolved Reference 1:46
104.Database Import Errors 2:06
105.Drop Assembly 2:13
http://pluralsight.com/
Download File Size:909.02 MB
|
