In this video you will learn how to create Linked Server in SQL Server using SQL Server Management studio as well as T-SQL Script. It also explains best practices of creating Linked servers in SQL Server, when it is best idea to create linked server, requirement of remote synonyms to have Linked server created. Security best practices of Linked server and how to create linked server using other providers such as ODBC, SSAS and SQL Server client 11.0.
blog post link for this video:
http://sqlage.blogspot.com/2015/03/how-to-create-linked-server-in-sql.html
Visit our website to check out SQL Server DBA Tutorial Step by Step
http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
