how much memory does the SERVER have in total and how much is dedicated to SQL Server? If I am reading your question correctly,  you have 300 GB RAM on...

As someone who has had (and currently has) VPN access on their phone AND RDP access on my phone, I do not recommend it. While it is possible, it is...

Just to add to what Jo Pattyn said, there are a lot of reasons why a thing can be fast in SSMS and slow in applications. You could have some...

Just my 2 cents on this - I wouldn't rely on "ping". PING will only tell you that the computer is online assuming ICMP isn't disabled at the firewall. It...

Another thing to note - SQL Server, with the default configuration, will use up to 2 PB of memory or whatever is available in the system. In order to reduce...

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...

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 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...