- [Narrator] Our next topic is SQL CLR on Linux…and if you are not familiar with CLR;…it's common language runtime;…this allows you to run .NET code…in the context of SQL Server.…You can create functions and stored procedures…that go beyond the scope of T-SQL.…These are commonly used to extend…the functionality of T-SQL.…The most common scenario I know…(mumbles) using regular expressions…and kind of before SQL Server introduced strings,…but functionality in 2016; that was another common usage.…People would do this.…You'd create a function in your database…and deploy it, well, a couple of things changed…and some of them title in x and some of them…just tied the changes in security for SQL Server 2017.…
The big thing is that CLR uses a Code Access Security…method in .NET and even though we had safe…and CLR prior to 2017 and we still have it.…You could mark a function as safe…and it could only do certain things.…That, according to the Windows theme is no longer accepted…as a valid security boundary, so in SQL Server 2017,…
- Querying with SQL Graph
- String functions in SQL 2017
- Adaptive query processing
- Docker containers and SQL
- Deploying CLR code with SQL Server on Linux
- Working with SQL Operations Studio
- Using snippets
- Code deployment using GIT
Skill Level Intermediate
1. New Features Overview
2. Adaptive Query Processing
3. SQL Server on Linux
4. SQL Server Operations Studio
Using snippets3m 57s
Next steps1m 39s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.