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

Just was looking at that really long single line SQL and was trying to make it more pretty and there is some goofy stuff happening in your query. I see...

My opinion - that REALLY depends on the company. For example, if you have a license for SQL Prompt, I would recommend grabbing that.

But as a bare minimum, for a...