If the potential target tables of the package have the exact same structure, and you are using OLE DB connections, then in the "OLE DB Destination" task you can set...

I am not a licensing expert, but I believe Software Assurance may be required in the Active/Passive scenario.

It is typical to have separate surrogate keys in your data warehouse than your OLTP system.  Consider that there could be cases, especially in slowly changing dimensions, where the row...

A process I've used for many years to capture blocked process information is to use the built in Event Notification feature of SQL Server.  It uses the 
"Blocked Process Threshold"...

If you're not sure how a windows authenticated login is getting access to a database, there's actually a command to show all the access paths:
EXEC xp_logininfo N'mydomain\myuser','all';

The consideration on space usage is how many rows can you fit on a ~8KB data page.  The more data pages you need, the more I/O it takes to get...

I find it interesting how (most) people are willing to save space with numeric and temporal data types, but insist on using NCHAR and NVARCHAR even where they are not...

To change the setting use the ALTER DATABASE command.  Here's a nice article that describes the effects of the STATISTICS settings of ALTER DATABASE:
https://www.mssqltips.com/sqlservertip/2766/sql-server-auto-update-and-auto-create-statistics-options/

This command...

Another issue with name parsing to be aware of is how different cultures parse names.  You can't always assume that the "first" part of a name is the given name...

When looking at SQL Server memory utilization, I tend to take a top down approach.  Here's the first query I run to see high level info:
SELECT sm.total_physical_memory_kb...

Yes by default it would be accessing the file share as the account that SQL Agent service is running as.  The best practice for this type of scenario would actually...

If you are both connecting to the same database, perhaps the problem is the version of Management Studio you are using?
what happens if you try a query like this...

I do have a history with Oracle, but it's been quite a number of years since I've worked with it so I'd probably have to relearn a bunch of stuff. ...