Configure linked servers

- [Instructor] In this video,…we're going to take a look at linked servers…in SQL Server 2016.…Now typically, linked servers are configured…to enable your database engine…to execute Transact-SQL statements…against another instance of SQL Server…or perhaps another database such as an Oracle database.…And many types of OLE DB data sources…can be configured as linked servers,…including Microsoft Access and even Microsoft Excel.…Linked servers offer the advantages…of the ability to access data…from outside of SQL Server, the ability to issue…distributed queries, updates, and commands,…as well as transactions on heterogeneous data sources,…and also the ability to address…diverse data sources similarly.…

In other words, your developers can simply write…Transact-SQL statements that they're familiar with…while they're accessing data that sits on other systems.…So what we're going to do is demonstrate…how to set up a linked server, and in the first instance…of SQL Server that we have is our standard one…that we've been using for the demo so far,…