Viewing 15 posts - 856 through 870 (of 2,917 total)
For me, I don't manage the hardware side of things, so I care less about the hardware and actually have very little say in what hardware I get. It is...
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.
November 4, 2021 at 2:17 pm
You say you are using an application - is there a reason you are not just pulling the Excel data in through that rather than using SQL Server as 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.
November 3, 2021 at 2:03 pm
To me it looks like your statistics are out of date. Your estimates are WAY off from the actuals which usually indicates bad statistics.
I would start there.
Another thing - I...
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.
November 3, 2021 at 1:41 pm
I agree with both Phil and Michael. Phil's comment about query store sounds like it is similar to Oracle's AWR. Or so is my my understanding of query store.
And Michael...
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.
November 2, 2021 at 8:53 pm
My opinion - I wouldn't reinvent the wheel. There are a LOT of good monitoring tools out there and I would just use one of those.
The good SQL monitoring tools...
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.
November 1, 2021 at 4:56 pm
Script debugging is always interesting. The "best" (ie only) way I know how to do it is to find good breakpoints and run your code up until that breakpoint. Next,...
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.
November 1, 2021 at 2:46 pm
I think I can answer both questions, but I would still recommend doing it in a test environment first.
So question 1 - my understanding is that SSRS hasn't had any...
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.
November 1, 2021 at 1:50 pm
Jeff - your approach is what our devs (myself included) are migrating to (I think). Basically, the connection string gets stored in a settings file that is read on app...
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.
October 30, 2021 at 5:57 pm
As a guess - I would say that WinSCP probably has a list of valid fingerprints stored somewhere and when you connect, it checks the fingerprint against the known good...
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.
October 30, 2021 at 5:51 pm
That makes sense as the fingerprint is the fingerprint of the remote server.
I would recommend looking at some of the example scripts on the WinSCP site. This one specifically should...
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.
October 29, 2021 at 5:55 pm
I would check to make sure the input is valid. Double check the values you are passing into the properties of WinSCP. For example, check the value of "$config.Configuration.HostName". is...
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.
October 29, 2021 at 5:02 pm
On top of what ratbak indicated - when you say "Azure SQL", do you mean it is an Azure SQL Instance, an Azure SQL Managed Instance , or an Azure...
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.
October 29, 2021 at 4:54 pm
I expect you would get more help in a C# forum than a SQL Server forum, but I would reach out to your development team and work with them to...
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.
October 29, 2021 at 3:13 pm
Brandie - are you using SQL Aliases OR DNS Aliases? If it is DNS aliases, you will likely need to include the instance name (for a named instance) when you...
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.
October 29, 2021 at 2:57 pm
I am pretty sure that SQL Configuration Manager aliases just put aliases on the server or on one individual workstation, not on all the client machines (don't quote me on...
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.
October 28, 2021 at 8:56 pm
Viewing 15 posts - 856 through 870 (of 2,917 total)