CodeWithAbby

Its a very common requirement. There is a database at some location across the globe. The database tables contain millions of rows. We are to pull/fetch those rows and insert/update into our local database. There are several solutions suggested but the best one I have tried  and found very useful is by using   LINKED SERVER . Liked server can be created among the servers across the globe. They may be SQL server generally or one may be some other database as well. Using and creating Linked server does have the following advantages: Remote Server Access The ability to issue distributed queries, commands and transactions on heterogeneous data sources across the enterprise/different locations Let's explain it further : Suppose there is one SQL server at the IP  10.112.79.83  [Located at NY suppose] and    my current SQL server is in India. I want to get all the rows from that server. Typically without Linked server, its very difficult to perform this. We can do this using linked server

  What is Intellicode? Visual Studio IntelliCode (IntelliCode) is a set of AI-assisted capabilities that improve developer productivity with features like  contextual IntelliSense ,  argument completion ,  code formatting , and  style rule inference . Intellicode in Visual Studio 2019 We can see in the below example that when user tries to see the intellisense for a string variable : Visual studio 2017 (which is not got the intellicode enabled) shows the traditional intellisense items (i.e. Aggregate<>, All<> etc.). This doesn't take care of the context. The current context is , we are trying to compare something in the if block. we would either be finding length , find index of , contains etc.) But this is not showing up the same. Visual Studio 2019 (which has got intellicode enabled) shows all relevant intellisense item (which are as per the current context).  Sample Code in Visual Studio 2017 (with NO intellicode): Sample Code in Visual Studio 2019 (with intellicode)