- [Narrator] Most of modern development…is focused on continuous integration…and continuous deployment methodologies.…These have been slow to make it into the database world.…But in recent years, we've been seeing lots…and lots of customers that have shifted to this model.…It allows you to build faster,…make smaller incremental changes,…have lower risk for failure,…and generally, you build an automated…testing processes into these solutions.…In this video, you're going to see how this…can work with SQL Operations Studio,…and we're going to tie into GitHub.…So currently, SQL Operations Studio doesn't…ship with the ability to create DACPAC and BACPAC files,…which is one of the ways we would…traditionally do our deployments,…especially in a waterfall methodology,…where you do a big push of a DACPAC up to your database.…
And if you're not familiar with those two terms,…they're basically just an export of either…your schema or your schema plus your data.…However, this does integrate with GitHub.…So, you can save and deploy your source code there.…
- 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.