Join Brian Randell for an in-depth discussion in this video What you should know, part of DevOps for the Database with TFS 2018.
- For this course it will be helpful if you have a computer running a modern version of an X64 bit version of Windows. The demos that I'm going to do for you were built within a domain environment using Windows 10 1709 Enterprise edition along with multiple servers running Windows server 2016. My environment is fairly complicated because I wanted to show you a real world configuration. That said, you don't need to set up 17 machines like I did.
You can just use one computer with Windows with Visual Studio 2017 15.5, any edition will do. Now when we talk about editions, we're talking about community, professional or enterprise. When I show you my demos in Visual Studio I'll be running the enterprise edition. But you don't need that. The key thing is that when you install it, you want to make sure you pick up at least three of the workloads; .NET desktop development, ASP.net and web development and the data storage and processing workload.
These three workloads will put all the tools you need in Visual Studio including SSDT, a critical tool we're going to use as part of our data base DevOps process. You'll also like to have a copy of SQL Server 2017 Developer Edition with the latest cumulative update installed for security and performance. You might want to install SQL server management studio as well. Finally, installation of Team Foundation Server 2018, with at least one build/release and test agent configured.
To be clear, that is one agent that does all three things for you. The bottom line is, while I'm using multiple machines, you can do this yourself on a single machine with enough RAM and disc space. On the other hand, feel free to be crazy and build as many machines as you think is necessary to mimic your production environment. Now, assuming you have the right software, What should you know? Well, I'm going to assume you know how to use Windows, basic concepts, navigating around. You'll definitely want to have basic comfort with Visual Studio 2017 and you need some basic Team Foundation Server knowledge.
In addition, I'm assuming you understand SQL server, the concept of tables, views, store procedures. We're not going to spend too much time doing code, but it is useful to have had some basic experience. At the end of the day, I'm going to teach you about database DevOps with Team Foundation Server 2018 so I'm not going to go super deep on the practices of Team Foundations server or building SQL server databases. There's lots of other great courses in the Linked In library that you can watch and I'll even reference some during the course.
- Team Foundation Server (TFS) 2018
- SQL Server Data Tools (SSDT)
- Configuring version control of a SQL database
- Installing and importing a database
- Setting up users, team build, agents, and pipelines
- Handling changes, branching, and merging
- Making local deployments
- Building a database for SQL Server
- Continuous integration
- Continuous deployment
- Working with multiple groups and environments
- Testing databases using frameworks
- Working with static data and data motion
- Versioning a database
Skill Level Intermediate
1. Tooling Overview
2. Version Control Your Database
3. Build Your Database
4. Release Your Database
5. Test Your Database
6. Real-World Issues
- 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.