Looking at the docs for the Microsoft Oracle Connector, you can use LDAP for authentication - https://learn.microsoft.com/en-us/sql/integration-services/data-flow/oracle-connection-manager?view=sql-server-ver16.

It states that you can pick to use Windows Authentication or Oracle Authentication. Windows...

thx Brian.   Unfortunately you are seeing a mention about the speed issue out of context.   I was just trying to find COMMIT size here like i believe we used...

One thing to note about things being slower when run over VPN in SSIS, slower than where? Slower than the exact same workstation (laptop/desktop) being on site OR slower than...

I have not tested this script, but what about this link:

https://eitanblumin.com/2021/05/11/t-sql-tuesday-138-sp_help_revlogin-is-dead-long-live-sp_help_revlogin2/

Eitan Blumin has a script that he claims works to move logins and users across different systems. NOTE I have...

I too am curious how the project is going or went. I definitely wasn't trying to say "don't do it", I was just trying to say to be careful with...

I wonder if it is impatience on Steve Jones's part OR a configuration thing? I can't remember if the SQL services are set to auto-restart on unexpected stop or not,...

Index Optimization: Review and optimize indexes to ensure they complement the new primary key and do not degrade performance. Data Integrity Checks: Implement regular checks to ensure data integrity,...

My advice is actually going to be the opposite of a lot of others here - I wouldn't add any columns to the table or change the structure. The reason...

Just my 2 cents - shrinking any database is not a good idea. The DB grew to that size for a reason, and tempdb grew likely due to queries being...

Quick google, it looks like failback isn't something that happens with AG's. It is something you can set up, but it's not a setting in the AG. So when the...

I could be mistaken, but I think it depends on the configuration. I am hoping this is your test system and not live and if so, I'd say try it...

If you want a NICE tool for signing powershell scripts, I recommend this one:

https://www.idera.com/productssolutions/freetools/powershellplus/

Idera Powershell Plus. FREE tool which is always a huge plus, and it works really nice for...

To play devil's advocate, all of the applications I develop I design with a "quick drop" to SQL. What I mean by quick drop is that the application opens a...

My opinion - setting the execution policy to bypass is a bad idea on a desktop and a horrible idea on a server. Sign your script instead.

The reason it is...

I agree with Grant, I just wanted to add in another potential cause is drivers. For example, if you update your network drivers and you have your database storage on...