- [Instructor] So the next new feature we're going to talk…about in SQL Server 2017 are string functions,…and you may ask, string functions seem pretty silly…and simple, why are we bothering with this,…you know we've had things like concatenate…and substring for years.…If you've ever worked and programmed a lot…or written ETL type processing in T-SQL,…you know that there were a lot of limitations…as to what was built in for the product…and there were a number of things that many developers…would resort to using CLR.…If you're not familiar with CLR,…it's known as Common Language Runtime.…
And that's a function of SQL Server…that allows you to run .NET code.…There's a lot of security concerns, audit concerns,…and various things that are associated with .NET code.…And even though it was a very efficient way to do things,…some of that .NET code was much better…than trying to do the equivalent functionality in T-SQL.…Having this as native T-SQL functionality means a lot…to a lot of folks, and these are pretty good enhancements,…
- 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.