SQL Server: Compare Database Tables/Indexes/Views/SP’s etc. For Differences Across Instances

There are a bunch of tools in the market to do the database comparisons for differences but if you want to do it for free (and programmatically)  at a basic level, you could use the method outlined below. For me, this came about as a result of an user asking "So, what is different between …

Advertisement

SQL Server: Curse Of Linked Server Security And The Fix: Pass-through Authentication

A great and related reference to what we will discuss in this blog post is this one: https://thesqldude.com/2011/12/30/how-to-sql-server-bulk-insert-with-constrained-delegation-access-is-denied/ Linked Servers in a sentence or two: Linked servers in SQL Server are connection definitions from one data source to another (or same instance) so that queries can be written joining tables spanning the multiple data sources. Although …

SQL Server: Using Data From Another Instance To Drive Logic In Current Instance (Using Linked Server)

Data is in another DB/Instance - but logic needs to be in this DB/instance Your logic in the current database/instance sometimes is driven by data in a completely separate SQL Server instance. People do this using different methods Use LinkedServer to bring over and join data Use SSIS or another mechanism to copy the data …

Setup a Linked Server to MS Access from SQL Server – Beat the errors

Normally, it is easy enough to setup a Linked Server on SQL Server to other data sources. Problems are usually caused by one of the usual culprits that have to be addressed SQL Logins simply do not work well when trying to do this type of setup The Windows login has to have permissions to the …