Viewing 15 posts - 661 through 675 (of 2,917 total)
My opinion - blocking outgoing traffic is only required if there is a risk of the server being compromised. If you can download and install arbitrary applications on the server...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 7, 2022 at 3:01 pm
If I understand your question right, you are asking if you can add an index to a table on production while users are using the table. If so, yes. It...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 4, 2022 at 5:21 pm
Found an old article on this, but I expect it is still valid:
I would recommend doing it on a test system first and trying things out and once you are...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 4, 2022 at 3:40 pm
I've noticed this too. For me, I usually get that error if I wait too long to click on "Submit" after loading the page. Like if I load the page,...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 4, 2022 at 3:33 pm
Just to confirm something - what does the network traffic look like on the AG instances?
My thought here is that your non-AG instances seem to be working fine, but the...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 4, 2022 at 3:32 pm
If you configured the publisher and subscriber on the local system, then nothing should be going to Azure.
My understanding of replication is that you need to have a publisher which...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 4, 2022 at 3:21 pm
My opinion - Profiles (and all other database mail configuration stuff) should be handled by the DBA, not by "corporate people". Heck, the SQL Server install should be done by...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 4, 2022 at 2:26 pm
If replication from on-prem to the cloud works without firewall changes, I would be suspect of your firewall. I would double and triple check your firewall configuration to make sure...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 4, 2022 at 2:17 pm
As far as I know, every time I set up a new instance, I re-setup the mail profile. I currently use the GUI for it as I lost my mail...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 3, 2022 at 10:32 pm
Pretty sure SQL doesn't log that information. In general, I have found that I don't care who created an index, I just care that the correct indexes are created. Only...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 3, 2022 at 10:24 pm
I think it is one of those "it depends" scenarios. If the column is named $$SomeName, then yes, the $'s are part of the column name.
If it is not a...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 3, 2022 at 10:18 pm
I can't speak to replication from on-prem to cloud as I've not done that, but you ask what other options do you have and there are options. You could use...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 3, 2022 at 2:21 pm
Sounds like you are missing the Visual C redistributable package (VC_red.msi is the Visual C REDistributable package).
I would look for a copy of KB3045321 from Microsoft and HOPE they still...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 1, 2022 at 7:48 pm
As far as I am aware, and if I am understanding what you are saying, you can't do that. I am PRETTY sure that SSDT would push across all of...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
February 1, 2022 at 7:39 pm
I am 99.999% sure that an INSERT failure is going to be different than a failed login error. The INSERT failure sounds like you are modifying a maintenance plan with...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
January 31, 2022 at 8:04 pm
Viewing 15 posts - 661 through 675 (of 2,917 total)